winform ListView和DataGridView实现分页
2021-02-15 00:19
标签:text tool pac rms 页面 dap gpo client orm 用到的控件有 code: listviewPaging datagridviewpaging winform ListView和DataGridView实现分页 标签:text tool pac rms 页面 dap gpo client orm 原文地址:https://www.cnblogs.com/zhaooyw/p/8443676.htmlusing 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();
}
}
}
}
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实现分页
文章链接:http://soscw.com/essay/55417.html