Visual Basic Sql Select Count Tutorial MS SQL Server

In this visual basic tutorial, we will select count the number of records from MS SQL Server using visual basic code sample below.

Visual Basic SQL Select Count 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 COUNT(*) 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 count code sample in ASP.NET Visual basic.