C#编程-79：DataGridView分页显示__c# datagridview显示行号

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

干练的火锅 · 3D 打印建筑模型指南 | Formlabs· 2 月前 ·

长情的电池 · Ethan | 博客· 3 月前 ·

失眠的芹菜 · canvas2svg/canvasvg.py ...· 5 月前 ·

潇洒的大海 · 琼明神女录TXT小说下载百度云,TXT全集电 ...· 8 月前 ·

火星上的猴子 · 华硕固件默认ip_无线路由器（MTK7621 ...· 9 月前 ·

DataSet dateSet = new DataSet();

private int startVal=0;//起始值

private int perPageVal = 3;//每页显示数量

private int totalVal;//总条数

private int currentPage=0;//当前页

private void Form1_Load(object sender, EventArgs e)

string constr = @"server=(localdb)\Projects;integrated security=sspi;database=company";

SqlConnection sqlcon = new SqlConnection(constr);

sqlcon.Open();

string sql = "select * from clerk";

sqladp = new SqlDataAdapter(sql,sqlcon);

sqladp.Fill(dateSet,"clerk");

//this.dataGridView1.DataSource = dateSet.Tables["clerk"];

sqlcon.Close();

//计算总页数

totalVal = dateSet.Tables["clerk"].Rows.Count;

int totalPage=(totalVal%perPageVal==0)?(totalVal/perPageVal):(totalVal/perPageVal+1);

lblTotalPage.Text = "/" + totalPage;

LoadData();

catch (Exception ex)

MessageBox.Show(ex.Message);

private void LoadData()

//显示当前页面

currentPage = startVal / perPageVal + 1;

txtCurrentPage.Text = currentPage.ToString();

//绑定数据

dateSet.Clear();

sqladp.Fill(dateSet, startVal, perPageVal, "clerk");

bindingSource1.DataSource=dateSet.Tables[0];

bindingNavigator1.BindingSource = bindingSource1;

dataGridView1.DataSource = bindingSource1;

private void bindingNavigator1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)

if (e.ClickedItem.Text == "上一页")

startVal = startVal - perPageVal;

if (startVal < 0)

startVal = 0;

MessageBox.Show("已经是第一页");

return;

if (e.ClickedItem.Text == "下一页")

startVal = startVal + perPageVal;

if (startVal > totalVal)

startVal = startVal - perPageVal;

MessageBox.Show("已经是最后一页");

return;

LoadData();