typed dataset

[fmardani]

Hi,
I have created a project which uses typed datasets.
BUT I used the wizard to create the sqlConnection and the sqlDataadapter.
Do you know if there is a good site that shows how to do this (i.e. a small project) which uses typed dataset but using code to create the connection and dataadapter?
Thanks

[DragonQ]

Is this what you're looking for?

Dim DBPath As String = = Application.StartupPath & "Database\Database1.mdb"
 
            If Connection2.State <> ConnectionState.Closed Then Connection2.Close()
 
            Connection2.ConnectionString = "[b]Data Source=" & Chr(34) & DBPath & Chr(34) & _
"[/b];Jet OLEDB:Engine Type=5;Provider=" & Chr(34) & "Microsoft.Jet.OLEDB.4.0" & Chr(34) & ";"
            Connection2.Open()
            da1.Fill(dsTable1.Table1)