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
Tuesday, October 19, 2010
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
'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:
- 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?
- Comment out the incorrect code and uncomment the correct code. Substitute the string parameter “Rach” with your own name.
- Post a screen shot of the resulting message box.
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
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
Sunday, October 17, 2010
Subscribe to:
Posts (Atom)