Tuesday, October 19, 2010

Content Management Systems

Joomla = makes websites, manages sites, blogs and polls, flexibility, easy to use.

Drupal = same as above

Word Press = mainly blogging but also same as the two above

Moodle = education based, interactive, classes students

Zen Cart = shopping and e commerce

Monday, October 18, 2010

Select Operation

Public Class Form1

    'START OF DATABASE OPERATION!!!!!!

    Private Sub btnGetCustomerNames_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGetCustomerNames.Click

        Dim strConnectionString As String = "Provider = Microsoft.Ace.OLEDB.12.0;" & _
        "Data Source = F:/MyFolder/Filters.accdb "

        Dim MyConnection As New OleDb.OleDbConnection(strConnectionString)

        MyConnection.Open()

        Dim MyCommand As New OleDb.OleDbCommand("SELECT * FROM customers", MyConnection)

        Dim MyDataSet As New Data.DataSet

        Dim MyDataAdapter As New OleDb.OleDbDataAdapter(MyCommand)

        MyDataAdapter.Fill(MyDataSet, "QueryResults")

        MyConnection.Close()

        'END OF DATABASE OPERATION!!

        LstCustomerNames.DataSource = MyDataSet.Tables("QueryResults")

        LstCustomerNames.DisplayMember = "FirstName"

        LstCustomerNames.ValueMember = "CustomerID"

    End Sub
End Class

Blog Task: Warning

Using the NullReferenceExceptionDemo project:

    1. What warning does the Visual Studio IDE provide with regards to using variables before they have been assigned a value? What does the warning look like? What does it say?
    2. Comment out the incorrect code and uncomment the correct code. Substitute the string parameter “Rach” with your own name.
    3. Post a screen shot of the resulting message box.

Connection String to a Database String

Applications and Databases

We keep them separate

1 Connection string -Address of the supermarket

DB Drivers
Path to DB

2 Connection Object - Car/Road
Using the connection string

3 Command Object-Shopping List
SQL statement to be executed
Using the connection object

4 Data Adapter- The Shopper
Uses the connection object
Retrieves Items

5 Data set- The Pantry
Select- No Mod
Insert- creates a new record
Update- Edit
Delete

4 and 5 only used during the SELECT process