Visual Basic Sql Select Top Tutorial MS SQL Server

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

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