Question

asp.net怎么获取数据库中符合条件记录的行数并赋值？

SqlConnection sqlConn = new SqlConnection();
sqlConn.ConnectionString = "server= .\\sqlexpress;Initial Catalog=P;Integrated Security=True";
sqlConn.Open();
string selectStr = "select count(*) from allrecords where month='" + month + "' AND year='" + year + "' ";
SqlCommand select = new SqlCommand(selectStr, sqlConn);
int l = (int)select.ExecuteScalar();
sqlConn.Close();
l是获取的符合条件的记录行数吗？运行起来结果是错误的，求指正。谢谢。

Answer 1

"select count(*) as number from allrecords where month='" + month + "' AND year='" + year + "

你把这条语句的number读取出来会不会啊。