关于SqlDataReader.getvalue.tostring的小疑点
关于SqlDataReader.getvalue.tostring的小问题
求教
string str = "server = (local); uid =***; pwd =****; database =Personmanage;";
string labroom = "select count(*) from room where rjudge='0' group by rtype";
SqlConnection aq = new SqlConnection(str);
SqlCommand coma = new SqlCommand(labroom, aq);
aq.Open();
SqlDataReader sda = coma.ExecuteReader();
label1.Text = sda.GetValue(0).ToString();
label3.Text = sda.GetValue(1).ToString();
label5.Text = sda.GetValue(2).ToString();
aq.Close();
\附上sql该部分脚本
错误提示为未处理的invalidexception
------解决方案--------------------
所以应该这样写
求教
string str = "server = (local); uid =***; pwd =****; database =Personmanage;";
string labroom = "select count(*) from room where rjudge='0' group by rtype";
SqlConnection aq = new SqlConnection(str);
SqlCommand coma = new SqlCommand(labroom, aq);
aq.Open();
SqlDataReader sda = coma.ExecuteReader();
label1.Text = sda.GetValue(0).ToString();
label3.Text = sda.GetValue(1).ToString();
label5.Text = sda.GetValue(2).ToString();
aq.Close();
\附上sql该部分脚本
错误提示为未处理的invalidexception
------解决方案--------------------
所以应该这样写
SqlDataReader sda = coma.ExecuteReader();
while(sda.Read())
{
Console.WriteLine(sda.GetValue(0));
}
sda.Close();