C# dataGridView分页

using MySql.Data.MySqlClient;
using System;
using System.Data;
using System.Windows.Forms;

public partial class Form1 : Form
{
    private const int PageSize = 100; // 每页加载的记录数量
    private int currentPage = 1; // 当前页码

    public Form1()
    {
        InitializeComponent();
    }

    private void Form1_Load(object sender, EventArgs e)
    {
        LoadData(); // 初始化加载数据
    }

    private void LoadData()
    {
        string connStr = "your_connection_string"; // MySQL连接字符串
        string query = "SELECT * FROM your_table"; // 查询语句

        using (MySqlConnection conn = new MySqlConnection(connStr))
        {
            conn.Open();

            int offset = (currentPage - 1) * PageSize;
            query += $" LIMIT {offset},{PageSize}"; // 添加分页限制

            using (MySqlDataAdapter adapter = new MySqlDataAdapter(query, conn))
            {
                DataTable dataTable = new DataTable();
                adapter.Fill(dataTable);

                dataGridView1.DataSource = dataTable;
            }
        }
    }

    private void btnPrevious_Click(object sender, EventArgs e)
    {
        if (currentPage > 1)
        {
            currentPage--;
            LoadData();
        }
    }

    private void btnNext_Click(object sender, EventArgs e)
    {
        currentPage++;
        LoadData();
    }
}