x.asp<% @language=javascript %>
<%
var action= request.querystring("action")
var rs
if (absolutepage=="") {
var con=Server.CreateObject("ADODB.Connection");
con.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("db1.mdb"));
rs=Server.CreateObject("ADODB.Recordset");
rs.open("Select * From table1",con);
session("rs") = rs;
} else {
rs = session("rs");
rs.movenext;
}
%><center>
<table style=border-style:solid;border-width:1; cellpadding=5 cellspacing=5>
<tr>
<td>Name</td><td>Birthday</td><td>Notes</td><td>Vip</td>
</tr>
<tr>
<td><%=rs("Name")%></td>
<td><%=rs("Birthday")%></td>
<td><%=rs("Notes")%></td>
<td><%=rs("Vip")%></td>
</tr>
</table>
<br>
<input type=button onclick="go();window.navigate("x.asp?action=next") value="下一条记录">
</center>其实在session中缓存对象不好,但是这是编码最简单的方法,要不就用rds或xml。
<%
var action= request.querystring("action")
var rs
if (absolutepage=="") {
var con=Server.CreateObject("ADODB.Connection");
con.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("db1.mdb"));
rs=Server.CreateObject("ADODB.Recordset");
rs.open("Select * From table1",con);
session("rs") = rs;
} else {
rs = session("rs");
rs.movenext;
}
%><center>
<table style=border-style:solid;border-width:1; cellpadding=5 cellspacing=5>
<tr>
<td>Name</td><td>Birthday</td><td>Notes</td><td>Vip</td>
</tr>
<tr>
<td><%=rs("Name")%></td>
<td><%=rs("Birthday")%></td>
<td><%=rs("Notes")%></td>
<td><%=rs("Vip")%></td>
</tr>
</table>
<br>
<input type=button onclick="go();window.navigate("x.asp?action=next") value="下一条记录">
</center>其实在session中缓存对象不好,但是这是编码最简单的方法,要不就用rds或xml。
<%
var action= Request.QueryString("action")
var rs
if (action!="next") {
var con=Server.CreateObject("ADODB.Connection");
con.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("db1.mdb"));
rs=Server.CreateObject("ADODB.Recordset");
rs.open("Select * From table1",con);
Session("rs") = rs;
} else {
rs = Session("rs");
rs.movenext;
}
%><center>
<table style=border-style:solid;border-width:1; cellpadding=5 cellspacing=5>
<tr>
<td>Name</td><td>Birthday</td><td>Notes</td><td>Vip</td>
</tr>
<tr>
<td><%=rs("Name")%></td>
<td><%=rs("Birthday")%></td>
<td><%=rs("Notes")%></td>
<td><%=rs("Vip")%></td>
</tr>
</table>
<br>
<input type=button onclick="window.navigate('x.asp?action=next');" value="下一条记录">
</center>
<center>
<form method=post action=finddate.asp>
每页笔数:<input name=ps type=text size=4><br>
读取第<input name=pg type=text size=4>页<br>
<input type=submit>
<input type=reset>
</form>
</center>asp文件<% @language=javascript %>
<%
var con=Server.CreateObject("ADODB.Connection");
con.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("db1.mdb"));
var rs=Server.CreateObject("ADODB.Recordset");
rs.open("Select Name,Vip From table1",con);
rs.PageSize=parseInt(Request("ps"));
rs.AbsolutePage=parseInt(Request("pg"));
%>
每页笔数:<%=Request("ps")%> <br>
目前页数:<%=Request("pg")%>/共<%=rs.PageCount%>页<table border=1>
<tr><td>Name</td><td>Vip</td></tr>
<%
for(i=1;i<parseInt(Request("ps"));i++)
{
if(rs.EOF==false)
{
%>
<tr><td><%=rs.Fields("Name")%></td></tr>
<tr><td><%=rs.Fields("Vip")%></td></tr>
<%
rs.MoveNext();
}
}
%>
</table>
<%
rs.close();
con.close();
%>
记录集分页对open方法的CursorType有要求。
livingagain(阿甘)请看这里。
http://www.csdn.net/expert/topic/506/506306.shtm