ASP. NET 연결 SQL7 인터페이스 소스 코드?

다음 예제는 Northwind 데이터베이스에 연결하고 카테고리 목록을 반환하는 간단한 ADO.NET 응용 프로그램을 보여줍니다. 이 예제는 출력을 콘솔 또는 명령 프롬프트에 씁니다. <br>

<br>

다음 예제는 Northwind 데이터베이스에 연결하고 카테고리 목록을 반환하는 간단한 ADO.NET 응용 프로그램을 보여줍니다. 이 예제는 출력을 콘솔 또는 명령 프롬프트에 씁니다. <br>

<br>

sqlclient <br>

[Visual Basic] <br>

수입 시스템 <br>

Imports System.Data <br>

Imports System.data.sqlclient <br>

Microsoft.visualBasic <br> 수입

<br>

공개 수업 샘플 <br>

<br>

& nbsp; & nbsp; public shared sub main () <br>

& nbsp; & nbsp; & nbsp; & nbsp; dim nwindconn as sqlconnection = new sqlconnection ( "데이터 소스 = localhost; & _ <br>

& nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; p; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; p; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; "user id = sa; password = pwd; 초기 카탈로그 = Northwind & quot;) <br>

<br>

& nbsp; & nbsp; & nbsp; & nbsp; dim catcmd as sqlcommand = nwindconn.createcommand () <br>

& nbsp; & nbsp; & nbsp; & nbsp; catcmd.commandText = & quot; select categoryId, categoryname, categorys "<br>

<br>

& nbsp; & nbsp; & nbsp; nwindconn.open () <br>

<br>

& nbsp; & nbsp; & nbsp; & nbsp; dim myreader as sqldatareader = catcmd.executereader () <br>

<br>

& nbsp; & nbsp; & nbsp; & nbsp; myreader.read () <br>

& nbsp; & nbsp; & nbsp; & nbsp; & nbsp; console.writeline (vbtab & quot; {0} & quot; & vbtab & & & quot; {1} & quot;, myreader.getint32 (0), myreader.getstring (1))) <br>

& nbsp; & nbsp; & nbsp; & nbsp; loop <br>

<br>

& nbsp; & nbsp; & nbsp; & nbsp; myreader.close () <br>

& nbsp; & nbsp; & nbsp; & nbsp; nwindconn.close () <br>

& nbsp; & nbsp; end sub <br>

종료 클래스 <br>

[C#] <br>

시스템 사용; <br>

System.Data; <br> 사용

system.data.sqlclient; <br> 사용

<br>

클래스 샘플 <br>

{<br>

& nbsp; & nbsp; public static void main () <br>

& nbsp; & nbsp; {<br>

& nbsp; & nbsp; & nbsp; & nbsp; sqlconnection nwindconn = new sqlconnection ( "데이터 소스 = 로컬 호스트; 사용자 id = sa; password = pwd; 초기 카탈로그 = Northwind & quot;); <br>

<br>

& nbsp; & nbsp; & nbsp; & nbsp; sqlcommand catcmd = nwindconn.createcommand (); <br>

& nbsp; & nbsp; & nbsp; & nbsp; catcmd.commandText = & quot; select categoryId, categoryname "categorys & quot ;; <br>

<br>

& nbsp; & nbsp; & nbsp; & nbsp; nwindconn.open (); <br>

<br>

& nbsp; & nbsp; & nbsp; & nbsp; sqldatareader myreader = catcmd.executereader (); <br>

<br>

& nbsp; & nbsp; & nbsp; & nbsp; while (myreader.read ()) <br>

& nbsp; & nbsp; & nbsp; & nbsp; {<br>

& nbsp; & nbsp; & nbsp; & nbsp; & nbsp; console.writeline (& quot;/t {0}/t {1} & quot;, myreader.getint32 (0), myreader.getString (1)); <br>

& nbsp; & nbsp; & nbsp; & nbsp;} <br>

<br>

& nbsp; & nbsp; & nbsp; & nbsp; myreader.close (); <br>

& nbsp; & nbsp; & nbsp; & nbsp; nwindconn.close (); <br>

& nbsp; & nbsp;} <br>

} <br>

OLEDB <br>

[Visual Basic] <br>

수입 시스템 <br>

Imports System.Data <br>

Imports System.Data.OLEDB <br>

Microsoft.visualBasic <br> 수입

<br>

공개 수업 샘플 <br>

<br>

& nbsp; & nbsp; public shared sub main () <br>

& nbsp; & nbsp; & nbsp; & nbsp; dim nwindconn as as oledbconnection = new OledbConnection ( "제공자 = sqloledb; data source = localhost; & _ <br>

& nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; p; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; p; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp;

<br>

& nbsp; & nbsp; & nbsp; & nbsp; dim catcmd as as OledbCommand = nwindconn.createCommand () <br>

& nbsp; & nbsp; & nbsp; & nbsp; catcmd.commandText = & quot; select categoryId, categoryname, categorys "<br>

<br>

& nbsp; & nbsp; & nbsp; nwindconn.open () <br>

<br>

& nbsp; & nbsp; & nbsp; & nbsp; dim myreader as oledbdatareader = catcmd.executereader () <br>

<br>

& nbsp; & nbsp; & nbsp; & nbsp; myreader.read () <br>

& nbsp; & nbsp; & nbsp; & nbsp; & nbsp; console.writeline (vbtab & quot; {0} & quot; & vbtab & & & quot; {1} & quot;, myreader.getint32 (0), myreader.getstring (1))) <br>

& nbsp; & nbsp; & nbsp; & nbsp; loop <br>

<br>

& nbsp; & nbsp; & nbsp; & nbsp; myreader.close () <br>

& nbsp; & nbsp; & nbsp; & nbsp; nwindconn.close () <br>

& nbsp; & nbsp; end sub <br>

종료 클래스 <br>

[C#] <br>

시스템 사용; <br>

System.Data 사용; <br>

System.Data.OLEDB 사용 사용; <br>

<br>

클래스 샘플 <br>

{<br>

& nbsp; & nbsp; public static void main () <br>

& nbsp; & nbsp; {<br>

& nbsp; & nbsp; & nbsp; & nbsp; OledbConnection nwindconn = new OledBConnection ( "제공자 = sqloledb; data source = localhost; user id = sa; password = pwd; 초기 카탈로그 = Northwind & quot;); <br>

<br>

& nbsp; & nbsp; & nbsp; & nbsp; Oledbcommand catcmd = nwindconn.createcommand (); <br>

& nbsp; & nbsp; & nbsp; & nbsp; catcmd.commandText = & quot; select categoryId, categoryname, categorys & quot ;; <br>

<br>

& nbsp; & nbsp; & nbsp; & nbsp; nwindconn.open (); <br>

<br>

& nbsp; & nbsp; & nbsp; & nbsp; OledbdatAreader myReader = catcmd.executereader (); <br>

<br>

& nbsp; & nbsp; & nbsp; & nbsp; while (myreader.read ()) <br>

& nbsp; & nbsp; & nbsp; & nbsp; {<br>

& nbsp; & nbsp; & nbsp; & nbsp; & nbsp; console.writeline (& quot;/t {0}/t {1} & quot;, myreader.getint32 (0), myreader.getString (1)); <br>

& nbsp; & nbsp; & nbsp; & nbsp;} <br>

<br>

& nbsp; & nbsp; & nbsp; & nbsp; myreader.close (); <br>

& nbsp; & nbsp; & nbsp; & nbsp; nwindconn.close (); <br>

& nbsp; & nbsp;} <br>

} <br>