Visual Basic Sql Select Tutorial MS SQL Server

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

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