GridView数据绑定.docx

9.4 LINQ数据绑定Linq具有强大的数据访问功能，通过Linq语句，可以实现对数据库增删改查操作，并将数据绑定到页面中，通过配合GridView等数据绑定控件，可以实现更为灵活的数据绑定、访问方式。本节将介绍以LINQ为核心的数据绑定方法。9.4.1 GridView分页与排序通过Linq进行GridView绑定，实现GridView的分页与排序。需要对AllowSorting属性，AllowPaging属性和pageSize属性值进行相应的设置。本实例通过GridView控件实现分页和部分字段排序，实例展示如图9-28所示，实例将根据可排序字段和分页空间实现数据的分页显示和按字段排序。图9-28 GridView数据分页与排序实现GridView数据分页与排序的页面源代码：%@PageLanguage=C#AutoEventWireup=trueCodeFile=GridViewPS.aspx.csInherits=chap8_GridViewPS%!DOCTYPEhtmlPUBLIC-//W3C//DTD XHTML 1.0 Transitional//EN/TR/xhtml1/DTD/xhtml1-transitional.dtdhtmlxmlns=/1999/xhtmlheadrunat=servertitle/title/headbodyformid=form1runat=serverdivasp:GridViewID=gvProductrunat=serverAllowPaging=TrueAllowSorting=TrueAutoGenerateColumns=FalseOnPageIndexChanging=gvProduct_PageIndexChangingOnSorting=gvProduct_SortingPageSize=5Columnsasp:BoundFieldDataField=ProductIDHeaderText=产品IDSortExpression=ProductID/asp:BoundFieldDataField=CategoryIDHeaderText=类别ID/asp:BoundFieldDataField=NameHeaderText=产品名称SortExpression=Name/asp:BoundFieldDataField=UnitCostHeaderText=成本价/asp:BoundFieldDataField=ListPriceHeaderText=单价/asp:BoundFieldDataField=QtyHeaderText=库存数量//Columns/asp:GridView/div/form/body/html实现GridView数据分页与排序的程序源代码：using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;publicpartialclasschap8_GridViewPS : System.Web.UI.Page{protectedvoid Page_Load(object sender, EventArgs e) {if (!IsPostBack) bindGrid(); }privatevoid bindGrid() {MyPetShopDataContext dc = newMyPetShopDataContext();var products = from r in dc.Productselect r;//判断是否已经进行排序，如果是则按照ViewState中存储的信息生成排序后的DataView对象if (ViewState[SortDirection] == null) gvProduct.DataSource = products; else {if (ViewState[SortDirection].ToString() == DESC)//降序 {if (ViewState[SortExpression].ToString() == ProductID) gvProduct.DataSource = products.OrderByDescending(s = s.ProductId);if (ViewState[SortExpression].ToString() == Name)