1.datatable Sort 1:
Public DataTable Sortdesc (DataTable dt) {
DataView dv = new DataView ();
Dv. Table = DT;
Dv. Sort = "Autoid desc";
Return DV. ToTable ();
}
2. DataTable Sort 2
Public DataTable Sortdesc (DataTable dt) {
dt.DefaultView.Sort =
"ID ,Name ASC"
;
dt=dt.DefaultView.ToTable();
return DT;
}
3. Paging the DataTable
Returning records based on indexes and pagesize
</summary>
<param name= "DT" > Recordset datatable</param>
<param name= "PageIndex" > Current page </param>
<param name= "pagesize" > one-page record number </param>
<returns></returns>
public static DataTable splitdatatable (DataTable dt, int PageIndex, int PageSize)
{
if (PageIndex = = 0)
return DT;
DataTable NEWDT = dt. Clone ();
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;
}
Experience with DataTable operations-sorting and paging