DataView 是一种数据视图,是一个数据表的副本,可以很方便的对数据进行筛选,排序等功能,可以作为数据源与数据控件进行绑定
DataView 的常见用法如下:
Code
1//创建一个DataView对象
2 DataView dv = new DataView(dt);
3 //行筛选
4 dv.RowFilter = "Name like'aa'";
5 //行状态筛选
6 dv.RowStateFilter = DataViewRowState.Added;
7 //排序
8 dv.Sort = "ID desc";
9 //删除所属索引的行
10 dv.Delete(0);
11 //在视图中添加新行
12 DataRowView ddd = dv.AddNew();
13 ddd[0] = 10;
14 ddd[1] = "Jack";
15 ddd.EndEdit();
16 //将DataView转换为DataTable,Ture为去掉重复行,"ID"是要在DataTable显示的字段
17 //DataView.ToTable (String, Boolean, String[])
18 DataTable dd = dv.ToTable(true, "ID");
19 //return dd;
1//创建一个DataView对象
2 DataView dv = new DataView(dt);
3 //行筛选
4 dv.RowFilter = "Name like'aa'";
5 //行状态筛选
6 dv.RowStateFilter = DataViewRowState.Added;
7 //排序
8 dv.Sort = "ID desc";
9 //删除所属索引的行
10 dv.Delete(0);
11 //在视图中添加新行
12 DataRowView ddd = dv.AddNew();
13 ddd[0] = 10;
14 ddd[1] = "Jack";
15 ddd.EndEdit();
16 //将DataView转换为DataTable,Ture为去掉重复行,"ID"是要在DataTable显示的字段
17 //DataView.ToTable (String, Boolean, String[])
18 DataTable dd = dv.ToTable(true, "ID");
19 //return dd;