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

Asked By belensienna 10 points N/A Posted on - 12/05/2012

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?

 

• Status: Open
• Question Views: 867
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Visual basic

Answered By May Jratr 0 points N/A #141678

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,

About May Jratr

Questions
2

Answers
100

Best Answers
31

• Vote Up 0 Vote Down

• Posted on - 12/18/2012
• Question Category: Visual basic