ASP.NET 提供了 GridView 等便利的資料展示控制項,本身也內建分頁功能。但實務上,若不停用 ViewState,頁面體積會相當龐大;而且點擊首頁、上一頁、下一頁等操作都會觸發頁面回發,需要與伺服器完整往返,無論是回應時間或傳輸量都不划算。
AJAX 分頁正好能解決這些痛點:只在需要時向伺服器索取當前頁的資料,不必重新載入整個頁面。本範例的環境為 jQuery AJAX 搭配 Northwind 範例資料庫。
var pageIndex = 0;
var pageSize = 10;
$(function () {
$("#btnSearch").click(function () {
var name = $("#txtSearch").val();
pageIndex = 0;
AjaxGetData(name, pageIndex, pageSize);
});
});
function AjaxGetData(name, index, size) {
$.ajax({
url: "jQueryPaging.aspx",
type: "Get",
data: "Name=" + name + "&PageIndex=" + index + "&PageSize=" + size,
dataType: "json",
success: function (data) {
var htmlStr = "<table><thead>";
htmlStr += "<tr><td>CustomerID</td><td>CompanyName</td>...</tr>";
htmlStr += "</thead><tbody>";
for (var i = 0; i < data.Customers.length; i++) {
htmlStr += "<tr><td>" + data.Customers[i].CustomerID + "</td>...</tr>";
}
htmlStr += "</tbody><tfoot>";
htmlStr += "<span>共有記錄" + data.Count + ";共<span id='count'>"
+ (data.Count % 10 == 0 ? parseInt(data.Count / 10) : parseInt(data.Count / 10 + 1))
+ "</span>頁</span>";
htmlStr += "<a href='javascript:void' onclick='GoToFirstPage()'>首 頁</a> ";
htmlStr += "<a href='javascript:void' onclick='GoToPrePage()'>前一頁</a> ";
htmlStr += "<a href='javascript:void' onclick='GoToNextPage()'>後一頁</a> ";
htmlStr += "<a href='javascript:void' onclick='GoToEndPage()'>尾 頁</a> ";
htmlStr += "</tfoot></table>";
$("#divSearchResult").html(htmlStr);
},
error: function (XMLHttpRequest, textStatus, errorThrown) {
alert(errorThrown + ':' + textStatus);
}
});
}
function GoToFirstPage() { pageIndex = 0; AjaxGetData($("#txtSearch").val(), pageIndex, pageSize); }
function GoToPrePage() { pageIndex = pageIndex >= 1 ? pageIndex - 1 : 0; AjaxGetData($("#txtSearch").val(), pageIndex, pageSize); }
function GoToNextPage() {
if (pageIndex + 1 < parseInt($("#count").text())) { pageIndex += 1; }
AjaxGetData($("#txtSearch").val(), pageIndex, pageSize);
}
function GoToEndPage() { pageIndex = parseInt($("#count").text()) - 1; AjaxGetData($("#txtSearch").val(), pageIndex, pageSize); }
後端透過一般村民程序接收參數、查詢資料,並以 JavaScriptSerializer 序列化為 JSON 回傳。核心片段如下:
protected void Page_Load(object sender, EventArgs e) {
Int32 pageIndex = Int32.MinValue, pageSize = Int32.MinValue;
String name = String.Empty;
JavaScriptSerializer jss = new JavaScriptSerializer();
if (Request["Name"] != null) {
name = Request["Name"].ToString();
pageIndex = Int32.Parse(Request["PageIndex"].ToString());
pageSize = Request["PageSize"] != null ? Int32.Parse(Request["PageSize"].ToString()) : 10;
DataSet ds = LookDataFromDB(name, pageIndex, pageSize);
// 組裝 Customer 清單後序列化輸出
Response.Write("{\"Count\":" + ds.Tables[1].Rows[0][0]
+ ",\"Customers\":" + jss.Serialize(customersLists) + "}");
Response.End();
}
}
真正的分頁邏輯交由 SQL 存儲過程處理,利用 Row_Number() 為結果排序編號,再依頁索引與頁大小擷取對應區間,同時回傳符合條件的總筆數:
Create PROCEDURE SearchCustomerByName
@name nvarchar(30), @pageIndex int, @pageSize int
AS
BEGIN
SET NOCOUNT ON;
select t.* from (
select Row_Number() over (order by CustomerID) AS RowNum, *
from Customers where ContactName like '%' + @name + '%'
) t
where t.RowNum between @pageIndex * 10 + 1 and (@pageIndex + 1) * 10
select count(*) from Customers where ContactName like '%' + @name + '%'
END
整個方案的資料傳輸採用輕量級的 JSON,前端則以 table 動態組裝畫面,讓產生的 HTML 保持簡潔。這個版本著重於示範流程,仍有許多實務細節(如輸入驗證、跳轉頁碼的邊界處理、安全性等)未及考量,讀者可依自身專案需求再行擴充。將上述前端、後端與資料庫程式碼對應貼入 Visual Studio 與資料庫中,即可完整運行觀看效果。