ASP. Net connected SQL7 interface source code?

the following example shows what a simple ado.net 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.<br>

<br>

the following example shows what a simple ado.net application that connects to the northwind database and returns a list of categories. the example writes the output to the console, or command prompt.<br>

<br>

sqlclient<br>

[visual basic]<br>

imports system<br>

imports system.data<br>

imports system.data.sqlclient<br>

imports microsoft.visualbasic<br>

<br>

public class sample<br>

<br>

&nbsp;&nbsp;public shared sub main() <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;&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;user id=sa;password=pwd;initial catalog=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 categories&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 while myreader.read()<br>

&nbsp;&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>

end class<br>

[c#]<br>

using system;<br>

using system.data;<br>

using system.data.sqlclient;<br>

<br>

class sample<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 id=sa;password=pwd;initial catalog=northwind&quot;);<br>

<br>

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

&nbsp;&nbsp;&nbsp;&nbsp;catcmd.commandtext = &quot;select categoryid, categoryname from categories&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;&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>

imports system<br>

imports system.data<br>

imports system.data.oledb<br>

imports microsoft.visualbasic<br>

<br>

public class sample<br>

<br>

&nbsp;&nbsp;public shared sub main() <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;&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;user id=sa;password=pwd;initial 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 categories&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 while myreader.read()<br>

&nbsp;&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>

end class<br>

[c#]<br>

using system;<br>

using system.data;<br>

using system.data.oledb;<br>

<br>

class sample<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;initial 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 categories&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;&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>