快捷導(dǎo)航

AspNetAjaxPager,Asp.Net通用無刷新Ajax分頁控件，支持多樣式多數(shù)據(jù)綁定

更新時間：2009年04月13日 11:32:30 作者：

最近閑來沒事，總結(jié)了一些asp.net分頁經(jīng)驗，為使用方便現(xiàn)在寫了一個可以通用的分頁控件:AspNetAjaxPager:，使用ajax技術(shù)實現(xiàn)無刷新分頁，能夠控制所有數(shù)據(jù)綁定控件的分頁，自己覺得效果還是挺不錯的，現(xiàn)在奉獻(xiàn)給大家！

本控件可以對GridView,Repeater,DataGrid,DataList...幾乎所有的.net數(shù)據(jù)綁定控件進(jìn)行分頁，全部無刷新，數(shù)據(jù)綁定部分可以使用存儲過程也可以直接使用sql語句，這對本控件沒有任何干擾！本控件具有較好的用戶界面，能夠根據(jù)需要變換各種樣式，配合css控制效果則更好！
1.分頁樣式效果圖：

2.如何使用：
于bin目錄下添加：AspNetAjaxPager.dll引用
aspx文件內(nèi)容：

復(fù)制代碼代碼如下:

<%@ 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"> 
<!-- 
//====================================================================== 
// 公司名稱: 野人網(wǎng)絡(luò)工作室(http://www.wildren.com) 
// 機器名稱: WWW-BBE63F97A80 
// 注冊組織名: Lenovo (Beijing) Limited 
// CLR版本: 2.0.50727.1433 
// 文件名稱: Default.aspx 
// 創(chuàng)建者: 邵龍 
// 創(chuàng)建時間: 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="當(dāng)前使用中：" GotoButtonValue="轉(zhuǎn)到" 
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="轉(zhuǎn)到" 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="轉(zhuǎn)到" 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="轉(zhuǎn)到" 
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="轉(zhuǎn)到" 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="轉(zhuǎn)到" 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="轉(zhuǎn)到" 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文件內(nèi)容：

復(fù)制代碼代碼如下:

//====================================================================== 
// 公司名稱: 野人網(wǎng)絡(luò)工作室(http://www.wildren.com) 
// 機器名稱: WWW-BBE63F97A80 
// 注冊組織名: Lenovo (Beijing) Limited 
// CLR版本: 2.0.50727.1433 
// 文件名稱: Default.aspx.cs 
// 創(chuàng)建者: 邵龍 
// 創(chuàng)建時間: 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 
{ 
///點擊分頁導(dǎo)航時由控件代理對象觸發(fā)綁定事件重新顯示數(shù)據(jù) 
this.Pager1.OnPageIndexChanged = new PageIndexChangedDelegate(BindData); 
} 
} 
/// <summary> 
/// 綁定Repeater數(shù)據(jù) 
/// </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(); 
} 
} 
} 