111,096
社区成员




string query = "select CustomerID,CompanyName,ContactName from Customers";
string connString = //...假定连接字符串是一个有效的连接字符串
SqlDataAdapter ad = new SqlDataAdapter(query,connString);
DataSet ds = new DataSet();
ad.Fill(ds,"Customers");
DataViewManager vueManager = new DataViewManager(ds);
//下面该如何使用vueManager对象来影响DataView呢?
//在DataViewManager对象中公开了DataViewSettings属性,但是这个属性在我看来根本是个摆设!
//它根本不能控制DataView的所包含的RowFilter,RowStateFilter,Sort属性!
SqlDataAdapter ad = new SqlDataAdapter(query,connString);
DataSet ds = new DataSet();
ad.Fill(ds, "Customers");
DataViewManager vueManager = new DataViewManager(ds);
DataViewSetting vueSet1 = vueManager.DataViewSettings["Customers"];
vueSet1.Sort = "ContactName";
// 根据上面的设置创建DataView对象
DataView view = vueManager.CreateDataView(ds.Tables["Customers"]);
// 对DataView进行后续操作,例如绑定到显示控件,或用foreach枚举每一行:
//System.Windows.Forms.DataGrid grid = new System.Windows.Forms.DataGrid();
//grid.DataSource = view;
//this.Controls.Add(grid);