asp教程.net 的aspnetpager分页代码
@ page language="c#" autoeventwireup="true" codefile="default.aspx.cs" inherits="test_default" stylesheettheme="default" %>
<%...@ register assembly="aspnetpager" namespace="wuqi.webdiyer" tagprefix="webdiyer" %>
<html xmlns="http://www.111cn.net/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:datalist id="datalist1" runat="server">
<itemtemplate>
productname:
<asp:label id="productnamelabel" runat="server" text='<%# eval("productname") %>'>
</asp:label><br />
<br />
</itemtemplate>
</asp:datalist>
<webdiyer:aspnetpager id="pager1" runat="server" onpagechanged="changepage"></webdiyer:aspnetpager>
</div>
</form>
</body>
</html>
<%
using system;
using system.data;
using system.configuration;
using system.collections;
using system.web;
using system.web.security;
using system.web.ui;
using system.web.ui.webcontrols;
using system.web.ui.webcontrols.webparts;
using system.web.ui.htmlcontrols;
using cpp114.tools.oledb;
using system.data.oledb;
using wuqi.webdiyer;public partial class test_default : system.web.ui.page
...{
protected oledbconnection conn = new oledbconnection();
protected oledbcommand cmd = new oledbcommand();protected void page_load(object sender, eventargs e)
...{
if (!ispostback) ...{
initdb();
conn.open();
cmd.commandtext = "select count(*) from t_product";
pager1.recordcount = (int)cmd.executescalar();
conn.close();
binddata();
}}
//初始化连接对象
protected void initdb()...{
conn.connectionstring = oledbtool.myconnstr + server.mappath(oledbtool.mydbname);
cmd.connection = conn;
}
//数据绑定
protected void binddata() ...{
initdb();
oledbdataadapter sda = new oledbdataadapter("select * from t_product",conn);
dataset ds = new dataset();
//sda.fill(ds, 10, 10, "temptbl");
sda.fill(ds, pager1.pagesize * (pager1.currentpageindex - 1), pager1.pagesize, "temptbl");
datalist1.datasource = ds.tables["temptbl"];
datalist1.databind();
}
//翻页事件
protected void changepage(object src, pagechangedeventargs e)
...{
pager1.currentpageindex = e.newpageindex;
binddata();
}}