Reading and MDB File

Question

0.00/5 (No votes)

See more:

Hi
Im new to VB. In delphi it was simple to read a mdb file
I added an "ado query" and a table. Linked them together.
The code i used was

ado.active := false
ado.sql.text := "select * from table"
ado.active := true

It was 3 lines of code to read a database and put it into a table.

Is there no simple method like this to open a mdb file in vb?

Posted 24-Apr-12 22:57pm

Cypronics

Add a Solution

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2012-04-24T23:31:00

If you look back at your delphi work it wasn't quite that simple - you had to specify the DB, and set up a connection as well.
It is the same with VB:

Using con As New SqlConnection(strConnect)
	con.Open()
	Using da As New SqlDataAdapter("SELECT * FROM myTable", con)
		Dim dt As New DataTable()
		da.Fill(dt)
		myDataGridView.DataSource = dt
	End Using
End Using

That not only fills a table, but also displays it as well...

Mantu Singh · Answer 2 · 2012-04-24T23:24:00

Solution 1

You need to use ADO.NET classes to read data from access
Some useful classes r as folows
OleDbConnection
OleDbDCommand

Check this link

http://msdn.microsoft.com/en-us/library/ms971485.aspx[^]

Best of luck........

Permalink

Posted 24-Apr-12 23:24pm

Mantu Singh

Vipin_Arora · Answer 3 · 2012-04-25T03:30:00

Solution 3

Hi,

For reading Access file from VB.NET code, see the following link:

http://www.startvbdotnet.com/ado/msaccess.aspx[^]

Permalink

Posted 25-Apr-12 3:30am

Vipin_Arora

Reading and MDB File

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0

Reading and MDB File

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us