ASP.NET連SQL7介面的原始碼

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

The following example shows what a simple 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

Imports lient

Imports alBasic

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 = teCommand()

mandText = "SELECT CategoryID, CategoryName FROM Categories"

()

Dim myReader As SqlDataReader = uteReader()

Do While ()

eLine(vbTab & "{0}" & vbTab & "{1}", nt32(0), tring(1))

Loop

e()

e()

End Sub

End Class

[C#]

using System;

using ;

using lient;

class Sample

{

public static void Main()

{

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

SqlCommand catCMD = teCommand();

mandText = "SELECT CategoryID, CategoryName FROM Categories";

();

SqlDataReader myReader = uteReader();

while (())

{

eLine("t{0}t{1}", nt32(0), tring(1));

}

e();

e();

}

}

OleDb

[Visual Basic]

Imports System

Imports

Imports b

Imports alBasic

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 = teCommand()

mandText = "SELECT CategoryID, CategoryName FROM Categories"

()

Dim myReader As OleDbDataReader = uteReader()

Do While ()

eLine(vbTab & "{0}" & vbTab & "{1}", nt32(0), tring(1))

Loop

e()

e()

End Sub

End Class

[C#]

using System;

using ;

using b;

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 = teCommand();

mandText = "SELECT CategoryID, CategoryName FROM Categories";

();

OleDbDataReader myReader = uteReader();

while (())

{

eLine("t{0}t{1}", nt32(0), tring(1));

}

e();

e();

}

}