다음 예제는 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>