datagridview分页实现

在系统设计应用中，有时候我们需要分页显示数据，这样可以提高用户的体验，还可以提升加载速度。网上已经有很多关于DataGridView分页功能函数的相关代码，我当时也尝试使用他们提供的方案，但是真正运用到项目中，代码无法跑起来，也存在一些错误。今天，我将分享如何实现DataGridView分页功能。控件效果图如下：

首先我们需要获取当前页，默认当前页的索引为1，即我们定义一个私有变量 private int _PageIndex=1;点击_PageInde按下Ctrl+R、Ctrl+E就可以将当前字段封装起来，然后我们连续创建几个字段分别为PageSize(页面记录数)、StartIndex(当前页面开始行)、EndIndex(当前页面结束行)、RecordCount(总记录数)、PageCount(总页面数)等等，具体定义可在完整代码当中查看。我们将所有的属性字段写好之后，我们往控件上添加分页常用的几个上一页、下一页、首页、尾页已经制定页数跳转。

控件做完之后，看看怎么使用该控件，我们将控件拖放在需要分页的模块，在datagridview大小改变事件中，设置分页大小=（当前datagridview的高度-表头高度-滚动条高度）/（表格行模板高度）。

        #region 大小改变事件
        private void skinDataGridView_SizeChanged(object sender, EventArgs e)
        {
            pagingControl1.PageSize = ((skinDataGridView.Height - skinDataGridView.ColumnHeadersHeight - 17) / skinDataGridView.RowTemplate.Height);            
        }
        #endregion

设置完分页大小，接着赋值总数目，总数目赋值后，控件内的相关方法会进行计算当前可以分几页，最后就是向数据库索取值，我们可以定义如下的方法获取数据。

DataTable GetDataTable（int pageIndex，int pageSize，string strWhere,out int totalCount）

     紧接着我们说说如何在SQL写分页数据，直接上代码

    #region 数据分页查询语句
        public DataTable GetDataTable(int pageIndex, int pageSize, string strWhere,out int totalCount)
        {
            StringBuilder sql = new StringBuilder();
            sql.AppendFormat(@"SELECT TOP {0} * FROM (", pageSize);
            sql.Append("SELECT ROW_NUMBER() OVER (ORDER BY ID DESC) AS RowNumber,");         
            sql.Append("写你要查询的SQL语言 ");          
            sql.Append(") AS A");
            sql.AppendFormat(" WHERE RowNumber >{0}*({1}-1)", pageSize, pageIndex);
            //执行您要操作的SQL语法
           //totalCount这边的值是你不限制查询第几条 统计所有的数量 例如：SELECT COUNT(ID) FROM Table
         }      
      #endregion

至此，我们就实现好分页功能了，附上控件设计的CS完整代码。

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 SCommon.UserControls
{
    // 分页控件
    public partial class PagingControl : UserControl
    {
        public PagingControl()
        {
            InitializeComponent();
        }

        // 当前页
        private int pageIndex = 1;
        // 页面记录数
        private int pageSize = 10;
        // 当前页面开始行
        private int startIndex;
        // 当前页面结束行
        private int endIndex;
        // 总记录数
        private int recordCount = 0;
        // 总页面数
        private int pageCount = 1;
        // 跳转页面
        private string jumpIndex = string.Empty;

        /// <summary>
        /// 当前页
        /// </summary>
        public int PageIndex
        {
            get { return this.pageIndex; }
            set { this.pageIndex = value; }
        }
        /// <summary>
        /// 页面记录数
        /// </summary>
        public int PageSize
        {
            get { return this.pageSize; }
            set { this.pageSize = value; }
        }

        /// <summary>
        /// 当前页面开始行
        /// </summary>
        public int StartIndex
        {
            get
            {
                startIndex = (PageIndex - 1 <= 0 ? 0 : PageIndex - 1) * (PageSize <= 0 ? 1 : PageSize) + 1;
                return startIndex;
            }
        }
        /// <summary>
        /// 当前页面结束行
        /// </summary>
        public int EndIndex
        {
            get
            {
                endIndex = PageIndex * (PageSize <= 0 ? 0 : PageSize);
                return endIndex;
            }
        }
        /// <summary>
        /// 总记录数
        /// </summary>
        public int RecordCount
        {
            get { return this.recordCount; }
            set
            {
                this.recordCount = value;
                GetPageCount();
                DrawControl(false);
            }
        }
        /// <summary>
        /// 总页面数
        /// </summary>
        public int PageCount
        {
            get
            {
                this.pageCount = GetPageCount();
                return this.pageCount;
            }
            //set { this.pageCount = value; }
        }

        /// <summary>
        /// 跳转页面
        /// </summary>
        public string JumpIndex
        {
            get { return this.jumpIndex; }
            set { this.jumpIndex = value; }
        }

        /// <summary>
        /// 计算总页面数
        /// </summary>
        /// <returns></returns>
        private int GetPageCount()
        {
            if (PageSize <= 0)
            {
                return 1;
            }
            int page_Count = RecordCount / PageSize;
            if (RecordCount % PageSize != 0)
            {
                page_Count++;
            }
            return page_Count;
        }

        /// <summary>
        /// 页数改变事件
        /// </summary>
        public event EventHandler OnPageChanged;

        /// <summary>
        /// 重绘控件
        /// </summary>
        private void DrawControl(bool callEvent)
        {
            labRecordCount.Text = RecordCount + "行";
            labPageIndex.Text = PageIndex.ToString();
            labPageCount.Text = PageCount.ToString();
            txtPageIndex.Text = JumpIndex;

            if (PageCount == 1)
            {
                btnFirst.Enabled = false;
                btnPrev.Enabled = false;
                btnNext.Enabled = false;
                btnLast.Enabled = false;
            }
            if (PageIndex == 1)
            {
                btnFirst.Enabled = false;
                btnPrev.Enabled = false;
                btnNext.Enabled = true;
                btnLast.Enabled = true;
            }
            else if (PageIndex == PageCount)
            {
                btnFirst.Enabled = true;
                btnPrev.Enabled = true;
                btnNext.Enabled = false;
                btnLast.Enabled = false;
            }
            else
            {
                btnFirst.Enabled = true;
                btnPrev.Enabled = true;
                btnNext.Enabled = true;
                btnLast.Enabled = true;
            }
            if (callEvent && OnPageChanged != null)
            {
                OnPageChanged(this, null);//当前分页数字改变时，触发委托事件
            }
        }

        /// <summary>
        /// 首页
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnFirst_Click(object sender, EventArgs e)
        {
            PageIndex = 1;
            DrawControl(true);
        }
        /// <summary>
        /// 上一页
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnPrev_Click(object sender, EventArgs e)
        {
            PageIndex = Math.Max(1, PageIndex - 1);
            DrawControl(true);
        }
        /// <summary>
        /// 下一页
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnNext_Click(object sender, EventArgs e)
        {
            PageIndex = Math.Min(PageIndex + 1, PageCount);
            DrawControl(true);
        }
        /// <summary>
        /// 尾页
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnLast_Click(object sender, EventArgs e)
        {
            PageIndex = PageCount;
            DrawControl(true);
        }

        private void txtPageIndex_TextChanged(object sender, EventArgs e)
        {
            if (txtPageIndex.Text.Trim() != string.Empty && txtPageIndex.Text.Trim() != JumpIndex)
            {
                int index = 0;
                if (!int.TryParse(txtPageIndex.Text.Trim(), out index))
                {
                    txtPageIndex.Text = JumpIndex;
                    return;
                }
            }
            JumpIndex = txtPageIndex.Text.Trim();
        }

        private void txtPageIndex_Leave(object sender, EventArgs e)
        {
            if (txtPageIndex.Text.Trim() != string.Empty && txtPageIndex.Text.Trim() != JumpIndex)
            {
                int index = 0;
                if (!int.TryParse(txtPageIndex.Text.Trim(), out index))
                {
                    txtPageIndex.Text = JumpIndex;
                    return;
                }
            }
            JumpIndex = txtPageIndex.Text.Trim();
        }
        /// <summary>
        /// 跳转
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnJump_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrWhiteSpace(txtPageIndex.Text.Trim()))
            {
                txtPageIndex.Text = "";
                return;
            }
            int index = 0;
            if (!int.TryParse(txtPageIndex.Text.Trim(), out index))
            {
                txtPageIndex.Text = "";
                return;
            }
            if (index <= 0 || index > PageCount)
            {
                txtPageIndex.Text = "";
                return;
            }
            PageIndex = index;
            DrawControl(true);
            txtPageIndex.Text = "";
        }

        private void txtPageIndex_KeyPress(object sender, KeyPressEventArgs e)
        {
            if ((e.KeyChar >= '0' && e.KeyChar <= '9') || e.KeyChar == '\b')
            {
                e.Handled = false;
            }
            else
            {
                e.Handled = true;
            }
        }
    }
}