winform ListView和DataGridView实现分页
2021-02-15 00:19
阅读:584
标签:text tool pac rms 页面 dap gpo client orm
用到的控件有
code:
listviewPaging

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; namespace DataGridViewPage1 { public partial class ListViewPaging : Form { int pageSize = 0; //每页显示行数 int nMax = 0; //总记录数 int pageCount = 0; //页数=总记录数/每页显示行数 int pageCurrent = 0; //当前页号 int nCurrent = 0; //当前记录行 DataSet ds = new DataSet(); DataTable dtInfo = new DataTable(); public ListViewPaging() { InitializeComponent(); BindData(); } void BindData() { string strConn = "SERVER=.;DATABASE=WL_JLB;UID=sa;PWD=123456"; //数据库连接字符串 SqlConnection conn = new SqlConnection(strConn); conn.Open(); string strSql = "SELECT * FROM dbo.WlcSys_Model"; SqlDataAdapter sda = new SqlDataAdapter(strSql, conn); sda.Fill(ds, "ds"); conn.Close(); dtInfo = ds.Tables[0]; InitDataSet(); } private void InitDataSet() { pageSize = 20; //设置页面行数 nMax = dtInfo.Rows.Count; pageCount = (nMax / pageSize); //计算出总页数 if ((nMax % pageSize) > 0) pageCount++; pageCurrent = 1; //当前页数从1开始 nCurrent = 0; //当前记录数从0开始 LoadData(); } private void LoadData() { int nStartPos = 0; //当前页面开始记录行 int nEndPos = 0; //当前页面结束记录行 DataTable dtTemp = dtInfo.Clone(); //克隆DataTable结构框架 if (pageCurrent == pageCount) nEndPos = nMax; else nEndPos = pageSize * pageCurrent; nStartPos = nCurrent; //lblPageCount2.Text = pageCount.ToString(); txtCurrentPage.Text = Convert.ToString(pageCurrent); lblPageCount.Text = pageCount.ToString(); this.listView1.Items.Clear(); //从元数据源复制记录行 for (int i = nStartPos; i pageCount) { MessageBox.Show("已经是最后一页,请点击“上一页”查看!"); pageCurrent--; return; } else { nCurrent = pageSize * (pageCurrent - 1); } LoadData(); } if (e.ClickedItem.Text == "go") { int a = 0; int.TryParse(txtCurrentPage.Text, out a); if (a == 0) { MessageBox.Show("只能输入正整数!"); return; } //pageCurrent = int.Parse(txtCurrentPage.Text); pageCurrent = a; if (pageCurrent pageCount) { MessageBox.Show("已经是最后一页,请点击“上一页”查看!"); return; } nCurrent = pageSize * (pageCurrent - 1); LoadData(); } } } }

datagridviewpaging

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; namespace DataGridViewPage1 { public partial class Form1 : Form { int pageSize = 0; //每页显示行数 int nMax = 0; //总记录数 int pageCount = 0; //页数=总记录数/每页显示行数 int pageCurrent = 0; //当前页号 int nCurrent = 0; //当前记录行 DataSet ds = new DataSet(); DataTable dtInfo = new DataTable(); public Form1() { InitializeComponent(); BindData(); } void BindData() { string strConn = "SERVER=.;DATABASE=WL_JLB;UID=sa;PWD=123456"; //数据库连接字符串 SqlConnection conn = new SqlConnection(strConn); conn.Open(); string strSql = "SELECT * FROM dbo.WlcSys_Model"; SqlDataAdapter sda = new SqlDataAdapter(strSql, conn); sda.Fill(ds, "ds"); conn.Close(); dtInfo = ds.Tables[0]; InitDataSet(); } private void InitDataSet() { pageSize = 20; //设置页面行数 nMax = dtInfo.Rows.Count; pageCount = (nMax / pageSize); //计算出总页数 if ((nMax % pageSize) > 0) pageCount++; pageCurrent = 1; //当前页数从1开始 nCurrent = 0; //当前记录数从0开始 LoadData(); } private void LoadData() { int nStartPos = 0; //当前页面开始记录行 int nEndPos = 0; //当前页面结束记录行 DataTable dtTemp = dtInfo.Clone(); //克隆DataTable结构框架 if (pageCurrent == pageCount) nEndPos = nMax; else nEndPos = pageSize * pageCurrent; nStartPos = nCurrent; //lblPageCount2.Text = pageCount.ToString(); txtCurrentPage.Text = Convert.ToString(pageCurrent); lblPageCount.Text = pageCount.ToString(); //从元数据源复制记录行 for (int i = nStartPos; i pageCount) { MessageBox.Show("已经是最后一页,请点击“上一页”查看!"); pageCurrent--; return; } else { nCurrent = pageSize * (pageCurrent - 1); } LoadData(); } if (e.ClickedItem.Text == "go") { int a=0; int.TryParse(txtCurrentPage.Text, out a); if (a == 0) { MessageBox.Show("只能输入正整数!"); return; } //pageCurrent = int.Parse(txtCurrentPage.Text); pageCurrent = a; if (pageCurrent pageCount) { MessageBox.Show("已经是最后一页,请点击“上一页”查看!"); return; } nCurrent = pageSize * (pageCurrent - 1); LoadData(); } } } }

winform ListView和DataGridView实现分页
标签:text tool pac rms 页面 dap gpo client orm
原文地址:https://www.cnblogs.com/zhaooyw/p/8443676.html
文章来自:搜素材网的编程语言模块,转载请注明文章出处。
文章标题:winform ListView和DataGridView实现分页
文章链接:http://soscw.com/index.php/essay/55417.html
文章标题:winform ListView和DataGridView实现分页
文章链接:http://soscw.com/index.php/essay/55417.html
评论
亲,登录后才可以留言!