＋设为首页 ＋添加到收藏夹
<%
connstr="DBQ="+server.mappath("bbs.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr
set rs=server.createobject("adodb.recordset")
rs.open "Select * from tm " ,conn,1,3
response.write(rs.)
%>
怎样获得rs的记录总数
rs.RecordCount
rs.open "Select count(*) as tt from tm " ,conn,1,3
rs.open "Select * from tm " ,conn,1,3
--------->
rs.open "Select * from tm " ,conn,3,3
也可以
Select count(*) as MyCount from tm
rs("MyCount")
possible_Y(这个问题有点儿难度！) 的做法
打开DataGrid1属性生成器设置分页，再加代码：
Private Sub DataGrid1_PageIndexChanged(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEventArgs) Handles DataGrid1.PageIndexChanged
DataGrid1.CurrentPageIndex = e.NewPageIndex
DataGrid1.DataBind()
End Sub
recordset.pagecount;recordset.pagenext()
