asp.net中利用Jquery+Ajax+Json實(shí)現(xiàn)無刷新分頁的實(shí)例代碼_

1、中利用Jquery+Ajax+Json實(shí)現(xiàn)無刷新分頁的實(shí)例代碼_ 本篇文章主要是對(duì)中利用Jquery+Ajax+Json實(shí)現(xiàn)無刷新分頁的實(shí)例代碼進(jìn)行了介紹，需要的伴侶可以過來參考下，需要對(duì)大家有所關(guān)心 代碼如下: % Page Language=C# AutoEventWireup=true CodeFile=AjaxJson.aspx.cs Inherits=AjaxJson % !DOCTYPE html PUBLIC -/W3C/DTD XHTML 1.0 Transitional/EN l1/DTD/xhtml1-transitional.dtd html xmlns=l head r

2、unat=server titleJquery+Ajax+Json分頁/title meta http-equiv=content-type content=text/html; charset=gb2312 link href=Styles/tablecloth.css rel=stylesheet type=text/css / link href=Styles/pagination.css rel=stylesheet type=text/css / script type=text/javascript src=Scripts/jquery-1.4.4.min.js/script sc

3、ript type=text/javascript src=Scripts/jquery.pagination.js/script script type=text/javascript var pageIndex = 0; /頁面索引初始值 var pageSize = 10; /每頁顯示條數(shù)初始化，修改顯示條數(shù)，修改這里即可 $(function () InitTable(0); /Load大事，初始化表格數(shù)據(jù)，頁面索引為0（第一頁） /分頁，PageCount是總條目數(shù)，這是必選參數(shù)，其它參數(shù)都是可選 $(#Pagination).pagination(%=pageCount %, ca

4、llback: PageCallback, prev_text: 上一頁, /上一頁按鈕里text next_text: 下一頁, /下一頁按鈕里text items_per_page: pageSize, /顯示條數(shù) num_display_entries: 6, /連續(xù)分頁主體部分分頁條目數(shù) current_page: pageIndex, /當(dāng)前頁索引 num_edge_entries: 2 /兩側(cè)首尾分頁條目數(shù) ); /翻頁調(diào)用 function PageCallback(index, jq) InitTable(index); /懇求數(shù)據(jù) function InitTable(pag

5、eIndex) $.ajax( type: POST, dataType: json, url: SupplyAJAX.aspx, /提交到一般處理程序懇求數(shù)據(jù) data: type=showrandom= + Math.random() + pageIndex= + (pageIndex + 1) + pageSize= + pageSize, /提交兩個(gè)參數(shù)：pageIndex(頁面索引)，pageSize(顯示條數(shù)) error: function () alert(error data); , /錯(cuò)誤執(zhí)行方法 success: function (data) $(#Result tr:

6、gt(0).remove(); /移除Id為Result的表格里的行，從其次行開頭（這里依據(jù)頁面布局不同頁變） var json = data; /數(shù)組 var html = ; $.each(json.data, function (index, item) /循環(huán)獵取數(shù)據(jù) var id = item.Id; var name = item.Name; var sex = item.Sex; html += trtd + id + /tdtd + name + /tdtd + sex + /td/tr; ); $(#Result).append(html); /將返回的數(shù)據(jù)追加到表格 );

7、); /script /head body form id=form1 runat=server table id=Result cellspacing=0 cellpadding=0 tr th 編號(hào) /th th 姓名 /th th 性別 /th /tr /table div id=Pagination /div /form /body /html 代碼如下: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Text; using System

8、.Net; using System.IO; using System.Web.UI; using System.Web.UI.WebControls; public partial class AjaxJson : System.Web.UI.Page public string pageCount = string.Empty; /總條目數(shù) protected void Page_Load(object sender, EventArgs e) if (!IsPostBack) string url = /SupplyAJAX.aspx; string strResult = GetReq

9、uestJsonString(url, type=getcount); pageCount = strResult.ToString(); #region 后臺(tái)獵取ashx返回的數(shù)據(jù) / summary / 后臺(tái)獵取ashx返回的數(shù)據(jù) / /summary / param name=relativePath地址/param / param name=data參數(shù)/param / returns/returns public static string GetRequestJsonString(string relativePath, string data) string requestUrl

10、 = GetRequestUrl(relativePath, data); try WebRequest request = WebRequest.Create(requestUrl); request.Method = GET; StreamReader jsonStream = new StreamReader(request.GetResponse().GetResponseStream(); string jsonObject = jsonStream.ReadToEnd(); return jsonObject; catch return string.Empty; public s

11、tatic string GetRequestUrl(string relativePath, string data) string absolutePath = HttpContext.Current.Request.Url.AbsoluteUri; string hostNameAndPort = HttpContext.Current.Request.Url.Authority; string applicationDir = HttpContext.Current.Request.ApplicationPath; StringBuilder sbRequestUrl = new St

12、ringBuilder(); sbRequestUrl.Append(absolutePath.Substring(0, absolutePath.IndexOf(hostNameAndPort); sbRequestUrl.Append(hostNameAndPort); sbRequestUrl.Append(applicationDir); sbRequestUrl.Append(relativePath); if (!string.IsNullOrEmpty(data) sbRequestUrl.Append(?); sbRequestUrl.Append(data); return

13、sbRequestUrl.ToString(); #endregion 代碼如下: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Data; using System.Web.UI; using System.Web.UI.WebControls; /新增 using System.Web.Script.Serialization; using System.Text; public partial class SupplyAJAX : Syst

14、em.Web.UI.Page protected static ListStudent StudentList = new ListStudent(); protected static int RecordCount = 0; protected static DataTable dt = CreateDT(); protected void Page_Load(object sender, EventArgs e) switch (Requesttype) case show: #region 分頁配置 /具體的頁面數(shù) int pageIndex; int.TryParse(Request

15、pageIndex, out pageIndex); /頁面顯示條數(shù) int PageSize = Convert.ToInt32(RequestpageSize); if (pageIndex = 0) pageIndex = 1; #endregion DataTable PagedDT = GetPagedTable(dt, pageIndex, PageSize); ListStudent list = new ListStudent(); foreach (DataRow dr in PagedDT.Rows) Student c = new Student(); c.Id = (I

16、nt32)drId; c.Name = drName.ToString(); c.Sex = drSex.ToString(); list.Add(c); string json = new JavaScriptSerializer().Serialize(list);/這個(gè)很關(guān)鍵，否則error StringBuilder Builder = new StringBuilder(); Builder.Append(); Builder.Append(recordcount: + RecordCount + ,); Builder.Append(data:); Builder.Append(j

17、son); Builder.Append(); Response.ContentType = application/json; Response.Write(Builder.ToString(); break; case getcount: Response.Write(dt.Rows.Count); break; case add: break; case update: break; case delete: break; Response.End(); #region 模擬數(shù)據(jù) private static DataTable CreateDT() DataTable dt = new

18、 DataTable(); dt.Columns.Add(new DataColumn(Id, typeof(int) DefaultValue = 0 ); dt.Columns.Add(new DataColumn(Name, typeof(string) DefaultValue = 1 ); dt.Columns.Add(new DataColumn(Sex, typeof(string) DefaultValue = 男 ); for (int i = 1; i = 1000; i+) dt.Rows.Add(i, 張三 + i.ToString().PadLeft(4, 0); R

19、ecordCount = dt.Rows.Count; return dt; #endregion / summary / 對(duì)DataTable進(jìn)行分頁,起始頁為1 / /summary / param name=dt/param / param name=PageIndex/param / param name=PageSize/param / returns/returns public static DataTable GetPagedTable(DataTable dt, int PageIndex, int PageSize) if (PageIndex = 0) return dt; DataTable newdt = dt.Copy(); newdt.Clear(); int rowbegin = (PageIndex - 1) * PageSize; int rowend = PageIndex * PageSize; if (rowbegin = dt.R