ADO.NET对象之DataReader操作

来源：互联网发布：淘宝柒牌官方旗舰店编辑：程序博客网时间：2024/05/22 16:06

string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;

using (SqlConnection conn = new SqlConnection(constr))

{

conn.Open();

using (SqlCommand cmd = conn.CreateCommand())

{

cmd.CommandText = "select * from T_Users";

using (SqlDataReader reader = cmd.ExecuteReader())

{

while (reader.Read())

{

Response.Write("方法一：使用类型化访问器GetStringAndGetInt！");

Response.Write(reader.GetInt64(0).ToString() + " " + reader.GetString(1) + " " + reader.GetString(2) + "<br />");

Response.Write("");

Response.Write("方法二：使用序数索引器！");

Response.Write(reader[0].ToString() + " " + reader[1].ToString() + " " + reader[2].ToString() + "<br />");

Response.Write("");

Response.Write("方法三：使用列名索引器！");

Response.Write(reader["Id"].ToString() + " " + reader["Name"].ToString() + " " + reader["Password"].ToString() + "<br />");

Response.Write("");

Response.Write("方法四：使用类型化访问器GetStringAndGetIntAndGetOrdinal");

Response.Write(reader.GetInt64(reader.GetOrdinal("Id")).ToString() + " " + reader.GetString(reader.GetOrdinal("Name")).ToString() + " " + reader.GetString(reader.GetOrdinal("Password")).ToString() + "<br />");

}

conn.Close();

}