刚写了:Jquery Pagination AJax 分页实例 For ASP 和 JQuery Pagination AJax 分页实例 For ASP.NET(JQuery+ashx+ADO.NET 实体数据模型),干脆把ASP.NET MVC3的也写一下。其实基于MVC3的代码要更简单。数据库仍然是采用LinQ TO Entity来做。两个主要文件:
Index.cshtml文件内容:
<script src="../../Scripts/jquery-1.5.1.js" type="text/javascript"></script>
<script src="../../Scripts/jquery.pagination.js" type="text/javascript"></script>
<link href="../../Content/pagination.css" rel="stylesheet" type="text/css" />
<!--列表内容显示区域-->
<table width="1000" border="0" cellspacing="0" id="List">
<tr class="ListTitle"><td>ID</td><td>书名</td><td>ISBN</td><td>单价</td><td>出版社</td><td>出版时间</td></tr>
</table>
<!--分页导航条显示区域-->
<div id="Pagination" class="pagination"></div>
<script type="text/javascript">
var ListItemNum = 15; //每页显示多少条信息
$(function () {
// 创建分页
$("#Pagination").pagination(@ViewData["RecordCount"], {
num_edge_entries: 1, //边缘页数
num_display_entries: 10, //主体页数
callback: paginationCallback, //回调函数
items_per_page: ListItemNum, //每页显示多少项
prev_text: "前一页",
next_text: "后一页"
});
});
function paginationCallback(page_index, jq) {
$.post("@Url.Action("GetPageList")", {"PageIndex": page_index, "ListItemNum": ListItemNum }, function (result) {
var str = "";
//result=eval("("+result+")");
$.each(result, function () {
str += "<tr><td>"+this.Id+"</td><td>"+this.BookTitle+"</td><td>"+this.ISBN+"</td><td>"+this.Price+"</td><td>"+this.Publish+"</td><td>"+this.Published+"</td></tr>";
});
$("#List tr:gt(0)").remove();
$("#List").append(str);
})
}
</script>
HomeController.cs文件内容:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using BookProject_For_Mvc3.Models;
namespace BookProject_For_Mvc3.Controllers
{
public class HomeController : Controller
{
BookProjectEntities db = new BookProjectEntities();
public ActionResult Index()
{
ViewData.Add("RecordCount", db.Books.Count());
return View();
}
public ActionResult GetPageList(int ListItemNum, int PageIndex)
{
var ret=db.Books
.OrderBy(s => s.Id)
.Skip((PageIndex) * ListItemNum)
.Take(ListItemNum)
.ToList();
return Json(ret);
}
}
}
其它要做的事就是创建一个ADO.NET 实体数据模型(ado.net entity framework)了,代码就上面这些了,是不是简单多了!
代码打包下载:点击下载