asp可以通过下面的方法得到,但C#如何得到:请各位大虾执教。Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.RecordSet")
....省略conn设置
Sqlstr = "select * from table_1"
rs.Open Sqlstr,conn,1,3'数据库记录条数
data_count = rs.RecordCount急用
Set rs = Server.CreateObject("ADODB.RecordSet")
....省略conn设置
Sqlstr = "select * from table_1"
rs.Open Sqlstr,conn,1,3'数据库记录条数
data_count = rs.RecordCount急用
dataset1.tables(0).rowscount就是纪录条数也可以在数据库中直接计算出来
select Count(*) from table1
select Count(*) from table1如何得到?
dim ad as new SqlDataAdapter()
cn.open()
ad.SelectCommand=new SqlCommand("select count(*) from Table1",cn)
dim Dt as new DataTable
ad.fill(Dt)
Dim recordCount as int=Dt.rows(0).item(0)
cn.close()
Return recordCount
SqlConnection cn=new SqlConnection("连接字符串");
cn.open()
SqlCommand cmnd=new SqlCommand("select count(*) from Table1",cn);
reccount=cmnd.ExecuteScalar();
SqlConnection conn=new SqlConnection("连接字符串");
conn.Open();
SqlCommand comm=new SqlCommand();
comm.CommandText="select count(*) from table_1";
comm.Connection=conn; int count=(int)comm.ExecuteScalar(); comm.Dispose();
conn.Close();
conn.Dispose();
dim cn as new SqlConnection("连接字符串")
dim ad as new SqlDataAdapter()
cn.open()
ad.SelectCommand=new SqlCommand("select * from table_1",cn)
dim Dt as new DataTable
ad.fill(Dt)cn.close()
Return Dt.Rows.Count '记录数C#:Dt.Rows.Count
Dt就相当于rs了,,查询出来的数据
SqlDataAdapter da = new SqlDataAdapter("select * from table_1",conn);
conn.Open();
DataTable dt = new DataTable();
da.Fill(dt);
conn.Close();
dt.Rows.Count//记录数