C# dataTable分页

来源:互联网 发布:js游戏开发教程 编辑:程序博客网 时间:2024/06/11 03:08
private int pageCount = 1;
public DataTable GetPageInfo(DataTable dt, int pageIndex, int pageSize)        {            if (pageIndex <= 0)            {                return dt;            }            int rowsBegin = (pageIndex - 1) * pageSize;            int rowsEnd = pageSize * pageIndex;            if (rowsBegin >= dt.Rows.Count)            {                pageCount = 1;                return dt;            }            DataTable newInfoDataTable = dt.Copy();            newInfoDataTable.Clear();            if (rowsEnd>dt.Rows.Count)            {                rowsEnd = dt.Rows.Count;            }            for (int i = rowsBegin; i < rowsEnd; i++)            {                DataRow newdr = newInfoDataTable.NewRow();                 DataRow dr = dt.Rows[i];                 foreach (DataColumn column in dt.Columns)                 {                     newdr[column.ColumnName] = dr[column.ColumnName];                 }                newInfoDataTable.Rows.Add(newdr);             }            if (dt.Rows.Count % pageSize == 0)            {                pageCount = dt.Rows.Count / pageSize;            }            else            {                pageCount = dt.Rows.Count / pageSize + 1;            }            LbShowPageInfo.Text = string.Format("总共有{0}数据,每页{1}条数据,共{2}页,目前在{3}页",dt.Rows.Count,pageSize,pageCount,pageIndex);            return newInfoDataTable;        }