用DataReader读取数据

using System.Data;
using System.Data.SqlClient;

 static void Main(string[] args)
        {
            SqlConnection thisConn = new SqlConnection(@"Server=.\Nie;uid=sa;pwd=111;Database=MyNorthwind");
             //@符号表示一个字符串字面量，它使此名称中的把斜线发挥了作用，否则就需要双反斜线（\\)将反斜线字符转义到C#字符串中
            thisConn.Open();
            SqlCommand thisCommand = thisConn.CreateCommand();
            thisCommand.CommandText = "Select CustomerID,CustomerName from Customers";


            SqlDataReader thisReader = thisCommand.ExecuteReader();
            while (thisReader.Read())
            {
                Console.WriteLine("\t(0)\t(1)",
                    thisReader["CustomerID"], thisReader["CustomerName"]);
            }
            thisReader.Close();
            thisConn.Close();
            Console.Write("Program finished,press any key to Continue.");
            Console.ReadLine(); 

        }