using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace Example20
{
    class Program
    {
        static void Main(string[] args)
        {
            //定義連接字符串
            string connectionString = @"Data Source=WWW-C4074C4DF06\SQLEXPRESS;Initial Catalog=Chap20;Integrated Security=True;Pooling=False";

            //使用連接字符串建立連接
            SqlConnection myConnection = new SqlConnection(connectionString);

            //打開連接
            myConnection.Open();

            //定義SqlCommand變量
            SqlCommand myCommand = myConnection.CreateCommand();

            //設置SQL語句
            myCommand.CommandText = "select * from student";

            //從數據庫獲取數據
            SqlDataReader myDataReader = myCommand.ExecuteReader();

            //讀取DataReader中的數據并輸出
            while (myDataReader.Read())
            {
                Console.WriteLine("\t{0}\t{1}", myDataReader["ID"], myDataReader["Name"]);
            }

            //關閉SqlDataReader
            myDataReader.Close();

            //關閉連接
            myConnection.Close();

            Console.ReadLine();
        }
    }
}