Visual Basic Sql Select Distinct MS Access Tutorial OLEDB

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

Visual Basic SQL Select Distinct 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 DISTINCT Name 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 distinct code sample in ASP.NET Visual basic with MS Access oledb.