DataGirdView存储过程分页 For Winfrom

最新推荐文章于 2022-09-21 17:46:49 发布
最新推荐文章于 2022-09-21 17:46:49 发布
阅读量1.2k 收藏
点赞数
文章标签： 存储 exception dataset string parameters null
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/ann0915/article/details/2633840
版权

在Winfrom中，网格控件DataGridView并不像DataGrid自带分页功能，正好工作需要，写了下分页，只是满足项目要求。

存储过程：

CREATE  PROC pro_userDefined_DataGridPage

@TotalRecords   INT OUTPUT,   --记录总数

@TotalTableName VARCHAR(100), --查询记录总数的表名

@TotalJoinStr VARCHAR (1000), --查询记录总数连接语句

@TotalRecordsCondition VARCHAR(500),--查询记录总数的条件语句

@CurrentPage  INT = 1,        --当前页数

@PageSize     INT = 10,          --每页显示的行数

@TableName    VARCHAR (100),--表名,视图，存储过程

@FieldNames   VARCHAR (1000),--需要显示的字段名

@JoinStr      VARCHAR (1000),--连接语句（左连接，右连接，内连接，交叉连接）

@PrimaryField VARCHAR (100), --主键字段

@ConditionString VARCHAR (1000),--条件语句

@FilterString VARCHAR (1000),--过滤条件语句

@OrderField   VARCHAR (100) --根据字段排序

AS
DECLARE

@queryStr NVARCHAR(3000), --SQL查询语句

@FilterRecordCount INT   --过滤的记录数

IF @ConditionString = '' 
	SET  @ConditionString =' 1=1 '
IF @FilterString = ''
	SET @FilterString = ' 1=1 '
IF @TotalJoinStr = ''
	SET @TotalJoinStr = ''



BEGIN
	SET @queryStr = 'SELECT @TotalRecords = COUNT(' + @PrimaryField + '	)FROM ' + @TotalTableName + ' ' + @TotalJoinStr + ' WHERE ' +  @TotalRecordsCondition

	EXEC sp_executesql @queryStr,N'@TotalRecords int output',@TotalRecords output

	PRINT @TotalRecords
END

IF @CurrentPage = 1 --第一页
	BEGIN
		SET @queryStr = ' SELECT TOP ' + CAST(@PageSize AS VARCHAR(10)) + ' ' + @fieldNames + ' FROM ' + @TableName + ' ' + @JoinStr + 
		' WHERE ' +  @ConditionString + ' ORDER BY ' + @OrderField
		EXEC (@queryStr)
	END
ELSE
	BEGIN
		SET @CurrentPage = @CurrentPage - 1

		SET @FilterRecordCount = CAST(@CurrentPage * @PageSize AS VARCHAR(10))

		SET @queryStr =' SELECT TOP ' + CAST(@PageSize AS VARCHAR(10)) + ' ' + @fieldNames + ' FROM ' + @TableName + ' ' + @JoinStr + ' WHERE ' + @PrimaryField + 

			       ' NOT IN ( SELECT TOP ' + CAST(@FilterRecordCount AS VARCHAR(10)) + ' ' + @PrimaryField + ' FROM ' + @TableName + ' WHERE ' + @FilterString + ' ORDER BY ' + @PrimaryField + ') AND ' +  @ConditionString +

			       ' ORDER BY ' + @PrimaryField

		EXEC (@queryStr)	


	END
GO


 

用户控件：

导航菜单，我就用了ToolStrip控件进行创建各个按钮

代码实现：

声明变量，属性

 #region 变量

         private int _PageSum = 0; 

        private int _TotalRecords = 0;

        private int _CurrentPage = 1;

        private int _PageSize = 10;

        private string _TableName = null;

        private string _TotalTableName = null;

        private string _TotalJoinStr = null;

        private string _TotalRecordsCondition = null;

        private string _FieldNames = null;

        private string _JoinStr = null;

        private string _PrimaryField = null;

        private string _ConditionString = null;

        private string _FilterString = null;

        private string _OrderField = null;

        private DataTable _GridSource;

        private SqlParameter[] _SqlParameter;

        private SqlCommand     _SqlCommand;

        private SqlDataAdapter _SqlDataAdatpter;

        private DataSet   _girdDataSet;

        private DataTable _gridTable;

        private BindingSource _bingingSource = new BindingSource();

        private string _currentpageStr = "{0}";

        private string _pagesumStr = "共{0}条记录";

        #endregion



        #region 属性
          /// <summary>
         /// 设置当前页数
          /// </summary>
	public int SetCurrentPage
        {
            set { _CurrentPage = value; }
        }

        /// <summary>
        /// 设置每页显示的行数
         /// </summary>
        public int SetPageSize
        {
            set { _PageSize = value; }
        }

        /// <summary>
        /// 设置表名,视图,存储过程
         /// </summary>
        public string SetTableName
        {
            set { _TableName = value;}
        }
        /// <summary>
        /// 设置查询记录总数的表名
        /// </summary>
        public string SetTotalTableName
        {
            set { _TotalTableName = value; }
        }

        /// <summary>
        /// 设置查询总记录数连接语句(左连接,右连接,内连接,交叉连接)
        /// </summary>
        public string SetTotalJoinStr
        {
            set { _TotalJoinStr = value; }
        }

        /// <summary>
        /// 设置查询记录总数的条件语句
         /// </summary>
        public string SetTotalRecordsCondition   
        {
            set { _TotalRecordsCondition = value; }
        }

        /// <summary>
        /// 设置需要DataGirdView显示的字段,以逗号分开
         /// </summary>
        public string SetFieldNames
        {
            set { _FieldNames = value; }
        }

        /// <summary>
        /// 连接语句(左连接,右连接,内连接,交叉连接)
        /// </summary>
        public string SetJoinStr
        {
            set { _JoinStr = value; }
        }

        /// <summary>
        /// 设置主键字段
        /// </summary>
        public string SetPrimaryField
        {
            set { _PrimaryField = value; }
        }

        /// <summary>
        /// 设置查询条件语句


        /// </summary>
        public string SetConditionString
        {
            set { _ConditionString = value; }
        }

        /// <summary>
        /// 设置过滤查询条件语句
        /// </summary>
        public string SetFilterString
        {
            set { _FilterString = value; }
        }

        /// <summary>
        /// 设置排序字段
         /// </summary>
        public string SetOrderField
        {
            set { _OrderField = value; }
        }

        /// <summary>
        /// 获得DataGridView数据源
         /// </summary>
        public DataTable GetGridSource
        {
            get { return _gridTable; }
        }

        public BindingSource GetBingingSource
        {
            get { return _bingingSource; }
        }


 
toolStrip点击事件ItemClick

        #endregion


        /// <summary>
        /// 导航条点击事件
         /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void strNavigationBar_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
        {
            int m_currentPage = Convert.ToInt32(txtCurrentPage.Text);

            int m_pageNumber = 1;//转到页数

              int m_pageSize = 10;//设置显示行数

              bool m_isValid = false;//输入的行数和页数是否合法

              if (dataGridView.DataSource == null)
            {
                return;
            }

            try
            {
                if (e.ClickedItem.Text == "上一页")
                {
                    m_currentPage--;

                    if (m_currentPage <= 0)
                    {

                        MessageBox.Show("已经是第一页，请点击‘下一页’查看！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        return;
                    }
                    else
                    {
                        SetCurrentPage = m_currentPage;

                        PreviousPage(_CurrentPage);

                        txtCurrentPage.Text = m_currentPage.ToString();
                    }
                }

                if (e.ClickedItem.Text == "下一页")
                {
                    m_currentPage++;

                    if (m_currentPage > _PageSum)
                    {
                        MessageBox.Show("已经是最后页，请点击‘上一页’查看！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        return;
                    }
                    else
                    {
                        SetCurrentPage = m_currentPage;

                        NextPage(_CurrentPage);

                        txtCurrentPage.Text = m_currentPage.ToString();
                    }
                }

                if (e.ClickedItem.Text == "首页")
                {
                    SetCurrentPage = 1;

                    FirstPage(_CurrentPage);

                    txtCurrentPage.Text = "1";
                }

                if (e.ClickedItem.Text == "尾页")
                {
                    SetCurrentPage = _PageSum;

                    FirstPage(_CurrentPage);

                    txtCurrentPage.Text = _PageSum.ToString();
                }

                if (e.ClickedItem.Text == "Go")
                {
                    m_isValid = isValidContent(txtGotoPageNumber.Text.Trim());

                    if (!m_isValid)
                    {
                        MessageBox.Show("输入有效的页码！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);

                        txtGotoPageNumber.Focus();

                        return;
                    }

                    if (_TotalRecords > 0)
                    {
                        m_pageNumber = Convert.ToInt32(txtGotoPageNumber.Text.Trim());

                        if (m_pageNumber < 0 || m_pageNumber > _PageSum)
                        {
                            MessageBox.Show("输入有效的页码！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);

                            txtGotoPageNumber.Focus();

                            return;
                        }

                        GotoPageNumber(m_pageNumber);

                        txtCurrentPage.Text = m_pageNumber.ToString();
                    }
                }
                if (e.ClickedItem.Text == "确定")
                {

                    m_isValid = isValidContent(txtPageSize.Text.Trim());

                    if (!m_isValid)
                    {
                        MessageBox.Show("输入有效的行数！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);

                        txtPageSize.Focus();

                        return;
                    }

                    m_pageSize = Convert.ToInt32(txtPageSize.Text.Trim());

                    if (m_pageNumber < 0)
                    {
                        MessageBox.Show("输入有效的行数！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);

                        txtPageSize.Focus();

                        return;
                    }
                    SetPageSize = m_pageSize;

                    InitDataGrid();
                }

                if (e.ClickedItem.Name == "btnHideNavigation")
                {
                    btnShowHideNavigation.Visible = true;

                    strNavigationBar.Visible = false;
                }
            }
            catch (Exception CommonException)
            {
                MessageBox.Show("窗口加载出错！" + CommonException.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);


            }
        } 


 


按钮事件


 


        /// <summary>
        /// 首页
         /// </summary>
       /// <param name="CurrentPage"></param>
        private void FirstPage(int CurrentPage)
        {
            try
            {
                SetCurrentPage = CurrentPage;
                InitDataGrid();
            }
            catch (Exception CommonException)
            {
                throw new Exception(CommonException.Message);
            }
        }

        /// <summary>
        /// 尾页
         /// </summary>
        /// <param name="CurrentPage"></param>
        private void LastPage(int CurrentPage)
        {
            try
            {
                SetCurrentPage = CurrentPage;
                InitDataGrid();
            }
            catch (Exception CommonException)
            {
                throw new Exception(CommonException.Message);
            }
        }

        /// <summary>
        /// 下一页
         /// </summary>
        /// <param name="CurrentPage"></param>
        private void NextPage(int CurrentPage)
        {
            try


            {
                SetCurrentPage = CurrentPage;
                InitDataGrid();
            }
            catch (Exception CommonException)
            {
               throw new Exception(CommonException.Message);
            }
        }

        /// <summary>
        /// 上一页
         /// </summary>
        /// <param name="CurrentPage"></param>
        private void PreviousPage(int CurrentPage)
        {
            try
            {
                SetCurrentPage = CurrentPage;
                InitDataGrid();
            }
            catch (Exception CommonException)
            {
                throw new Exception(CommonException.Message);
            }
        }

        /// <summary>
        /// 转页
         /// </summary>
        /// <param name="pageNumber"></param>
        private void GotoPageNumber(int pageNumber)
        {
            try
            {
                SetCurrentPage = pageNumber;
                InitDataGrid();
            }
            catch (Exception CommonException)
            {
                throw new Exception(CommonException.Message);
            }
        } 


 


对输入的页数等信息进行验证


 


        /// <summary>    
        /// 验证是否是有效的内容  
        /// </summary>
        /// <param name="content"></param>
        /// <returns></returns>
        private bool isValidContent(string content)
        {
            bool m_isValid = true;

            for (int index = 0; index < content.Trim().Length; index++)
            {
                if (!Char.IsNumber(content.Trim(), index))
                {
                    m_isValid = false;
                }
            }
            return m_isValid;
        }


 


初始化DataGridView方法


 


        /// <summary>
        /// 初始化DataGirdView
        /// </summary>
        public void InitDataGrid()
        {
            _SqlDataAdatpter = new SqlDataAdapter();

            _SqlCommand = new SqlCommand();

            _girdDataSet = new DataSet();

            _SqlParameter = new SqlParameter[13];

            try
            {
                _SqlParameter[0] = new SqlParameter();

                _SqlParameter[0].ParameterName = "@TotalRecords";

                _SqlParameter[0].Size = 4;

                _SqlParameter[0].Direction = ParameterDirection.Output;

                _SqlParameter[1] = new SqlParameter();

                _SqlParameter[1].ParameterName = "@CurrentPage";

                _SqlParameter[1].Size = 4;

                _SqlParameter[1].Value = _CurrentPage;

                _SqlParameter[1].Direction = ParameterDirection.Input;

                _SqlParameter[2] = new SqlParameter();

                _SqlParameter[2].ParameterName = "@PageSize";

                _SqlParameter[2].Size = 4;

                _SqlParameter[2].Value = _PageSize;

                _SqlParameter[2].Direction = ParameterDirection.Input;

                _SqlParameter[3] = new SqlParameter();

                _SqlParameter[3].ParameterName = "@TableName";

                _SqlParameter[3].Size = 100;

                _SqlParameter[3].Value = _TableName;

                _SqlParameter[3].Direction = ParameterDirection.Input;

                _SqlParameter[4] = new SqlParameter();

                _SqlParameter[4].ParameterName = "@TotalTableName";

                _SqlParameter[4].Size = 100;

                _SqlParameter[4].Value = _TotalTableName;

                _SqlParameter[4].Direction = ParameterDirection.Input;

                _SqlParameter[5] = new SqlParameter();

                _SqlParameter[5].ParameterName = "@TotalJoinStr";

                _SqlParameter[5].Size = 1000;

                _SqlParameter[5].Value =_TotalJoinStr;

                _SqlParameter[5].Direction = ParameterDirection.Input;

                _SqlParameter[6] = new SqlParameter();

                _SqlParameter[6].ParameterName = "@TotalRecordsCondition";

                _SqlParameter[6].Size = 500;

                _SqlParameter[6].Value = _TotalRecordsCondition;

                _SqlParameter[6].Direction = ParameterDirection.Input;

                _SqlParameter[7] = new SqlParameter();

                _SqlParameter[7].ParameterName = "@FieldNames";

                _SqlParameter[7].Size = 1000;

                _SqlParameter[7].Value = _FieldNames;

                _SqlParameter[7].Direction = ParameterDirection.Input;

                _SqlParameter[8] = new SqlParameter();

                _SqlParameter[8].ParameterName = "@JoinStr";

                _SqlParameter[8].Size = 1000;

                _SqlParameter[8].Value = _JoinStr;

                _SqlParameter[8].Direction = ParameterDirection.Input;

                _SqlParameter[9] = new SqlParameter();

                _SqlParameter[9].ParameterName = "@PrimaryField";

                _SqlParameter[9].Size = 100;

                _SqlParameter[9].Value = _PrimaryField;

                _SqlParameter[9].Direction = ParameterDirection.Input;

                _SqlParameter[10] = new SqlParameter();

                _SqlParameter[10].ParameterName = "@ConditionString";

                _SqlParameter[10].Size = 1000;

                _SqlParameter[10].Value = _ConditionString;

                _SqlParameter[10].Direction = ParameterDirection.Input;

                _SqlParameter[11] = new SqlParameter();

                _SqlParameter[11].ParameterName = "@FilterString";

                _SqlParameter[11].Size = 1000;

                _SqlParameter[11].Value = _FilterString;

                _SqlParameter[11].Direction = ParameterDirection.Input;

                _SqlParameter[12] = new SqlParameter();

                _SqlParameter[12].ParameterName = "@OrderField";

                _SqlParameter[12].Size = 100;

                _SqlParameter[12].Value = _OrderField;

                _SqlParameter[12].Direction = ParameterDirection.Input;

                _girdDataSet = DBOperation.RunProcedure("pro_userDefined_DataGridPage", _SqlParameter, "gridtable");

                _gridTable = _girdDataSet.Tables["gridtable"];

                _bingingSource.DataSource = _gridTable;

                dataGridView.AutoGenerateColumns = false;

                dataGridView.EditMode = DataGridViewEditMode.EditOnEnter;

                dataGridView.DataSource = _bingingSource;

                _GridSource = _gridTable;


                //初始化状态栏
                   _TotalRecords = Convert.ToInt32(_SqlParameter[0].Value);

                lblTotalRecords.Text = string.Format(_pagesumStr, new object[] { _TotalRecords });//记录总数

                   _PageSum = _TotalRecords - _TotalRecords % _PageSize;

                _PageSum /= _PageSize;

                _PageSum++;

                lblPageCount.Text = string.Format(_currentpageStr, new object[] { _PageSum });//页数
              }
            catch (Exception CommonException)
            {
                MessageBox.Show("窗口加载出错！" + CommonException.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);            




            }
        } 


 


执行存储过程方法


 


         /// <summary>
        /// 执行存储过程
         /// </summary>
        /// <param name="storedProcName">存储过程名</param>
        /// <param name="parameters">存储过程参数</param>
        /// <param name="tableName">DataSet结果中的表名</param>
        /// <returns>DataSet</returns>
        public static DataSet RunProcedure(string storedProcName, IDataParameter[] parameters, string tableName)
        {
            using (SqlConnection connection = dbconn.getDBConnection())
            {
                DataSet dataSet = new DataSet();


 


                connection.Open();

                SqlDataAdapter sqlDA = new SqlDataAdapter();

                sqlDA.SelectCommand = BuildQueryCommand(connection, storedProcName, parameters);

                sqlDA.Fill(dataSet, tableName);

                connection.Close();

                return dataSet;
            }
        }






这样用户控件完成了，但如何调用呢？ 


首先需要给参数赋值，其次，需要给DataGridView创建列 


参数赋值 


        /// <summary>
        /// 设置DataGridView参数
         /// </summary>
        private void SetDataGridParameters()
        {
            dataGridViewControl.SetTableName = " sys_User ";

            dataGridViewControl.SetTotalTableName = " sys_User ";

            dataGridViewControl.SetTotalJoinStr = " LEFT JOIN sys_Awards ON sys_User.EmployeeNo = sys_Awards.UserID collate Chinese_PRC_CI_AI_WS ";

            dataGridViewControl.SetTotalRecordsCondition = " sys_User.isVaild = 1 AND sys_Awards.Annual = '" + OverallYear + "'";            

            dataGridViewControl.SetFieldNames = " sys_User.[ID],sys_User.EmployeeNo,sys_User.UserName,sys_Duty.DutyName,sys_Dept.DeptName,sys_Awards.EndofYearAward,sys_Awards.HolidayAward ";

            dataGridViewControl.SetJoinStr = " LEFT JOIN sys_Awards ON  sys_Awards.UserID = sys_User.EmployeeNo collate Chinese_PRC_CI_AI_WS"

                                                         + " LEFT JOIN sys_Duty ON sys_User.Duty = sys_Duty.[ID]"

                                                         + " LEFT JOIN sys_EmployeeDeploy ON sys_User.EmployeeNo = sys_EmployeeDeploy.UserID"

                                                         + " LEFT JOIN sys_Dept ON sys_EmployeeDeploy.CurrentDept = sys_Dept.[ID] ";

            dataGridViewControl.SetPrimaryField = " sys_User.[ID] ";

            dataGridViewControl.SetConditionString = " sys_EmployeeDeploy.IsValid = 1 AND sys_User.isVaild = 1 AND sys_Awards.Annual = '" + OverallYear + "'";

            dataGridViewControl.SetFilterString = "  sys_User.isVaild = 1 ";

            dataGridViewControl.SetOrderField = " sys_User.[ID] ";
        } 


创建DataGridView列 



        /// <summary>
        /// 创建加列
         /// </summary>
        private void CreateGridColumns()
        {
            DataGridViewCell cell = new DataGridViewTextBoxCell();

            DataGridViewColumn[] columns = new DataGridViewColumn[7];

            columns[0] = new DataGridViewColumn();

            columns[0].Name = "ID";

            columns[0].HeaderText = "ID";

            columns[0].DataPropertyName = "ID";

            columns[0].CellTemplate = cell;

            columns[0].ReadOnly = true;

            columns[0].Visible = false;

            columns[1] = new DataGridViewColumn();

            columns[1].Name = "EmployeeNo";

            columns[1].HeaderText = "员工编号";

            columns[1].DataPropertyName = "EmployeeNo";

            columns[1].CellTemplate = cell;

            columns[1].ReadOnly = true;

            columns[1].Visible = true;

            columns[2] = new DataGridViewColumn();

            columns[2].Name = "UserName";

            columns[2].HeaderText = "员工姓名";

            columns[2].DataPropertyName = "UserName";

            columns[2].CellTemplate = cell;

            columns[2].ReadOnly = true;

            columns[2].Visible = true;

            columns[3] = new DataGridViewColumn();

            columns[3].Name = "DutyName";

            columns[3].HeaderText = "职位";

            columns[3].DataPropertyName = "DutyName";

            columns[3].CellTemplate = cell;

            columns[3].ReadOnly = true;

            columns[3].Visible = true;

            columns[4] = new DataGridViewColumn();

            columns[4].Name = "DeptName";

            columns[4].HeaderText = "部门";

            columns[4].DataPropertyName = "DeptName";

            columns[4].CellTemplate = cell;

            columns[4].ReadOnly = true;

            columns[4].Visible = true;

            columns[5] = new DataGridViewColumn();

            columns[5].Name = "EndofYearAward";

            columns[5].HeaderText = "年终奖";

            columns[5].DataPropertyName = "EndofYearAward";

            columns[5].CellTemplate = cell;

            columns[5].DefaultCellStyle.Format = "F";

            columns[5].ReadOnly = false;

            columns[5].Visible = true;

            columns[6] = new DataGridViewColumn();

            columns[6].Name = "HolidayAward";

            columns[6].HeaderText = "假日奖";

            columns[6].DataPropertyName = "HolidayAward";

            columns[6].CellTemplate = cell;

            columns[6].DefaultCellStyle.Format = "F";

            columns[6].ReadOnly = false;

            columns[6].Visible = true;

            foreach (DataGridViewColumn column in columns)
            {
                dataGridViewControl.dataGridView.Columns.Add(column);
            }
        } 


 


当然了，这2个方法都是在页面Load的时候调用的 
写到这结束了，这个DataGridView分页控件，个人觉得只是满足了自己项目的需求，但是我想肯定还有不足的地方，或者编码不规范或者有更好的方法，


希望有经验的朋友能提出来，好让能改进改进，也可以从中学习下！~
ann0915
关注
c# mysql分页_c#-数据库分页查询
weixin_33806859的博客
01-19 1265
前言：这是我在简书的第一篇文章，目前正在学习C#，还属于基础加强阶段，希望可以通过撰写博客加深自己对于所学知识点的理解，并尽量详细的把自己的学习过程与大家分享，希望能够与大家一起分享交流学习心得。当我们从sql数据库中读取的数据量较多，并需要在页面中展示出来时，在一页上全部显示未免有点冗余，所以为了方便用户查看，可以实现分页浏览的功能，具体需求如下。需求分析从数据库读取数据显示在DataGridV...
DataGridView分页
03-18
针对C#中DataGridView控件的分页和全选功能
DataGridView分页功能的实现
weixin_30823833的博客
01-05 333
最近做了一个DataGridView的分页显示Demo。也是看见网络上很多人询问关于DataGridView如何做分页。根据我的认 识，Visual Sutido 2005里的DataGridView控件是没有带分页属性的，因此咱们必须通过写代码去实现分页功能。好了，先看一下Demo的界面。 从界面可以看到，在设计时需要一个DataGridView、BindingNavigate、BindingS...
datagridview 分页查询
游响云停专栏
05-18 6219
使用row_number函数对datagridview进行分页查询
Datagridview分页控件
11-26
C#开发的Datagridview分页控件源码，采用的真分页非存储过程方式。支持每页显示条数，页跳转，当前页和全部页导出Excel功能。 使用方法。将本控件源码导入自己的新建项目中，整个项目编译一次后，工具箱会自动生成一个第三方控件名称叫DataPager。在winForm上的datagridview控件下拖入本控件，设置好每页显示的最大记录条数（默认为50条记录）即可。代码中加入以下代码 this.dataPager1.RelationControl(this.Dgv);//本控件并联的datagridview控件名。 this.dataPager1.DataSource = ds.Tables[0];//本控件的数据源.
C#WinFrom分页控件
12-03
本文将深入探讨如何在C# WinForms中自定义一个动态分页控件，并结合存储过程来实现高效的数据检索。 首先，分页控件的基本概念是它允许用户按页浏览数据，而不是一次性加载所有记录。这对于处理大型数据集特别有用...
C#WinFrom分页.zip
09-15
【标题】"C# WinFrom 分页"是一个关于使用C#编程语言开发Windows桌面应用程序（WinForm）的项目，特别关注于数据分页显示技术。这个项目与Microsoft SQL Server数据库集成，提供了用户登录功能，以及对数据库进行增...
c# winfrom 分页控件
08-12
在本篇中，我们将深入探讨如何在没有使用存储过程的情况下实现分页功能。 首先，我们需要理解什么是分页。在数据库查询中，分页是用来限制返回结果的数量，每次只获取一部分数据，然后通过翻页来访问剩余的数据。...
winfrom dataset 分页
12-13
首先，DataSet是.NET框架中一个重要的数据容器，它可以存储来自不同数据源的数据，并提供了在内存中操作数据的功能，如查询、排序和分页。在WinForms应用中，DataSet通常与DataAdapter一起使用，用于从数据库中加载...
DataGridView使用BindingNavigator实现简单分页功能
10-15
主要介绍了DataGridView使用BindingNavigator实现简单分页功能，本文主要是通过借用BindingNavigator空壳，文中通过实例代码讲解的非常详细,需要的朋友可以参考下
datagridview实现分页
夏的博客
10-28 1万+
网上有很多这样的例子，但是没有自己想要的效果，所以今天花了点时间自己研究了一下，下面是效果图： 上面界面上主要用到的控件是panal，splitcontainer，bindingnavigator，datagridview这几个控件，具体的布局是先放一个panal（dock=fill），在用splitcontainer水平分割panal，上面那个panal1放datagridview下面
C#编程-79：DataGridView分页显示_彭世瑜_新浪博客
彭世瑜的博客
07-30 1289
usingSystem; usingSystem.Data; usingSystem.Data.SqlClient; usingSystem.Windows.Forms; namespaceDataGridViewDataNavigate { publicpartialclassForm1:Form { ...
winfrom datagridview
qq_32961291的博客
09-21 284
winform datagrid 添加勾选框和绑定数据
C# DataGridView实现分页显示功能
热门推荐
swedishsunset的专栏
01-06 1万+
以上是效果图 最近项目需要实现分页显示功能，自己写了一个用户控件进行记录一下，demo功能比较简单，数据来源主要以test手动添加为主 思路： 1.分页显示——将要显示的内容按照一次显示的大小建立DataTable   DataTable dt = new DataTable(tableName); 对于Table中如果有很多列需要建立，单独一个个手动添加会比较麻烦，可以选择建立一个...
C# 分页控件
leeyoua的博客
04-11 4725
界面：代码：using System;using System.Collections.Generic;using System.ComponentModel;using System.Drawing;using System.Data;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Win...
C#实现Winform dataGridView打印与分页实战教程
本文档详细介绍了如何在C# Winform中利用DataGridView控件实现打印功能以及分页功能。作者首先创建了一个名为`Example`的Windows Form类，该类继承自`Form`。在这个类中，作者引入了`PrintDocument`类来处理打印操作...
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值