Connecting to a SQL Server databaes in ASP.NET using VB.NET and reading records

This is the most basic way of connecting to SQL Server database,
include the following Namespaces.


Imports System.Data
Imports System.Data.SqlClient

in code behind page,

Dim SqlConnection As String = "Data Source=ibm-mt8183\sqlexpress;Initial Catalog=pubs;uid=user;pwd=password;pooling=false"


ex: Data Source=sql server instance name
Initial Catalog=database name
uid=username
pwd=password

Reading a database table using sqlDataReader,


Dim SqlConnection As String
SqlConnection = "Data Source=server_name;Initial Catalog=databaseName;User ID=user;Password=pwd;Pooling=False;"


Dim myConnection As SqlConnection
myConnection = New SqlConnection(SqlConnection)


Dim str As String=
"SELECT name,phone FROM payout "

Dim myCommand As SqlCommand = New SqlCommand(Str, myConnection)
myConnection.Open()

Dim objdr As SqlDataReader
objdr = myCommand.ExecuteReader(CommandBehavior.closeconnection)


while(bjdr.Read())

response.write=objdr.getvalue(0).tostring()+"- "+objdr.getvalue(1).tostring()

end wihle
myConnection.Close