DataTable 分页

 #region DataTable 分页        

/// <summary>        

/// Datatable 分页        

/// </summary>        

/// <param name="dt"></param>        

/// <param name="PageIndex">当前页</param>        

/// <param name="PageSize">页大小</param>        

/// <returns></returns>        

public static 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

posted on 2016-07-11 17:07  張暁磊  阅读(253)  评论(0编辑  收藏  举报