c# 返回SqlDataReader失败
public SqlDataReader readData(string sql)
{
try
{
conn.Open();
cmd = new SqlCommand(sql, conn);
rs = cmd.ExecuteReader();
//while (rs.Read())
//{
// Console.WriteLine(rs[0].ToString());
//}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return null;
}
return rs;
}
为什么在这个里边用循环就可以提取到数据,但是下面这样就取不出出来数据.
SqlDataReader drs = sdbc.readData("select * from aabbcc");
try
{
while (drs.Read())
{
Console.WriteLine(drs["0"].ToString());
}
}
catch
{
}