OleDbCommand Cmd = new OleDbCommand("select * from ss",Conn);
OleDbDataReader dr;
dr = Cmd.ExecuteReader();
int s = 0;
While (dr.Read())
{
s += 1;
}
Response.Write("共"+s+"条");
OleDbDataReader dr;
dr = Cmd.ExecuteReader();
int s = 0;
While (dr.Read())
{
s += 1;
}
Response.Write("共"+s+"条");
mycmd.commandText="select count(*) from yourtable";
int count=mycmd.ExecuteScalr; count的得数就是~~~你要的~~
如:第一行 第一列 的值
yDt.Rows[0][0].ToString();