如何取得数据集的行的总数

[daiguan]

[playking]

set adocon = Server.CreateObject("ADODB.Connection")
adocon.open 连接数据库的字符串

Set rs = Server.CreateObject("ADODB.Recordset")
SQLstr = "Select * From t_Base"
rs.Open SQLstr,adocon,1,1

rs_count=rs.recordcount

[karma]

你的rs.recordcount 是-1，应该用

rs.Open SQLstr,adocon,2,1
or
rs.Open SQLstr,adocon,3,1

[karma]

select count(*) from table

[karma]

if you want to use recordset.recordcount, you need to use either adOpenStatic or adOpenDynamic cursor type, otherwise, recordcount will be -1

[slightgao]

无为已经把东西说的明白,我闪人

[rightyeah]

是啊，是啊

[playking]

无为，高，实在是高！我无话可说了，呵呵！

[playking]

无为：我在实际应用中就是这么用的，结果没错，当用Set rs=adocon.Execute(sqlstr)时rs.recordcount才是-1