DataGridView 分页

最新推荐文章于 2024-08-23 16:26:38 发布

原创最新推荐文章于 2024-08-23 16:26:38 发布 · 424 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#object #button #null #query

.NET 专栏收录该内容

48 篇文章

订阅专栏

本文介绍了一种用于数据加载及分页显示的技术实现，包括数据克隆、页面计数、信息展示与数据加载过程的优化。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

     void Query_Worker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
        {
            if (e.Result != null)
            {
                object[] obj = e.Result as object[];

                if (obj != null)
                {
                    if (obj[0] != null)
                    {

                        dtClone = obj[0] as DataTable;
                        //SetInfo(lbInfo); 
                        PageIndex = 1;
                        SetPageCount(dtClone);
                        LoadData(dtClone, grid_KP);
                        //grid_KP.DataSource = obj[0];  

                    }
                }

            }
        }

        private void Button_Pre_Click(object sender, EventArgs e)
        {
            if (PageIndex<=1)
            {
                MessageBox.Show("已经是第一页!","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
                return;
            }
            PageIndex--;
            LoadData(dtClone,grid_KP);
           
          
        }

        private void Button_Next_Click(object sender, EventArgs e)
        {
            if (PageIndex >= PageCount)
            {
                MessageBox.Show("已经是最后一页!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            PageIndex++;
            LoadData(dtClone,grid_KP);
           
        }

        #region
        private int PageCount = 0;//总页数
        private int PageSize = 10;//每页记录显示条数
        private int PageIndex = 0;//当前页数 
        private int _Max = 0;
        private DataTable dtClone = null;


        private void SetInfo(Label lb)
        {
            lb.Text = string.Format("当前第{0}页,总共{1}页{2}条数据",PageIndex,PageCount,_Max);
        }
        /// <summary>
        /// 设置页数
        /// </summary>
        /// <param name="dt">源数据</param>
        private void SetPageCount(DataTable dt)
        {

            _Max = dt.Rows.Count;
            PageCount = _Max / PageSize;
            if (_Max % PageSize > 0)
                PageCount++;


        }

        private void LoadData(DataTable dt,DataGridView grid)
        {
            DataTable dtTemp = dt.Clone();
            dtTemp.Clear(); 
            
            for (int i = PageSize * (PageIndex - 1); i <(PageSize * PageIndex < _Max ? PageSize * PageIndex : _Max); i++) 
            {

                dtTemp.ImportRow(dt.Rows[i]);

            } 
            grid.DataSource = dtTemp;
            grid_KP.Columns["物料描述"].Width = 280;
            SetdataGridView(grid_KP);
            SetInfo(lbInfo);

        }