ObjectDataSource是唯一支持自定義分頁(yè)的數(shù)據(jù)源 ，要實(shí)現(xiàn)分頁(yè)效果，首先要將ObjectDataSource.EnablePageing屬性設(shè)為true，通過(guò)三個(gè)屬性實(shí)現(xiàn)：StartRowIndex,MaximumRows和SelectCountMethod，效果如圖：

實(shí)現(xiàn)分頁(yè)有兩種情況： 一種是假分頁(yè)，一種是真分頁(yè)；

假分頁(yè) ：就是將數(shù)據(jù)全部取出來(lái)，只是分頁(yè)顯示，它不是分頁(yè)取數(shù)據(jù)，只是分頁(yè)顯示。

真分頁(yè) ：就是按需取數(shù)據(jù)，只取出每一頁(yè)所需的數(shù)據(jù)；這里是使用存儲(chǔ)過(guò)程做的是真分頁(yè)。

首先，最重要的是使用到的存儲(chǔ)過(guò)程：（以NorthWind數(shù)據(jù)庫(kù)為例）

ALTER PROCEDURE GetEmployeePage @Start int, @Count int AS -- 創(chuàng)建一張臨時(shí)表，增加ID屬性列。 CREATE TABLE #TempEmployees ( ID int IDENTITY PRIMARY KEY, EmployeeID int, LastName nvarchar(20), FirstName nvarchar(10), TitleOfCourtesy nvarchar(25), ) -- 用employees表的相關(guān)字段來(lái)填充臨時(shí)表。 INSERT INTO #TempEmployees ( EmployeeID, LastName, FirstName, TitleOfCourtesy ) SELECT EmployeeID, LastName, FirstName, TitleOfCourtesy FROM Employees ORDER BY EmployeeID ASC -- 聲明兩個(gè)變量來(lái)計(jì)算的記錄的范圍。 DECLARE @FromID int DECLARE @ToID int -- 計(jì)算我們需要的第一個(gè)和最后一個(gè)編號(hào)的各種記錄。 SET @FromID = @Start SET @ToID = @Start + @Count - 1 -- 查找一頁(yè)顯示的內(nèi)容。 SELECT * FROM #TempEmployees WHERE ID >= @FromID AND ID <= @ToID

其次，就是調(diào)用存儲(chǔ)過(guò)程的數(shù)據(jù)訪(fǎng)問(wèn)類(lèi)：

public class EmployeesPager { public EmployeesPager() { } private string connectionString; public List<EmployeeDetails> GetEmployees(int startRowIndex, int maximumRows) { connectionString = WebConfigurationManager.ConnectionStrings["Northwind"].ConnectionString; SqlConnection con = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand("GetEmployeePage", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Start", SqlDbType.Int, 4)); cmd.Parameters["@Start"].Value = startRowIndex +1; cmd.Parameters.Add(new SqlParameter("@Count", SqlDbType.Int, 4)); cmd.Parameters["@Count"].Value = maximumRows; // Create a collection for all the employee records. List<EmployeeDetails> employees = new List<EmployeeDetails>(); try { con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { EmployeeDetails emp = new EmployeeDetails( (int)reader["EmployeeID"], (string)reader["FirstName"], (string)reader["LastName"], (string)reader["TitleOfCourtesy"]); employees.Add(emp); } reader.Close(); return employees; } catch (SqlException err) { // Replace the error with something less specific. // You could also log the error now. throw new ApplicationException("Data error."); } finally { con.Close(); } } }

最后，就是前臺(tái)界面調(diào)用這個(gè)訪(fǎng)問(wèn)類(lèi)的方法：

protected void Page_Load(object sender, EventArgs e) { EmployeesPager emp = new EmployeesPager(); GridView1.DataSource = emp.GetEmployees(0, 5);//默認(rèn)顯示前5條記錄； GridView1.DataBind(); if (!IsPostBack) { for (int i = 1; i < 10; i++) { DropDownList1.Items.Add(i.ToString()); } } } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { EmployeesPager emp = new EmployeesPager(); GridView1.DataSource = emp.GetEmployees((Convert.ToInt32(DropDownList1.SelectedItem.Text)-1),3); GridView1.DataBind(); }

ObjectDataSource自定義分頁(yè)