ADO.NETÖеÄsqlÁ¬½Ó

using System.Data;            // Use ADO.NET namespace
using System.Data.SqlClient;  
 SqlConnection thisConnection = new SqlConnection(
            @"Data Source=GY; Initial Catalog=northwind;uid=sa;password=datadog"); //ÏȽ¨Á¢Á¬½Ó
 thisConnection.Open();//´ò¿ªÁ¬½Ó
         SqlCommand thisCommand = thisConnection.CreateCommand();//Ö±½ÓÖ¸¶¨connµÄcommand
Ò²¿ÉÒÔÕâÑù        //  SqlCommand cmd = new SqlCommand();
       //  cmd.Connection = thisConnection;
cmmandµÄsqlÃüÁî         
thisCommand.CommandText = "SELECT CustomerID, CompanyName from Customer";
         SqlDataReader thisReader = thisCommand.ExecuteReader();//sqldatareader²»¿ÉÒÔÓÃnew ±ØÐëÖ±½ÓÓëcommand¹ØÁª
//ÓÃreader¶Á³ö±í
         while (thisReader.Read())
         {
            // Output ID and name columns
            Console.WriteLine("\t{0}\t{1}", 
               thisReader["CustomerID"], thisReader["CompanyName"]);
         // Close reader ÓÃÍêÒª¹Ø±Õ
         thisReader.Close();