ado.net 学习 07 [DataView类,使用DataView排序DataView.Sort属性 ]
DataView类为DataTable对象定义了一个视图,DataView提供了Sort属性和RowFilter属性(可进行配置),借助这些属性选择视力中显示的内容,而并不会影响DataTable里的真实数据。
1.
// Sort by TitleOfCourtesy,FirstName.
DataView view4 = new DataView(ds.Tables["Employees"]);
view4.Sort = "TitleOfCourtesy,FirstName";
GridView4.DataSource = view4;
2.
//两种写法
this.DataBind();
//Page.DataBind();
1 protected void Page_Load(object sender, EventArgs e) 2 { 3 // Create the Connection, DataAdapter, and DataSet. 4 string connectionString = WebConfigurationManager.ConnectionStrings["Northwind"].ConnectionString; 5 SqlConnection con = new SqlConnection(connectionString); 6 string sql = "SELECT TOP 5 EmployeeID, TitleOfCourtesy, LastName, FirstName FROM Employees"; 7 8 SqlDataAdapter da = new SqlDataAdapter(sql, con); 9 DataSet ds = new DataSet(); 10 11 // Fill the DataSet 12 da.Fill(ds, "Employees"); 13 14 // Bind the original data to #1. 15 GridView1.DataSource = ds.Tables["Employees"]; 16 17 // Sort by last name and bind it to #2. 18 DataView view2 = new DataView(ds.Tables["Employees"]); 19 view2.Sort = "LastName"; 20 GridView2.DataSource = view2; 21 22 // Sort by first name and bind it to #3. 23 DataView view3 = new DataView(ds.Tables["Employees"]); 24 view3.Sort = "FirstName"; 25 GridView3.DataSource = view3; 26 27 // Sort by Sort by TitleOfCourtesy,FirstName. 28 DataView view4 = new DataView(ds.Tables["Employees"]); 29 view4.Sort = "TitleOfCourtesy,FirstName"; 30 GridView4.DataSource = view4; 31 32 // Bind all the data-bound controls on the page. 33 // Alternatively, you could call the DataBind() method 34 // of each grid separately 35 36 //两种写法 37 this.DataBind(); 38 //Page.DataBind(); 39 }
<div> <b><u>Original Order</u></b><br /> <asp:GridView ID="GridView1" runat="server"></asp:GridView> <br /> <b><u>Sort = "LastName"</u></b><br /> <asp:GridView runat="server" ID="GridView2" HeaderStyle-Font-Bold="true" /> <br /> <b><u>Sort = "FirstName"</u></b><br /> <asp:GridView runat="server" ID="GridView3" HeaderStyle-Font-Bold="true" /> <br /> <b><u>Sort = "TitleOfCourtesy,FirstName"</u></b><br /> <asp:GridView runat="server" ID="GridView4" HeaderStyle-Font-Bold="true" /> </div>
运行结果对比: