本地数据DataTable实现数据分页

mac2022-06-30  24

//将datatable数据按照规定进行分页 public DataTable GetSelectData(DataTable dt, int PageIndex, int PageSize) {       if (PageIndex == 0)        return dt;//0页代表每页数据,直接返回

DataTable newdt = dt.Copy(); newdt.Clear();//copy dt的框架 int rowbegin = (PageIndex - 1) * PageSize; int rowend = PageIndex * PageSize; if (rowbegin >= dt.Rows.Count) return newdt;//源数据记录数小于等于要显示的记录,直接返回dt if (rowend > dt.Rows.Count) rowend = dt.Rows.Count; for (int i = rowbegin; i <= rowend - 1; i++) { DataRow newdr = newdt.NewRow(); DataRow dr = dt.Rows[i]; foreach (DataColumn column in dt.Columns) { newdr[column.ColumnName] = dr[column.ColumnName]; } newdt.Rows.Add(newdr); } return newdt;

}

转载于:https://www.cnblogs.com/fengmingming/p/8479371.html

相关资源:json获取datatable后生成table分页显示
最新回复(0)