HOW TO：使用 Visual C# _NET 对 DataGrid Windows 控件执行分页(转载)

using System;
using System.Data;
using System.Data.SqlClient;

SqlDataAdapter da;
DataSet ds;
DataTable dtSource;
int PageCount;
int maxRec;
int pageSize;
int currentPage;
int recNo;

private void LoadPage() {
int i;
int startRec;
int endRec;
DataTable dtTemp;

//Clone the source table to create a temporary table.
dtTemp = dtSource.Clone();

if (currentPage == PageCount) {
	endRec = maxRec;
     }
else {
	endRec = pageSize * currentPage;
     }
startRec = recNo;

//Copy rows from the source table to fill the temporary table.
for (i = startRec; i < endRec; i++) {
	dtTemp.ImportRow(dtSource.Rows[i]);
	recNo += 1;
     }
dataGrid1.DataSource = dtTemp;
DisplayPageInfo();
}

private void DisplayPageInfo() {
txtDisplayPageNo.Text = "Page " + currentPage.ToString() + "/ " + PageCount.ToString();
}

private bool CheckFillButton() {
//Check if the user clicks the "Fill Grid" button.
if (pageSize == 0) {
MessageBox.Show("Set the Page Size, and then click the Fill Grid button!");
return false;
  }
else {
return true;
  }
}

//Open Connection.
SqlConnection con = new SqlConnection("server=server;uid=login;pwd=pwd;database=northwind");

//Set the DataAdapter's query.
da = new SqlDataAdapter("select * from customers", conn);
ds = new DataSet();

//Fill the DataSet.
da.Fill(ds, "customers");

//Set the source table.
dtSource = ds.Tables["customers"];

SqlConnection con = new SqlConnection("server=server;uid=login;pwd=pwd;database=northwind");
					</WWCODE>
					<WWITEM>双击<B> Fill Grid</B> 以打开 btnFillGrid 的代码窗口。复制以下代码并将其粘贴到 <B>btnFillGrid_Click</B> 事件过程中： </WWITEM>
					<WWCODE>
						<![CDATA[
// Set the start and max records.
pageSize = Convert.ToInt32(txtPageSize.Text);
maxRec = dtSource.Rows.Count;
PageCount = maxRec / pageSize;

//Adjust the page number if the last page contains a partial page.
if ((maxRec % pageSize) > 0) {
	   PageCount += 1;
    }

// Initial seeings
currentPage = 1;
recNo = 0;

// Display the content of the current page.
LoadPage();

if (CheckFillButton() == false) {
return;
   }

//Check if you are already at the first page.
if (currentPage == 1) {
MessageBox.Show("You are at the First Page!");
return;
   }

currentPage = 1;
recNo = 0;
LoadPage();

//If the user did not click the "Fill Grid" button, then return.
if (CheckFillButton() == false) {
return;
   }

//Check if the user clicks the "Fill Grid" button.
if (pageSize == 0) {
MessageBox.Show("Set the Page Size, and then click the Fill Grid button!");
return;
   }

currentPage += 1;
if (currentPage > PageCount) {
currentPage = PageCount;
//Check if you are already at the last page.
if (recNo == maxRec) {
MessageBox.Show("You are at the Last Page!");
	   return;
       }
   }
LoadPage();

if (CheckFillButton() == false) {
return;
   }

if (currentPage == PageCount) {
recNo = pageSize * (currentPage -2);
   }

currentPage -= 1;
//Check if you are already at the first page.
if (currentPage < 1) {
MessageBox.Show("You are at the First Page!");
currentPage = 1;
return;
   }
else {
recNo = pageSize * (currentPage - 1);
   }
LoadPage();

if (CheckFillButton() == false) {
return;
   }

//Check if you are already at the last page.
if (recNo == maxRec) {
MessageBox.Show("You are at the Last Page!");
return;
   }
currentPage = PageCount;
recNo = pageSize * (currentPage - 1);
LoadPage();