Creating Connection

Read about ADO.NET and it will help you.

Look at these:
MSDN: ADO.NET [^]
Using DataReaders, SQL Server [^]
The C# Station ADO.NET Tutorial[^]

Please follow the below steps

1. If the database name is : NorthWindDB.

2. in web.config file add the following code.

<connectionString>

<add name="NorthWindDB" value="Server=machinename\SQLEXPRESS;Database=NorthWindDB;User Id=sa;password=dss;" />
</connectionString>


3. In the code file, import the following namespaces.

Imports System.Data;
Imports System,Data.SqlClient;


4. Add the reference to System.Configuration namespace. By right clicking the project-> click Add Reference -> select System.Configuration -> ok.

Write the following code to connect to the database and execute the query "select * from Emp". This query retreives all the rows from the Emp table of the NorthWindDB database.

5.Dim con as New SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings("NorthWindDB").ConnectionString()

dim cmd as New SqlCommand(con,"select * from Emp")

dim dr as SqlDataReader = cmd.ExecuteReader()

while(dr.Read())

//Process the data as per your requirement.

End While

<a href="http://dotnetforbeginner.blogspot.com/">http://dotnetforbeginner.blogspot.com/</a><a href="http://dotnetforbeginner.blogspot.com/" target="_blank" title="New Window"></a>

You'll need to read up on connection strings / and the system.data.sql namespace

start by reading some of the links in this search:

http://www.google.co.uk/search?hl=en&q=sql+connection+%2B+vb.net&meta=[^]

and if for the right connection string go to
http://www.connectionstrings.com/[^]

first implement this:

Imports System.Data
Imports System.Data.SqlClient


second:
Sub SQLConnect()
Dim connStr As String = "Data Source=.\sqlexpress;initial Catalog=DataBaseName;integrated security=true"
Dim sqlConn As New SqlConnection(connStr)
sqlConn.Open() 'Connecting Successful
'Working Online
Dim cmd As New SqlCommand
cmd.Connection = sqlConn
cmd.CommandText = "select Col1,Col2 from Table1"
Dim sqlread As SqlDataReader = cmd.ExecuteReader 'Retreiving Multi Rows from table
'Working Offline
Dim sqlAda As New SqlDataAdapter("select Col1,Col2 from Table1", connStr)
Dim ds As New DataSet
sqlAda.Fill(ds, "Table1") ' Fill All Data resulting in sql query in data set object and can use it after closing connection
sqlConn.Close() 'Now Can working onle with offline mode
End Sub