يوضح المثال التالي كيف يبدو تطبيق ADO.NET البسيط الذي يتصل بقاعدة بيانات NorthWind ويعيد قائمة بالفئات. يكتب المثال الإخراج إلى وحدة التحكم ، أو موجه الأوامر. <br>
<br>
يوضح المثال التالي ما هو تطبيق ADO.NET البسيط الذي يتصل بقاعدة بيانات NorthWind ويعيد قائمة الفئات. يكتب المثال الإخراج إلى وحدة التحكم ، أو موجه الأوامر. <br>
<br>
sqlclient <br>
[Visual Basic] <br>
نظام الواردات <br>
الاستيراد System.data <br>
استيراد system.data.sqlclient <br>
يستورد microsoft.visualbasic <br>
<br>
عينة الطبقة العامة <br>
<br>
& nbsp ؛ & nbsp ؛ sub sub main () <br> العام () <br>
& nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ dim nwindconn as sqlconnection = new sqlconnection (& quot ؛ data source = localhost ؛ & quot ؛ & _ <br>
& 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 ؛ P ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ & quot ؛ معرف المستخدم = 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 from structions & quot ؛ <br>
<br>
& nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ nwindconn.open () <br>
<br>
& nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ dim myreader as sqldatareader = catcmd.executeReader () <br>
<br>
& nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ do بينما myreader.read () <br>
& nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ console.writeLine (vbtab & & quot ؛ {0} & quot ؛ & vbtab & & quot ؛ {1} & quot ؛ ، myreader.getint32 (0) ، myreader.getring (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 (& quot ؛ data source = localhost ؛ user ide = sa ؛ password = pwd ؛ inial catalog = northwind & quot ؛) ؛
<br>
& nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ sqlcommand catcmd = nwindconn.createcommand () ؛ <br>
& nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ catcmd.CommandText = & quot ؛ Select CategoryId ، categoryName from structions & 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 ؛ بينما (myreader.read ()) <br>
& nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ {<br>
& nbsp ؛ & 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>
الاستيراد System.data <br>
استيراد system.data.oledb <br>
يستورد microsoft.visualbasic <br>
<br>
عينة الطبقة العامة <br>
<br>
& nbsp ؛ & nbsp ؛ sub sub main () <br> العام () <br>
& nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ dim nwindconn as OLEDBConnection = new OLEDBConnection (& quot ؛ provider = sqloledb ؛ data source = localHost ؛ & quot ؛ & _ <br>
& 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 ؛ P ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ & quot ؛ معرف المستخدم = sa ؛ password = pwd ؛ inial catalog = northwind & quot ؛) <br>
<br>
& nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ dim catcmd as OLEDBCommand = nwindconn.createcommand () <br>
& nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ catcmd.CommandText = & quot ؛ Select CategoryId ، categoryname from structions & quot ؛ <br>
<br>
& nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ nwindconn.open () <br>
<br>
& nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ dim myreader as oledbdatareader = catcmd.executeReader () <br>
<br>
& nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ do بينما myreader.read () <br>
& nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ console.writeLine (vbtab & & quot ؛ {0} & quot ؛ & vbtab & & quot ؛ {1} & quot ؛ ، myreader.getint32 (0) ، myreader.getring (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 (& quot ؛ provider = sqloledb ؛ data source = localHost ؛ user id = sa ؛ password = pwd ؛ inial catalog = northwind & quot ؛) ؛ <br>)
<br>
& nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ oledbcommand catcmd = nwindconn.createcommand () ؛ <br>
& nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ catcmd.CommandText = & quot ؛ Select CategoryId ، categoryName from structions & 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 ؛ بينما (myreader.read ()) <br>
& nbsp ؛ & nbsp ؛ & nbsp ؛ & nbsp ؛ {<br>
& nbsp ؛ & 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>