1.分页样式效果图:
2.如何使用:
于bin目录下添加:aspnetajaxpager.dll引用
aspx文件内容:
复制代码 代码如下:
<%@ page language="c#" autoeventwireup="true" codefile="default.aspx.cs" inherits="demo._default" %>
<%@ register namespace="aspnetajaxpager" tagprefix="ajax" assembly="aspnetajaxpager"%>
<!doctype html public "-//w3c//dtd xhtml 1.0 transitional//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd">
<!--
//======================================================================
// 公司名称: 野人网络工作室(http://www.wildren.com)
// 机器名称: www-bbe63f97a80
// 注册组织名: lenovo (beijing) limited
// clr版本: 2.0.50727.1433
// 文件名称: default.aspx
// 创建者: 邵龙
// 创建时间: 2009-4-4 16:29:49
// 程序版本: 1.0版
// 功能描述: aspnetajaxpager使用demo
// 修改记录:
//======================================================================
-->
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>aspnetajaxpager使用demo</title>
<link href="css/style.css" type="text/css" rel="stylesheet" />
<script src="js/jquery-1.3.2.min.js" type="text/javascript"></script>
</head>
<body>
<form id="form1" runat="server">
<div>
<div id="pannel">
<div class="pagingwrapper">
<asp:repeater id="repeater1" runat="server">
<headertemplate>
<table border="0" cellpadding="0" cellspacing="0" class="stripe">
<tr>
<td>编号</td>
<td>姓名</td>
<td>年龄</td>
</tr>
</headertemplate>
<itemtemplate>
<tr>
<td>
<%# eval("id")%>
</td>
<td>
<%# eval("name") %>
</td>
<td>
<%# eval("age")%>
</td>
</tr>
</itemtemplate>
<footertemplate>
</table>
</footertemplate>
</asp:repeater>
</div>
<div>
<ajax:ajaxpager id="pager1" runat="server" ajaxcontainerid="pannel" pagedcontrolid="repeater1" align="left"
backcolor="transparent" bordercolor="red" borderwidth="0px" descriptiontext="当前使用中:" gotobuttonvalue="转到"
cssclass="navi" isgotoselectvisible="false" isgototextboxvisible="false" leftpagesize="0" rightpagesize="0" currentnumberbgcolor="white" />
<br />
<br />
</div>
<ajax:ajaxpager id="ajaxpager1" runat="server" ajaxcontainerid="pannel" pagedcontrolid="repeater1" align="left"
backcolor="transparent" bordercolor="red" borderwidth="0px" descriptiontext="" gotobuttonvalue="转到" cssclass="navi"
recordcount="1500" isgotoselectvisible="false" isgototextboxvisible="false"/>
<br />
<br />
<ajax:ajaxpager id="ajaxpager2" runat="server" ajaxcontainerid="pannel" pagedcontrolid="repeater1" align="left"
backcolor="transparent" bordercolor="red" borderwidth="0px" descriptiontext="" gotobuttonvalue="转到" cssclass="navi"
recordcount="1500" isgotoselectvisible="false"/>
<br />
<br />
<ajax:ajaxpager id="ajaxpager3" runat="server" ajaxcontainerid="pannel" align="left"
backcolor="transparent" bordercolor="red" borderwidth="0px" cssclass="navi" descriptiontext=""
gotobuttonvalue="转到"
pagedcontrolid="repeater1" recordcount="1500" />
<br />
<br />
<ajax:ajaxpager id="ajaxpager4" runat="server" ajaxcontainerid="pannel" align="left"
backcolor="darkgray" bordercolor="red" borderwidth="1px" cssclass="navi" descriptiontext=""
gotobuttonvalue="转到" isgotoselectvisible="false"
pagedcontrolid="repeater1" recordcount="1500" cellspacing="1px" />
<br />
<br />
<br />
<ajax:ajaxpager id="ajaxpager5" runat="server" ajaxcontainerid="pannel" align="left"
backcolor="transparent" bordercolor="red" borderwidth="0px" cssclass="navi" descriptiontext=""
gotobuttonvalue="转到" isgototextboxvisible="false"
pagedcontrolid="repeater1" recordcount="1500" linkistext="false" nextlink="img/next.gif" firstlink="img/first.gif" lastlink="img/last.gif" previouslink="img/previous.gif" />
<br />
<br />
<ajax:ajaxpager id="ajaxpager6" runat="server" ajaxcontainerid="pannel" align="left"
backcolor="transparent" bordercolor="red" borderwidth="0px" cssclass="navi" descriptiontext=""
gotobuttonvalue="转到" isgotoselectvisible="false" isgototextboxvisible="false"
pagedcontrolid="repeater1" recordcount="1500" currentnumberbgcolor="yellow" currentpagecolor="lime" linknumberwidth="20px" />
<br />
<br />
</div>
</div>
</form>
</body>
</html>
<script type="text/javascript">
$(document).ready(function(){
$(".stripe tr").mouseover(function(){
$(this).addclass("over");}).mouseout(function(){
$(this).removeclass("over");})
$(".stripe tr:even").addclass("alt");
});
</script>
.cs文件内容:
复制代码 代码如下:
//======================================================================
// 公司名称: 野人网络工作室(http://www.wildren.com)
// 机器名称: www-bbe63f97a80
// 注册组织名: lenovo (beijing) limited
// clr版本: 2.0.50727.1433
// 文件名称: default.aspx.cs
// 创建者: 邵龙
// 创建时间: 2009-4-4 16:29:49
// 程序版本: 1.0版
// 功能描述: aspnetajaxpager使用demo
// 修改记录:
//======================================================================
using system;
using system.data;
using system.configuration;
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 system.data.oledb;
using aspnetajaxpager.delegate;
namespace demo
{
public partial class _default : system.web.ui.page
{
private oledbconnection conn;
private oledbcommand cmd;
protected void page_load(object sender, eventargs e)
{
if (!page.ispostback)
{
this.binddata(this.pager1.currentpageindex, this.pager1.pagesize);
}
else
{
///点击分页导航时由控件代理对象触发绑定事件重新显示数据
this.pager1.onpageindexchanged = new pageindexchangeddelegate(binddata);
}
}
/// <summary>
/// 绑定repeater数据
/// </summary>
/// <param name="pageindex"></param>
/// <param name="pagesize"></param>
public void binddata(int pageindex, int pagesize)
{
int intstartindex = (pageindex - 1) * pagesize + 1;
int intendindex = pageindex * pagesize;
conn = new oledbconnection();
conn.connectionstring = @"provider=microsoft.jet.oledb.4.0;data source=" + server.mappath("~/app_data/db.mdb");
cmd = conn.createcommand();
conn.open();
///此部分可以换成存储过程分页,对控件没有任何影响
cmd.commandtext = "select count(*) from students";
int totalcount = (int)cmd.executescalar();
cmd.commandtext = string.format("select * from students where id >= {0} and id <= {1}", intstartindex, intendindex);
dataset ds = new dataset();
oledbdataadapter da = new oledbdataadapter(cmd.commandtext, conn);
da.fill(ds);
this.pager1.recordcount = totalcount;
this.repeater1.datasource = ds;
this.repeater1.databind();
}
}
}
【说明】:本文章由站长整理发布,文章内容不代表本站观点,如文中有侵权行为,请与本站客服联系(QQ:)!