操作DataTable数据实现排序、检索、合并、分页、统计等功能

DataView dv = dt.DefaultView;
dv.Sort = "id Asc,name Desc";
dt = dv.ToTable();

二、DataTable检索
1 设置查询字符串
2 使用Select方法获取到所有满足条件的数据行对象数组
(多项查询条件间，用and隔开.模糊查询使用 like %)
DataRow[] matches = dt.Select("(id>=20) and (title='会议') and (yearstr like '%2007%')");
string strName = matches[0]["name"].ToString();

另外也可以用下面这种方法，将检索出来的新表绑定到GridView

DataView dv = dt.DefaultView;
dv.RowFilter = "id>=2";

this.GridView1.DataSource = dv;
this.GridView1.DataBind();

三、DataTable合并
假定有2个DataTable:Dt1 , Dt2。表结构一样
将Dt2接在Dt1后可采用此方法
dt1.Merge(dt2);

四、DataTable分页
PagedDataSource pds = new PagedDataSource();
                pds.AllowPaging = true;
                pds.DataSource = dvIntegralExpense;
                pds.AllowPaging = true;
                pds.PageSize = pager.PageSize;
                pds.CurrentPageIndex = pager.PageIndex;

                rptIntegralExpense.DataSource = pds;
                rptIntegralExpense.DataBind();