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; }