DataView数据视图实现数据过滤,排序

1. DataView过滤数据行
3. private void filterButton_Click(object sender, System.EventArgs e)
4.    {//过滤
5.     SqlConnection conn=new SqlConnection();
6.     conn.ConnectionString=ConfigurationSettings.AppSettings["ConnectionString"].ToString();
7.     conn.Open();
8.     string sql="select * from Products";
9.     SqlDataAdapter cmd=new SqlDataAdapter(sql,conn);
10.     ds=new DataSet();
11.     cmd.Fill(ds,"showTable");
12.     DataView dv=ds.Tables["showTable"].DefaultView;
13.     dv.RowFilter="ProductName like /'%"+name.Text+"%/'";   
14.     DataGrid1.DataSource=dv; 
15.     DataBind();
16.     cmd.Dispose();
17.     conn.Close();
18.     conn.Dispose();
19.    }
21. DataView多条件过滤
23. DataView dv=ds.Tables["showTable"].DefaultView;
24.     dv.RowFilter="ProductName like /'%"+name.Text+"%/' and ProductID="+name2.Text+"";   
25.     DataGrid1.DataSource=dv; 
26.     DataGrid1.DataBind();
28. DataView过滤状态行
30. DataView dv2=ds.Tables["showTable"].DefaultView;
31.     dv2.RowStateFilter=DataViewRowState.Deleted;//删除行
32.     DataGrid2.DataSource=dv2;
33.     DataGrid2.DataBind();
35. DataView dv2=ds.Tables["showTable"].DefaultView;
36.     dv2.RowStateFilter=DataViewRowState.CurrentRows;//目前行
37.     DataGrid2.DataSource=dv2;
38.     DataGrid2.DataBind();
40. 通过状态行可以显示用户所做过的操作，从而决定是否更新数据库数据
42. DataView排序
44. SqlConnection conn=new SqlConnection();
45.     conn.ConnectionString=ConfigurationSettings.AppSettings["ConnectionString"].ToString();
46.     conn.Open();
47.     string sql="select * from Products";
48.     SqlDataAdapter cmd=new SqlDataAdapter(sql,conn);
49.     ds=new DataSet();
50.     cmd.Fill(ds,"showTable");
51.     DataView dv=ds.Tables["showTable"].DefaultView;
52.     dv.RowFilter="ProductName like /'%"+name.Text+"%/'";   
53.     dv.Sort="SupplierID DESC,ProductName DESC";
54.     DataGrid1.DataSource=dv; 
55.     DataGrid1.DataBind();
56.     cmd.Dispose();
57.     conn.Close();
58.     conn.Dispose();
59. DataGrid排序
61. private void DataGrid1_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
62.    {//排序
63.     SqlConnection conn=new SqlConnection();
64.     conn.ConnectionString=ConfigurationSettings.AppSettings["ConnectionString"].ToString();
65.     conn.Open();
66.     string sql="select * from Products";
67.     SqlDataAdapter cmd=new SqlDataAdapter(sql,conn);
68.     ds=new DataSet();
69.     cmd.Fill(ds,"showTable");
70.     dv2=ds.Tables["showTable"].DefaultView;
71.     dv2.Sort=e.SortExpression;
72.     DataGrid1.DataSource=dv2;
73.     DataGrid1.DataBind();
74.    }
76. DataGrid利用DataView过滤,排序(以下代码为网上收集)
78. DataSet ds = new DataSet(); 
79. SqlConnection conn =   new SqlConnection("server=localhost;uid=sa;pwd=sa;DataBase=pubs"); 
80. SqlDataAdapter ada = new SqlDataAdapter("select * from authors",conn); 
81. conn.Open(); 
82. ada.Fill(ds,"a"); 
83. conn.Close(); 
84. DataView dv = new DataView(); 
85. dv.Table = ds.Tables[0]; 
86. dv.RowFilter = "au_fname like 'a%'"; 
87. dv.Sort = "au_id DESC"; 
88. tst.DataSource=dv; 
89. tst.DataBind();