怎么得到记录总数？

[OMyDoG]

SqlConnection cn1=new SqlConnection(strConn);

cn1.Open();

String strSQL1="select count(*) from menu group by menu_id ";

SqlCommand cm1=new SqlCommand(strSQL1,cn1);

SqlDataReader dr1=cm1.ExecuteReader();

//int allrec=dr1.GetInt32(0);

cn1.Close();



//上面的allrec得不到~~sql语句怎么写？

[yuanreid]

SqlDataReader dr1=cm1.ExecuteReader();
int allrec;
//----------------
while(dr1.Read())
{
allrec = dr1.GetInt32(0);
}
//----------------
……

[saucer]

try

SqlConnection cn1=new SqlConnection(strConn);
cn1.Open();
String strSQL1="select count(*) from menu group by menu_id ";
SqlCommand cm1=new SqlCommand(strSQL1,cn1);
int allrec=(int) cm1.ExecuteScalar();
cn1.Close();

[clyyy]

如果是select * from menu group by menu_id 而我又想用 SqlDataReader
对象，不用循环我怎么才能取得记录总数。

[saucer]

如果你用SqlDataReader的话，你必须要用循环