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

Asked By 10 points N/A Posted on -
qa-featured

What are the outlined processes in using vb.net web query interaction to retrieve data from an Access database after a subsequent download of the web query and integration within the database interface?

 
SHARE
Answered By 0 points N/A #141678

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

qa-featured

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,

Login/Register to Answer

Related Questions