C# 分页

源码

//变量
        DataTable dtViewAll = new DataTable();  //表数据
        DataTable dtView = new DataTable();     //显示界面数据
        int dtViewRowsIndex = 22, LineNow;    //单页行数，当前行数
//getdata
                dtViewAll.Clear();
                dtViewAll = dtNew;
                //分页显示
                dtView = dtViewAll.Clone();
                if (dtViewAll.Rows.Count <= dtViewRowsIndex)
                {
                    dtViewRowsIndex = dtView.Rows.Count;
                    for (int i = 0; i < dtViewRowsIndex; i++)
                    {
                        dtView.Rows.Add(dtViewAll.Rows[i].ItemArray); //添加数据行
                    }
                    gridControl1.DataSource = dtView;
                    gridControl1.ForceInitialize();
                    MergeCell(dtView);
                }
                else
                {
                    for (int i = 0; i < dtViewRowsIndex; i++)
                    {
                        dtView.Rows.Add(dtViewAll.Rows[i].ItemArray); //添加数据行
                    }
                    gridControl1.DataSource = dtView;
                    gridControl1.ForceInitialize();
                    LineNow = dtViewRowsIndex;
                    timerRoll.Enabled = true;
                }
//定时器
        //定时翻页
        private void timerRoll_Tick(object sender, EventArgs e)
        {
            timerRoll.Interval = 5000;
            dtView.Clear();
            dtView = dtViewAll.Clone();
            //判断数据是否还有21行
            if (dtViewAll.Rows.Count > LineNow + dtViewRowsIndex)
            {
                for (int i = LineNow; i < LineNow + dtViewRowsIndex; i++)
                {
                    dtView.Rows.Add(dtViewAll.Rows[i].ItemArray); //添加数据行
                }
                gridControl1.DataSource = "";
                gridControl1.DataSource = dtView;
                gridControl1.ForceInitialize();
                LineNow += dtViewRowsIndex;
            }
            else
            {
                for (int i = LineNow; i < dtViewAll.Rows.Count; i++)
                {
                    dtView.Rows.Add(dtViewAll.Rows[i].ItemArray); //添加数据行
                }
                LineNow = 0;
                gridControl1.DataSource = dtView;
                gridControl1.ForceInitialize();
                //MergeCell(dtView);    //合并单元格
            }
        }