Using vb net web query interaction to retrieve data from Access Database

Using vb net web query interaction to retrieve data from Access Database

Hello Belensienna ,
Hope that my message finds you well.
Use the following:
1) Declare the connection using OleDbConnection
Dim Myconnection As OleDbConnection
Myconnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:NorthWind.mdb;User Id=;Password=;")
2) Open the connection using the following:
Myconnection.Open();
3) Declare new oledb variable as the following:
dim Myda as new oledb.oledbdataadapter("select * from Users",connection)
dim Myda as new dataset
4) Fill that data inside it:
Myda.fill(ds)
5)You can use the data wherever you want:
for i=0 to Myds.tables(0).rows.count-1
Checkbox1.Items.Add(Myds.tables(0).rows(i)(0)
next i
Hope this solution will help.

Kind regards,