Visual Basic Sql Select MS Access Tutorial OLEDB

In this visual basic tutorial, we will select users table from MS Access using visual basic code sample below.

Visual Basic SQL Select Code

Dim constr As String
constr =  "Provider=Data Source=yourmdbfile.mdb;provider=Microsoft.Jet.OLEDB.4.0";

Dim str_select As String
str_select = "SELECT * FROM tbl_users"

Dim ds As DataSet
Dim da As System.Data.OleDb.OleDbDataAdapter
Dim con As System.Data.OleDb.OleDbConnection 

con = New System.Data.OleDb.OleDbConnection(constr)
da = New System.Data.OleDb.OleDbDataAdapter(str_select, con)
ds = New System.Data.DataSet()

da.Fill(ds)
        

Note that you can also use this code sample in ASP.NET Visual basic with MS Access oledb.