对DataTable进行分页

在某些情况下有必要通过DataTable进行分页处理

 

 1         /// <summary>
 2         /// 对DataTable进行分页,起始页为1
 3         /// </summary>
 4         /// <param name="dt"></param>
 5         /// <param name="PageIndex"></param>
 6         /// <param name="PageSize"></param>
 7         /// <returns></returns>
 8        public static DataTable GetPagedTable(DataTable dt, int PageIndex, int PageSize)
 9         {
             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;
         }