SqlDataReader 小例

 

using System.Data.SqlClient; class DataReaderExample {     public static void Main()     {         SqlConnection con = new SqlConnection("Data Source = localhost; Integrated Security = SSPI; Initial Catalog = example"）;         SqlCommand cmd = con.CreateCommand();         cmd.CommandText = "select * from user";         con.Open();         SqlDataReader dr = cmd.ExecuteReader();         while(dr.Read())         {             System.Console.WriteLine(dr.GetString(1),dr.GetInt32(0));         }         dr.Close();         con.Close();     } }