1、MVC 表格數據靜態分頁在沒有上代碼之前先看下效果圖吧：本分頁功能主要是實現了：通過Jquery ajax 靜態分頁要建立一個分頁類，實現分頁控件的顯示，注意該類應該放在包 namespace System.Web.Mvc 下由于我用的是mvc 3 所以在分頁類方法調用時返回的是MvcHtmlString 這個在mvc 2 下也是同樣支持的看下分頁類的代碼吧： / <summary> / 分頁插件 / </summary> / <param name="helper"></param> / <param name=&qu

2、ot;urlPrefix">頁面內容連接地址</param> / <param name="divId">內容加載容器</param> / <param name="FindValue">查找內容 </param> / <param name="SortCell">排序字段</param> / <param name="OrderType">排序類型(ASC 或 DESC) 默認 DESC</par

3、am> / <param name="totalRecords">總頁數</param> / <param name="currentPage">當前頁</param> / <param name="currentPageSize">每頁顯示條數</param> / <returns></returns> public static MvcHtmlString Pager(this HtmlHelper helper, string

4、urlPrefix, string divId, string FindValue, string SortCell, string OrderType, int totalRecords, int? currentPage = 1, int? currentPageSize = 20) StringBuilder sb1 = new StringBuilder(); int pageIndex = 0; int pageSize = 0; pageIndex = int.Parse(currentPage.ToString(); pageSize = int.Parse(currentPag

5、eSize.ToString(); int pageNumber = 10; int seed = pageIndex % pageNumber = 0 ? (pageIndex - pageNumber) : pageIndex - (pageIndex % pageNumber); int AllPage = (totalRecords + pageSize - 1) / pageSize; urlPrefix = urlPrefix.TrimStart('/'); urlPrefix = "/" + urlPrefix; if (string.IsNu

6、llOrWhiteSpace(OrderType) OrderType = "DESC" if (pageIndex > pageNumber) sb1.AppendLine(String.Format("<a href='#' onclick=GetPagingParam("0","1","2","3","4","5","6") >首頁</a>", divId, 1,

7、pageSize, urlPrefix, SortCell, OrderType, FindValue); if (pageIndex > 0) int page = pageIndex - 1; if (page > 0) sb1.AppendLine(String.Format("<a href='#' onclick=GetPagingParam("0","1","2","3","4","5","6") &

8、gt;上一頁</a>", divId, page, pageSize, urlPrefix, SortCell, OrderType, FindValue); if (pageIndex - 10 > 0) sb1.AppendLine(String.Format("<a href='#' onclick=GetPagingParam("0","1","2","3","4","5","6") &g

9、t;.</a>", divId, (pageIndex - pageNumber) + 1, pageSize, urlPrefix, SortCell, OrderType, FindValue); for (int i = seed; i < AllPage && i < seed + pageNumber; i+) int page = i + 1; if (pageIndex = page) sb1.AppendLine("<span class="current">" + page

10、+ "</span>"); else sb1.AppendLine(String.Format("<a href='#' onclick=GetPagingParam("0","1","2","3","4","5","6") >1</a>", divId, page, pageSize, urlPrefix, SortCell, OrderType, FindVal

11、ue); if (pageIndex + 10 <= AllPage - 1) sb1.AppendLine(String.Format("<a href='#' onclick=GetPagingParam("0","1","2","3","4","5","6") >.</a>", divId, (pageIndex + pageNumber), pageSize, urlPrefix,

12、SortCell, OrderType, FindValue); if (pageIndex < AllPage - 1) sb1.AppendLine(String.Format("<a href='#' onclick=GetPagingParam("0","1","2","3","4","5","6") >下一頁</a>", divId, pageIndex + 1, pageSize

13、, urlPrefix, SortCell, OrderType, FindValue); if (AllPage > pageNumber && pageIndex < AllPage) sb1.AppendLine(String.Format("<a href='#' onclick=GetPagingParam("0","1","2","3","4","5","6") >尾頁</

14、a>", divId, AllPage, pageSize, urlPrefix, SortCell, OrderType, FindValue); return new MvcHtmlString(sb1.ToString(); 記得該類是放在 namespace System.Web.Mvcnamespace System.Web.Mvcpublic static class PagerHelper/加上以上代碼 就是一個分頁類了 分頁類創建完成之后就是調用使用了，其實很簡單通過js/divId 容器ID, pageIndex 當前第幾頁, pageSize每頁大小,url

15、Prefix 頁面連接地址,SortCell 排序字段,OrderType 排序類型 FindValue 查找內容function GetPagingParam(divId, pageIndex, pageSize, urlPrefix, SortCell, OrderType, searchValue) if (searchValue = undefined) searchValue = "" var urls = urlPrefix + "?FindValue=" + searchValue + "&pageIndex="

16、 + pageIndex + "&pageSize=" + pageSize + "&SortCell=" + SortCell + "&OrderType=" + OrderType; var targetDiv = "#" + divId; $.ajax( url: urls, async: false, success: function (rs) $(targetDiv).html(rs); , error: function (er) alert("分頁數據加載出錯&qu

17、ot;); );參數大家可以根據自己的需要去擴展view 使用則需要兩個view 一個是主要的容器view 一個則是數據view主容器view 調用 數據view<div id="IndexDiv" style="width: 100%">Html.RenderAction("IndexList");</div>數據view 調用自定義分頁控件<div class="digg">Html.Pager("/Admin/IndexList", "Inde

18、xDiv", "", SortCell, OrderType, Total, pageIndex, pageSize)</div>這邊的 class="digg" 是分頁控件的樣式，選中樣式（即當前頁）為span 下的 current按照以上方法就可以實現一個靜態分頁了，而且是自己寫的靜態分頁哦！如果大家沒有什么好的分頁方法介紹大家使用下：sp_cursoropen 具體如下：SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create procedure dbo.PageDataSet sql nvarchar(4000), -要執行的sql語句 currentpage int=2, -要顯示的頁碼 pagesize int=10, -每頁的大小 recordcount int=0 out, -記錄數 pagecount int=0 out -總頁數 as set nocount on declare p1 int exec sp_cursoropen p1 output,sql,scrollopt=1,ccopt=1,rowcount=pagecount output select recordc