ASP.NET

shapper wrote:

' Define connection
Dim connection As New SqlClient.SqlConnection(connectionString.ToString)

' Define command
Dim command As New SqlClient.SqlCommand
With command
.CommandText = "GetRecords"
.Connection = connection
.CommandType = CommandType.StoredProcedure
End With

' Add command parameters
With command.Parameters
.Add(New SqlClient.SqlParameter("@Value", Value))
End With

connection.Open()
...
Create DataTable
...
connection.Close()

/ Assumes connectionString is a valid connection string.<br />
using (OleDbConnection connection = <br />
  new OleDbConnection(connectionString))<br />
{<br />
    connection.Open();<br />
    // Do work here.