ASP.NET无刷新分页简单实现

CREATE procedure [dbo].[P_Pager] 
(@PageNumber int, 
@PageSize int) 
as 
 declare @sql nvarchar(4000) 
 set @sql = 'select top ' + Convert(varchar, @PageSize) + ' * from T_Test where [type]=1 and id not in (select top ' + Convert(varchar, (@PageNumber - 1) * @PageSize) + ' id from T_Test order by id desc) order by id desc' 
 exec sp_executesql @sql 
GO 

<asp:UpdatePanel ID="UpdatePanel1" runat="server"> 
 <ContentTemplate> 
 <ul> 
 <asp:Repeater ID="Repeater1" runat="server"> 
 <ItemTemplate> 
 <li> 
 <p> 
 <span><%#Eval("username") %>：</span><%#Eval("content").ToString())) %></p> 
 <p> 
 <em>发表时间： 
 <%#Eval("addtime") %> 
 </em> 
 </p> 
 </li> 
 </ItemTemplate> 
 </asp:Repeater> 
 </ul> 
 <p> 
 总记录：<asp:Literal ID="ltlCount" runat="server"></asp:Literal></p> 
 <p> 
 <webdiyer:AspNetPager ID="AspNetPager1" runat="server" AlwaysShow="true" PageIndexBoxType="DropDownList" > 
 </webdiyer:AspNetPager> 
 </p> 
 </div> 
 </ContentTemplate> 
 </asp:UpdatePanel> 

using System; 
using System.Collections.Generic; 
using System.Web; 
using System.Web.UI; 
using System.Web.UI.WebControls; 
using System.Data; 
using Wuqi.Webdiyer; 
using System.Data.SqlClient; 
 
public partial class AjaxPager : System.Web.UI.Page 
{ 
 int currentPageNumber;//当前页号 
 int pageSize = 5;//每页显示记录条数 
 protected void Page_Load(object sender, EventArgs e) 
 { 
 if (!IsPostBack) 
 { 
 currentPageNumber = 1; 
 ViewState["currentPageNumber"] = currentPageNumber; 
 BindData(); 
 } 
 AspNetPager1.PageChanged += new EventHandler(AspNetPager1_PageChanged); //定义控件分页事件 
 } 
 
 //获取记录总数 
 private int GetCount() 
 { 
 string sql = "select COUNT(*) from T_Test"; 
 DataTable dt = GetTable(sql, CommandType.Text, values); 
 if (dt.Rows.Count > 0) 
 { 
 return Convert.ToInt32(dt.Rows[0][0]); 
 } 
 else 
 { 
 return 0; 
 } 
 } 
 
 //绑定数据 
 private void BindData() 
 { 
 ltlCount.Text = GetCount().ToString(); 
 currentPageNumber = Convert.ToInt32(ViewState["currentPageNumber"]); 
 SqlParameter[] values = { new SqlParameter("@PageNumber", currentPageNumber), new SqlParameter("@PageSize", pageSize) }; 
 
 DataTable dt = GetTable("P_Pager", CommandType.StoredProcedure, values); //调用存储过程 
 if (dt.Rows.Count > 0) 
 { 
 AspNetPager1.PageSize = pageSize; 
 AspNetPager1.RecordCount = GetCount(); 
 AspNetPager1.CurrentPageIndex = currentPageNumber; 
 this.Repeater1.DataSource = dt.DefaultView; 
 this.Repeater1.DataBind(); 
 } 
 } 
 
 //分页事件 
 void AspNetPager1_PageChanged(object sender, EventArgs e) 
 { 
 currentPageNumber = AspNetPager1.CurrentPageIndex; 
 ViewState["currentPageNumber"] = currentPageNumber; 
 BindData(); 
 } 
 
 // 读取存储过程返回table 
 private DataTable GetTable(string sql, CommandType t, params SqlParameter[] values) 
 { 
 using (SqlConnection conn = new SqlConnection("Data Source=127.0.0.1;Initial Catalog=testDB;Persist Security Info=True;User ID=sa;Password=123456")) 
 { 
 SqlCommand comm = new SqlCommand(sql, conn); 
 comm.CommandType = t; 
 if (values != null && values.Length > 0) 
 comm.Parameters.AddRange(values); 
 SqlDataAdapter da = new SqlDataAdapter(comm); 
 DataSet ds = new DataSet(); 
 try 
 { 
 conn.Open(); 
 da.Fill(ds); 
 return ds.Tables[0]; 
 } 
 catch (Exception) 
 { 
 return null; 
 } 
 finally 
 { 
 conn.Close(); 
 conn.Dispose(); 
 } 
 } 
 } 
}