Source code for connecting ASP. NET to SQL7

The following example shows what a simple ADO. NET application that connects to the Northwind database and returns a list of Categories wocould look like. The example writes the output to the console, or command prompt.

The following example shows what a simple ADO. NET application that connects to the Northwind database and returns a list of Categories. The example writes the output to the console, or command prompt.

SqlClient

[Visual Basic]

Imports System

Imports System. Data

Imports System. Data. SqlClient

Imports Microsoft. VisualBasic

Public Class Sample

Public Shared Sub Main ()

Dim nwindConn As SqlConnection = New SqlConnection ("Data Source = localhost ;"&_

"User Id = sa; Password = pwd; Initial Catalog = northwind ")

Dim catCMD As SqlCommand = nwindConn. CreateCommand ()

CatCMD. CommandText = "SELECT CategoryID, CategoryName FROM Categories"

NwindConn. Open ()

Dim myReader As SqlDataReader = catCMD. ExecuteReader ()

Do While myReader. Read ()

Console. WriteLine (vbTab & "{0}" & vbTab & "{1}", myReader. GetInt32 (0), myReader. GetString (1 ))

Loop

MyReader. Close ()

NwindConn. Close ()

End Sub

End Class

[C #]

Using System;

Using System. Data;

Using System. Data. SqlClient;

Class Sample

{

Public static void Main ()

{

SqlConnection nwindConn = new SqlConnection ("Data Source = localhost; User Id = sa; Password = pwd; Initial Catalog = northwind ");

SqlCommand catCMD = nwindConn. CreateCommand ();

CatCMD. CommandText = "SELECT CategoryID, CategoryName FROM Categories ";

NwindConn. Open ();

SqlDataReader myReader = catCMD. ExecuteReader ();

While (myReader. Read ())

{

Console. WriteLine ("{0} {1}", myReader. GetInt32 (0), myReader. GetString (1 ));

}

MyReader. Close ();

NwindConn. Close ();

}

}

OleDb

[Visual Basic]

Imports System

Imports System. Data

Imports System. Data. OleDb

Imports Microsoft. VisualBasic

Public Class Sample

Public Shared Sub Main ()

Dim nwindConn As OleDbConnection = New OleDbConnection ("Provider = SQLOLEDB; Data Source = localhost ;"&_

"User Id = sa; Password = pwd; Initial Catalog = northwind ")

Dim catCMD As OleDbCommand = nwindConn. CreateCommand ()

CatCMD. CommandText = "SELECT CategoryID, CategoryName FROM Categories"

NwindConn. Open ()

Dim myReader As OleDbDataReader = catCMD. ExecuteReader ()

Do While myReader. Read ()

Console. WriteLine (vbTab & "{0}" & vbTab & "{1}", myReader. GetInt32 (0), myReader. GetString (1 ))

Loop

MyReader. Close ()

NwindConn. Close ()

End Sub

End Class

[C #]

Using System;

Using System. Data;

Using System. Data. OleDb;

Class Sample

{

Public static void Main ()

{

OleDbConnection nwindConn = new OleDbConnection ("Provider = SQLOLEDB; Data Source = localhost; User Id = sa; Password = pwd; Initial Catalog = northwind ");

OleDbCommand catCMD = nwindConn. CreateCommand ();

CatCMD. CommandText = "SELECT CategoryID, CategoryName FROM Categories ";

NwindConn. Open ();

OleDbDataReader myReader = catCMD. ExecuteReader ();

While (myReader. Read ())

{

Console. WriteLine ("{0} {1}", myReader. GetInt32 (0), myReader. GetString (1 ));

}

MyReader. Close ();

NwindConn. Close ();

}

}