From dePoPo.net

Getting data from an access database

Posted in: Data Access

By dePoPo
Mar 2, 2009 - 10:52:42 PM

This code sample demonstrated how to access data in an msaccess database from vb.net code.

Imports System.Data.OleDb

	 

	 Dim s_filename as String = "c:\myaccessdatabase.mdb"

	 Dim mydatareader As OleDbDataReader

	 Dim myconnection As OleDbConnection

	 Dim mycommand As OleDbCommand

	

	 myconnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & s_filename & ";")

	 myconnection.Open()

	 mycommand = New OleDbCommand("SELECT * FROM .........", myconnection)

	 mydatareader = mycommand.ExecuteReader

	 While mydatareader.Read()

	  ' handle data

	 End While

	 mydatareader.Close()

	 myconnection.Close()