ASP。NET連SQL7接口源代碼？

2024-05-04 11:06:28

字體：大中小

來源：轉載

供稿：網友

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. 
 
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. 
 
sqlclient 
[visual basic] 
imports system 
imports system.data 
imports system.data.sqlclient 
imports microsoft.visualbasic 
 
public class sample 
 
  public shared sub main() 
    dim nwindconn as sqlconnection = new sqlconnection("data source=localhost;" & _ 
                                                       "user id=sa;password=pwd;initial catalog=northwind") 
 
    dim catcmd as sqlcommand = nwindconn.createcommand() 
    catcmd.commandtext = "select categoryid, categoryname from categories" 
 
    nwindconn.open() 
 
    dim myreader as sqldatareader = catcmd.executereader() 
 
    do while myreader.read() 
      console.writeline(vbtab & "{0}" & vbtab & "{1}", myreader.getint32(0), myreader.getstring(1)) 
    loop 
 
    myreader.close() 
    nwindconn.close() 
  end sub 
end class 
[c#] 
using system; 
using system.data; 
using system.data.sqlclient; 
 
class sample 
{ 
  public static void main() 
  { 
    sqlconnection nwindconn = new sqlconnection("data source=localhost;user id=sa;password=pwd;initial catalog=northwind"); 
 
    sqlcommand catcmd = nwindconn.createcommand(); 
    catcmd.commandtext = "select categoryid, categoryname from categories"; 
 
    nwindconn.open(); 
 
    sqldatareader myreader = catcmd.executereader(); 
 
    while (myreader.read()) 
    { 
      console.writeline("/t{0}/t{1}", myreader.getint32(0), myreader.getstring(1)); 
    } 
 
    myreader.close(); 
    nwindconn.close(); 
  } 
} 
oledb 
[visual basic] 
imports system 
imports system.data 
imports system.data.oledb 
imports microsoft.visualbasic 
 
public class sample 
 
  public shared sub main() 
    dim nwindconn as oledbconnection = new oledbconnection("provider=sqloledb;data source=localhost;" & _ 
                                                           "user id=sa;password=pwd;initial catalog=northwind") 
 
    dim catcmd as oledbcommand = nwindconn.createcommand() 
    catcmd.commandtext = "select categoryid, categoryname from categories" 
 
    nwindconn.open() 
 
    dim myreader as oledbdatareader = catcmd.executereader() 
 
    do while myreader.read() 
      console.writeline(vbtab & "{0}" & vbtab & "{1}", myreader.getint32(0), myreader.getstring(1)) 
    loop 
 
    myreader.close() 
    nwindconn.close() 
  end sub 
end class 
[c#] 
using system; 
using system.data; 
using system.data.oledb; 
 
class sample 
{ 
  public static void main() 
  { 
    oledbconnection nwindconn = new oledbconnection("provider=sqloledb;data source=localhost;user id=sa;password=pwd;initial catalog=northwind"); 
 
    oledbcommand catcmd = nwindconn.createcommand(); 
    catcmd.commandtext = "select categoryid, categoryname from categories"; 
 
    nwindconn.open(); 
 
    oledbdatareader myreader = catcmd.executereader(); 
 
    while (myreader.read()) 
    { 
      console.writeline("/t{0}/t{1}", myreader.getint32(0), myreader.getstring(1)); 
    } 
 
    myreader.close(); 
    nwindconn.close(); 
  } 
}

上一篇：我的aspx為什么無法顯示中文？

下一篇：三、ASPNET中實現在線用戶檢測（使用后臺守護線程）