Visual Basic Sql Select Top MS Access Tutorial OLEDB

In this visual basic tutorial, we will select the top records from MS Access using visual basic code sample below.

Visual Basic SQL Select Top 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 TOP 2 * 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 sql select top code sample in ASP.NET Visual basic with MS Access oledb.