- #region GetPagedTable DataTable分页
- /// <summary>
- /// DataTable分页
- /// </summary>
- /// <param name="dt">DataTable</param>
- /// <param name="PageIndex">页索引,注意:从1开始</param>
- /// <param name="PageSize">每页大小</param>
- /// <returns></returns>
- public DataTable GetPagedTable(DataTable dt, int PageIndex, int PageSize)
- {
- if (PageIndex == 0)
- return dt;
- DataTable newdt = dt.Copy();
- newdt.Clear();
- int rowbegin = (PageIndex - 1) * PageSize;
- int rowend = PageIndex * PageSize;
- if (rowbegin >= dt.Rows.Count)
- return newdt;
- 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;
- }
- #endregion
datatable分页(转载)
最新推荐文章于 2019-09-19 09:54:00 发布