Exercises
If you create a database
and use the following source (and test it out) you'll be all ready for
tomorrow -
<%@
Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.Oledb" %>
<script language="VB" runat="server">
Sub Page_Load(sender as object, e as eventargs)
Dim objConn as New OleDBConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=e:\sff\site\db\users.mdb")
objConn.Open()
Dim ds as Dataset = New DataSet()
Dim objAdapter as New OleDbDataAdapter("SELECT * FROM users", objConn)
Dim objCmdBld As New OleDbCommandBuilder(objAdapter)
objAdapter.Fill(ds, "users")
End Sub
</script> |
That is using exactly the same stuff we have been doing here. Just remember to
change the Data Source when you do it.
Summary
In this part we have
learnt about most of the OleDb variety of managed providers and seen how
useful they are.
In part two we will examine the dataset and how you will be blown away with
its complexity.
See ya there!
wisemonk@aspalliance.com