Visual Basic Sql Select Distinct Tutorial MS SQL Server

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

Visual Basic SQL Select Distinct Code

Dim constr As String
constr = "Provider=sqloledb;Data Source=SqlServerIPAddress;Initial Catalog=DataBaseName;User Id=UserName;Password=UserPassword;"

Dim str_select As String
str_select = "SELECT DISTINCT Name FROM tbl_users"

Dim ds As DataSet
Dim da As System.Data.SqlClient.SqlDataAdapter
Dim con As System.Data.SqlClient.SqlConnection

con = New System.Data.SqlClient.SqlConnection(constr)
da = New System.Data.SqlClient.SqlDataAdapter(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.