C# Winform DataGridView 公共分页实现

Demo的界面

 

 

我利用事件委托事件，仿http://www.cnblogs.com/huyong/写的公共分页用户控件

 

#region  版权信息
/*---------------------------------------------------------------------*
// 项目  名称：《Winform分页控件》
// 文  件  名： Pager.cs
// 描      述： 分页控件
// 作      者：kwon yan
*----------------------------------------------------------------------*/
#endregion

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace HuishengFS.Controls
{
    /**/
    /// <summary>
    /// 申明委托
    /// </summary>
    /// <param name="e"></param>
    /// <returns></returns>
    public delegate int EventPagingHandler(EventPagingArg e);
    /**/
    /// <summary>
    /// 分页控件呈现
    /// </summary>
    public partial class Pager : UserControl
    {
        public Pager()
        {
            InitializeComponent();
        }
        public event EventPagingHandler EventPaging;
        /**/
        /// <summary>
        /// 每页显示记录数
        /// </summary>
        private int _pageSize = 50;
        /**/
        /// <summary>
        /// 每页显示记录数
        /// </summary>
        public int PageSize
        {
            get { return _pageSize; }
            set
            {
                _pageSize = value;
                GetPageCount();
            }
        }

        private int _nMax = 0;
        /**/
        /// <summary>
        /// 总记录数
        /// </summary>
        public int NMax
        {
            get { return _nMax; }
            set
            {
                _nMax = value;
                GetPageCount();
            }
        }

        private int _pageCount = 0;
        /**/
        /// <summary>
        /// 页数=总记录数/每页显示记录数
        /// </summary>
        public int PageCount
        {
            get { return _pageCount; }
            set { _pageCount = value; }
        }

        private int _pageCurrent = 0;
        /**/
        /// <summary>
        /// 当前页号
        /// </summary>
        public int PageCurrent
        {
            get { return _pageCurrent; }
            set { _pageCurrent = value; }
        }

        /// <summary>
        /// 设置页面大小
        /// </summary>
        private void GetPageCount()
        {
            if (this.NMax > 0)
            {
                this.PageCount = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(this.NMax) / Convert.ToDouble(this.PageSize)));
                lblPageCount.Text = " / " + PageCount.ToString();
                //lblPageCount1.Text = "每页 "+PageSize .ToString ()+" 条，共 "+PageCount.ToString()+" 页";
                lblPageCount1.Text = "Page no: " + PageSize.ToString() + ",Total:" + PageCount.ToString() + " pages";
            }
            else
            {
                this.PageCount = 0;
            }
        }

        /**/
        /// <summary>
        /// 翻页控件数据绑定的方法 关键是这步，都是调用这里
        /// </summary>
        public void Bind()
        {
            if (this.EventPaging != null)
            {
                this.NMax = this.EventPaging(new EventPagingArg(this.PageCurrent));
            }

            if (this.PageCurrent > this.PageCount)
            {
                this.PageCurrent = this.PageCount;
            }
            if (this.PageCount == 1)
            {
                this.PageCurrent = 1;
            }
            lblcurentpage.Text = PageCurrent.ToString();
            //lblRecordCount.Text = "共有 " + NMax.ToString() + " 条记录";
            lblRecordCount.Text = "Total: " + NMax.ToString() + " records";
          

            btnPrev.Enabled = true;
            btnFirst.Enabled = true;
            btnLast.Enabled = true;
            btnNext.Enabled = true;

            if (this.PageCurrent == 1)
            {
                this.btnPrev.Enabled = false;
                this.btnFirst.Enabled = false;
            }
      

            if (this.PageCurrent == this.PageCount)
            {
                this.btnLast.Enabled = false;
                this.btnNext.Enabled = false;
            }
     
            if (this.NMax == 0)
            {
                btnNext.Enabled = false;
                btnLast.Enabled = false;
                btnFirst.Enabled = false;
                btnPrev.Enabled = false;
            }
            cmbPagecount.Items.Clear();
            for (int i = 1; i <= PageCount; i++)
                cmbPagecount.Items.Add(i.ToString());
            cmbPagecount.SelectedIndex = PageCurrent - 1;
            
        }
        /// <summary>
        /// 首页
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnFirst_Click(object sender, EventArgs e)
        {
            PageCurrent = 1;
            this.Bind();
        }
        //上一页
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnPrev_Click(object sender, EventArgs e)
        {
            PageCurrent -= 1;
            if (PageCurrent <= 0)
            {
                PageCurrent = 1;
            }
            this.Bind();
        }
        /// <summary>
        /// 下一页
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnNext_Click(object sender, EventArgs e)
        {
            this.PageCurrent += 1;
            if (PageCurrent > PageCount)
            {
                PageCurrent = PageCount;
            }
            this.Bind();
        }
        /// <summary>
        /// 最后页
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnLast_Click(object sender, EventArgs e)
        {
            PageCurrent = PageCount;
            this.Bind();
        }
        /// <summary>
        /// 转到新页
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        public void btnGo_Click(object sender, EventArgs e)
        {
            if (Int32.TryParse(cmbPagecount.SelectedItem.ToString(), out _pageCurrent))
            {
                this.Bind();
            } 
        }
    }
    /**/
    /// <summary>
    /// 自定义事件数据基类
    /// </summary>
    public class EventPagingArg : EventArgs
    {
        private int _intPageIndex;
        public EventPagingArg(int PageIndex)
        {
            _intPageIndex = PageIndex;
        }
    }
}

 

前提准备

编写分页的SQL 语句和获取总数的SQL语句

 

 

--分页存储过程 也可以SQL语句
--获取总数的语句 我也不必多写了
if exists(select * from sysobjects where name='Proc_DgvPage')
drop proc name='Proc_DgvPage')
go
create proc name='Proc_DgvPage')
(
 @keyword  varchar(100),	--关键字
 @start varchar(5),
 @end varchar(5)
)
as
begin

select sortTb.clientCode, sortTb.fileReference,sortTb.clientName1, sortTb.clientName2,
	sortTb.dateOpen, sortTb.dateClose,sortTb.fileMaster,
	sortTb.clientTel, sortTb.clientMobile, sortTb.clientFex,sortTb.companyName,sortTb.clientAddr, sortTb.propFlat, sortTb.propFloor,
	sortTb.propBlock, sortTb.propBuilding, sortTb.propStree, sortTb.propDistrict, sortTb.propArea, sortTb.isFileClosed 
	from (
		 select  row_number() over(order by c.clientCode) as sortNo,
		 c.clientCode, f.fileSubpervisor+''/''+f.fileCode+''/''+f.fileYear+''/''+f.fileIntro+''/''+f.fileHandler as fileReference,
         c.clientLastName1+'' ''+c.clientFirstName1 as clientName1, c.clientLastName2+'' ''+c.clientFirstName2 as clientName2,f.dateOpen, f.dateClose,f.fileMaster,
         c.clientTel, c.clientMobile, c.clientFex,c.companyName,c.clientAddr, f.propFlat, f.propFloor,
         f.propBlock, f.propBuilding, f.propStree, f.propDistrict, f.propArea, f.isFileClosed 
         from  clientInfo c left join  clientFiles f on c.clientCode = f.fileCode 
         where 1=1
) 
         as sortTb 
         where sortNo between @start and @end

end
go

 

 

在窗体调用：

 

//定义变量
        DataTable dtPage;

        /// <summary>
        /// GridViw数据绑定
        /// </summary>
        /// <returns></returns>
        private int BindDgv()
        {
	    //传入要取的第一条和最后一条
            string start = (pager1.PageSize * (pager1.PageCurrent - 1) + 1).ToString();
            string end = (pager1.PageSize * pager1.PageCurrent).ToString();

            //数据源
            dtPage = achieve.GetAll(Keyword, start, end);
            //绑定分页控件
            pager1.bindingSource1.DataSource = dtPage;
            pager1.bindingNavigator1.BindingSource = pager1.bindingSource1;
            //讲分页控件绑定DataGridView
	    dgvClients.DataSource = pager1.bindingSource1;
 	    //返回总记录数
            return achieve.GetToalCount(Keyword);
        }
	/// <summary>
        /// 分页控件产生的事件
        /// </summary>
        private int pager1_EventPaging(HuishengFS.Controls.EventPagingArg e)
        {
            return DgvBind();
        }

	/// <summary>
        /// 加载分页 或许写在Load事件里面
        /// </summary>
        private void FrmPage_Shown(object sender, EventArgs e)
        {
            #region DataGridView与Pager控件绑定
            this.pager1.PageCurrent = 1;//当前页为第一页
            pager1.PageSize = 100;//页数
            this.pager1.Bind();//绑定
            #endregion
        }

评论

6 楼 ctz_131415 2015-08-19  

谁能告诉我这个分页控件如何添加到窗口上？谢谢了

5 楼 omymy 2014-08-18  

FrmPage_Shown是放在页面加载时的load事件里的，在页面编辑器里设置属性PageCurrent 和PageSize也是可以的，但pager1.Bind();一定要加上

4 楼 qie 2013-12-23  

如何使用该分页控件？

3 楼 yanyanquan 2012-02-09  

luitao 写道

能否说如何添加到其它窗体上使用啊？

你保存那个文件后，你直接拖过去就行了。

2 楼 luitao 2012-02-06  

能否说如何添加到其它窗体上使用啊？

1 楼 feiniao0822 2011-10-20  

很好的文章。谢谢分享。
补充一下。FrmPage_Shown事件中（一般用load事件）需要绑定事件
代码如下：
pager1.EventPaging += new HuishengFS.Controls.EventPagingHandler(pager1_EventPaging);