成品效果:
下面是效果实现的所有代码:
备注:
控件名称解释:
首页(按钮)-->btnHomePage
上一页(按钮)-->btnUpPage
1(按钮)-->btnShowYe1
2(按钮)-->btnShowYe2
3(按钮)-->btnShowYe3
下一页(按钮)-->btnNextPage
尾页(按钮)-->btnEnd
43(lable)-->lblSumPage
文本框-->txtPage
确定(按钮)-->btnQueding
#region 分页 int pageSize = 2;//每页显示的条数 int currentPage = 1;//当前页码 /// <summary> /// 分页 /// </summary> /// <param name="pageNo"></param> private void FenYe(int pageNo) { //把最大页码传给总共的页数lable lblSumPage.Text = getTotalPage().ToString(); ds = new DataSet(); string sql = "select top " + pageSize + " * from Administrator_Log where ID not in ("; sql += "select top (" + (pageNo - 1) + " *" + pageSize + ") ID from Administrator_Log order by ID)order by ID"; adapter = new SqlDataAdapter(sql, DBhelp.conn); if (ds.Tables["Administrator_Log"] != null) { ds.Tables["Administrator_Log"].Clear(); } adapter.Fill(ds, "Administrator_Log");