国产毛片午夜福利,国产黄网,国产亚洲天堂,97国产精品

    • 

  • 

    • 






    
  
    
    
    
      
    
        



    
  
    
    
    
  
    

    


            		
        
    
    
    		
  
    

    

    
  
    
    




    
  
    

    


    
  
    
     
  
    

    


    
  
    
            
            慧網(wǎng)動(dòng)態(tài)        
            
            常見問題        
            
            網(wǎng)絡(luò)營銷        
            
            網(wǎng)站設(shè)計(jì)        
            
            行業(yè)動(dòng)態(tài)        
            
            網(wǎng)站優(yōu)化        
      
    

    


    
  
    
    ASP.NET連SQL7接口源代碼  
    

    


    
  
    
    發(fā)布時(shí)間：2005-03-17　　　瀏覽次數(shù)：1185361  
    

    


    
  
    
    
    
      
    


    
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();
    

    }
    

    }
    		

    

    


    

    

    


    
來源：http://edu.chinaz.com 
        
    
    
    
        
        
    
    
  
    

    


    
  
    
    
    
      
      
      立即預(yù)約