使用大数据填充DataGridView时性能较慢

// 示例代码：分页加载数据
private void LoadData(int pageIndex, int pageSize)
{
    using (SqlConnection conn = new SqlConnection(connectionString))
    {
        string query = "SELECT * FROM YourTable ORDER BY ID OFFSET @Offset ROWS FETCH NEXT @PageSize ROWS ONLY";
        SqlCommand cmd = new SqlCommand(query, conn);
        cmd.Parameters.AddWithValue("@Offset", (pageIndex - 1) * pageSize);
        cmd.Parameters.AddWithValue("@PageSize", pageSize);

        DataTable dt = new DataTable();
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        da.Fill(dt);

        dataGridView.DataSource = dt;
    }
}

// 示例代码：启用虚拟模式
dataGridView.VirtualMode = true;

dataGridView.RowHeight = 20; // 设置行高

dataGridView.CellValueNeeded += new DataGridViewCellValueEventHandler(dataGridView_CellValueNeeded);

private void dataGridView_CellValueNeeded(object sender, DataGridViewCellValueEventArgs e)
{
    if (e.RowIndex < data.Count)
    {
        e.Value = data[e.RowIndex][e.ColumnIndex];
    }
}

-- 示例SQL：使用索引优化查询
CREATE INDEX idx_YourTable_ID ON YourTable(ID);

// 示例代码：禁用自动刷新
dataGridView.AllowUserToAddRows = false;
dataGridView.AllowUserToDeleteRows = false;
dataGridView.ReadOnly = true;