最近闲来没事,总结了一些asp.net分页经验,为使用方便现在写了一个可以通用的分页控件:AspNetAjaxPager:,使用ajax技术实现无刷新分页,能够控制所有数据绑定控件的分页,自己觉得效果还是挺不错的,现在奉献给大家!
本控件可以对GridView,Repeater,DataGrid,DataList...几乎所有的.net数据绑定控件进行分页,全部无刷新,数据绑定部分可以使用存储过程也可以直接使用sql语句,这对本控件没有任何干扰!本控件具有较好的用户界面,能够根据需要变换各种样式,配合css控制效果则更好!
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./TR/xhtml1/DTD/xhtml1-transitional.dtd"> <!-- //====================================================================== // 公司名称: 野人网络工作室(http://www.) // 机器名称: 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./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.) // 机器名称: 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(); } } } |
|