两种方法
1 数据库
<%
strsql="select count(*) reccount from yourtable"
set oconn=server.createobject("adodb.connection")
set ocmd=server.createobject("adodb.command")
set orec=server.createobject("adodb.recordset")
oconn.open yourdbsconn
ocmd.activeconnection=oconn
ocmd.commandtext=strsql
set orec=ocmd.execute
drecount=cdbl(orec("reccount"))
%>
2记录集循环
<%
strsql="select from yourtable"
set oconn=server.createobject("adodb.connection")
set ocmd=server.createobject("adodb.command")
set orec=server.createobject("adodb.recordset")
oconn.open yourdbsconn
ocmd.activeconnection=oconn
ocmd.commandtext=strsql
set orec=ocmd.execute
dcount=0
while not orec.eof
dcount=dcount+1
orec.movenext
wend
itotalcount=dcount
%>
Set myconn=Server.CreateObject("ADODB.Connection")
Set rs=Server.CreateObject("ADODB.Recordset")
myconn.open"连接数据库语句"
sqlstring="select * from table"
rs.open sqlstring,myconn
totalrec=rs.recordcount
response.write totalrec