I am using the ADO.NET Entity Framework data model. I send data from SQL to a GridView via ADO.NET Entity Framework.
But how can i sort gridview'columns click if i use EF
+1
A:
Are you using an EntityDataSource ? Have you enabled the AllowSorting and AllowPaging properties on the GridView ?
<asp:GridView ID="GridView1" runat="server"
AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="True"
DataSourceID="EntityDataSource1">
</asp:GridView>
<asp:EntityDataSource ID="EntityDataSource1" runat="server"
ConnectionString="......"
EntitySetName="......."
Select=".........." OrderBy="......">
</asp:EntityDataSource>
Marc
marc_s
2009-06-22 09:21:19
i dont use EntityDataSource why i need it. I want to make it C# codes.
Phsika
2009-06-22 14:11:02
USE IT ! that's the way to get sorting and paging for free.
marc_s
2009-06-22 15:00:49
How to sort gridview columns by Clicking columns? i dont use below
Phsika
2009-06-23 07:52:54
void LoadProducts() { ABCBusinessFrameWork._SQLAccessLayer client = new ABCBusinessFrameWork.LoadData(); Session["TaskTable"] = client.GetAllData("sp_GetAllProducts", CommandType.StoredProcedure); gvProducts.DataSource = Session["TaskTable"]; gvProducts.DataBind(); }
Phsika
2009-06-23 07:55:23
protected void gvProducts_Sorting(object sender, GridViewSortEventArgs e) { //Retrieve the table from the session object. DataTable dt = Session["TaskTable"] as DataTable;
Phsika
2009-06-23 07:57:01
My advice: forget about doing this manually - USE the EntityDataSource! You'll save yourself a LOT of grief and code!!
marc_s
2009-06-23 09:27:45