ASP. صافي متصل SQL7 واجهة المصدر رمز المصدر؟

يوضح المثال التالي كيف يبدو تطبيق 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>