//获取sqlDataReader对象Read()方法读取流的字段值的三种方法。
using(SqlConnection conn =newSqlConnection("data source=Fan-VAIO;initialcatalog=sales;integrated security=true"))
{
conn.Open();
using(SqlCommand cmd =newSqlCommand("select* from t_user",conn))
{
SqlDataReaderdr = cmd.ExecuteReader();
//SqlDataReaderdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while(dr.Read())
{
//方法<1>
for (int i = 0; i< dr.FieldCount; i++)
{
Console.Write(dr.GetName(i) + dr.GetValue(i));
}
Console.WriteLine();
//方法<2>
Console.WriteLine(dr[0]+ dr[1].ToString() + dr[2] + dr[3]);
//方法<3>
Console.WriteLine(dr.GetValue(0)+dr.GetValue (1).ToString ()+dr .GetValue (2)+dr .GetValue (3));
//方法<4> 最后一个字段password里面包含Null,所以不能用dr.GetInt32(),报错提示:数据为空。不能对 Null 值调用此方法或属性。
//Console.Write(dr.GetInt32(0)+ dr.GetString(1) + dr.GetInt32(2) + dr.GetInt32(3));
}
}
}
Console.Read();