[C#] – DataGridView分頁

來源：http://xinyuan178.blog.163.com/blog/static/49799652200942342122524/

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

using System.Data.SqlClient;


public partial class Form1 : Form
{
public Form1()
    {
        InitializeComponent();
    }

int pageSize = 0;     // 每頁顯示行數
    int pageCount = 0;    // 頁數=總記錄數/每頁顯示行數
    int recordCount = 0;  // 總記錄數
    int curPageNum = 0;   // 當前頁號
    int curRowNum = 0;    // 目前記錄行
    DataSet DS = new DataSet();
    DataTable dtInfo = new DataTable();

private void Form1_Load(object sender, EventArgs e)
    {
string connStr = "Server=localhost;Database=Northwind;UID=sa;Pwd=;";
string cmdStr = "Select * from [Customers]";
using (SqlConnection sqlConn = new SqlConnection(connStr))
        {
            sqlConn.Open();
using (SqlDataAdapter sqlDA = new SqlDataAdapter(cmdStr, sqlConn))
            {
                sqlDA.Fill(DS);
            }
            sqlConn.Close();
        }
        dtInfo = DS.Tables[0];
        InitDataSet();
    }

private void InitDataSet()
    {
        pageSize = 10;                         // 設定頁面行數
        recordCount = dtInfo.Rows.Count;
        pageCount = (recordCount / pageSize);  // 計算出總頁數
        if ((recordCount % pageSize) > 0) { pageCount++; }
        curPageNum = 1;                        // 當前頁數從1開始
        curRowNum = 0;                         // 目前記錄數從0開始
        LoadData();
    }

private void LoadData()
    {
int startPos = 0;                   // 當前頁面開始記錄行
        int endPos = 0;                     // 當前頁面結束記錄行
        DataTable dtTemp = dtInfo.Clone();  // 複製DataTable結構架構
        if (curPageNum == pageCount)
        {
            endPos = recordCount;
        }
else
        {
            endPos = pageSize * curPageNum;
        }
        startPos = curRowNum;
        label1.Text = string.Format("第{0}頁/共{1}頁", curPageNum, pageCount);

// 從中繼資料源複製記錄行
        for (int i = startPos; i < endPos; i++)
        {
            dtTemp.ImportRow(dtInfo.Rows[i]);
            curRowNum++;
        }

        dataGridView1.DataSource = dtTemp;
    }

// 三個按鈕的事件
    private void ButtonClicked(object sender, EventArgs e)
    {
switch (((Button)sender).Text)
        {
case "上一頁":
                curPageNum--;
if (curPageNum <= 0)
                {
                    curPageNum = 0;
                    MessageBox.Show("已經是第一頁，請點擊“下一頁”查看！");
return;
                }
                curRowNum = pageSize * (curPageNum - 1);
                LoadData();
break;

case "下一頁":
                curPageNum++;
if (curPageNum > pageCount)
                {
                    curPageNum = pageCount;
                    MessageBox.Show("已經是最後一頁，請點擊“上一頁”查看！");
return;
                }
                curRowNum = pageSize * (curPageNum - 1);
                LoadData();
break;

case "關閉":
this.Close();
                Application.Exit();
break;

default:
break;
        }
    }
}