第1个回答 2019-04-07
string connString = "server=127.0.0.1;uid=sa;pwd=;database=TJPTTC"; SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd = conn.CreateCommand();
//sql语句
cmd.CommandText = "select count(*) cnt from Student";
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
String count = dr["cnt"].toString(); // 这个就是你要的个数
//关闭连接
conn.Close();