ASP.net: How to make list of object sortable when bind to control such as gridview

asp.net

I got a class let's call it Blah. I use ObjectDataSource to get the data from the database and the value is bind it to Blah's property for example, Column Foo is Blah.Foo in my class. I can bind ObjectDataSource with a list of Blah to a gridview but i can't make it sortable since the datasource is not datatable. Does anyone have link or tutorial on how to make object to be sortable for control like gridview.

thank

Jack

Best Answer

First you could use the AllowSorting property of the gridview with SortExpression on your fields. Here is a tutorial

Second, you could made a generic list of Blah and then call .Sort()

List<Blah> test = new List<Blah>;
test.AddRange(ObjectDataSource);
test.Sort();

msdn information

Third you could sort the gridview directly from an expression like

CustomersGridView.Sort(expression, direction);

link

Related Solutions

How to make asp:GridView sortable

this code will definitely help you:

In the GridView, Make the Property AllowSorting = "True" and in the GridView Columns give like this

<asp:BoundField DataField="UserName" HeaderText="User Name" SortExpression="UserName" />
<asp:BoundField DataField="FullName" HeaderText="Full Name" SortExpression="FullName" />

and also use the below coding:

protected void gv_Sorting(object sender, GridViewSortEventArgs e)
{
    try
    {
        string sortExpression = e.SortExpression;
        ViewState["z_sortexpresion"] = e.SortExpression;
        if (GridViewSortDirection == SortDirection.Ascending)
        {
            GridViewSortDirection = SortDirection.Descending;
            SortGridView(sortExpression, "DESC");
        }
        else
        {
            GridViewSortDirection = SortDirection.Ascending;
            SortGridView(sortExpression, "ASC");
        }
    }
    catch (Exception ex)
    {
        return ex.Message.ToString();
    }
}
public SortDirection GridViewSortDirection
{
    get
    {
        if (ViewState["sortDirection"] == null)
            ViewState["sortDirection"] = SortDirection.Ascending;
        return (SortDirection)ViewState["sortDirection"];
    }
    set
    {
        ViewState["sortDirection"] = value;
    }

}
private void SortGridView(string sortExpression, string direction)
{
    DTSorting = new DataView(DTSorting, "", sortExpression + " " + direction, DataViewRowState.CurrentRows).ToTable();
    gv.DataSource = DTSorting;
    gv.DataBind();
}
public DataTable DTSorting
{
    get
    {
        if (ViewState["Sorting"] != null)
        {
            return (DataTable)ViewState["Sorting"];
        }
        else
            return null;
    }
    set
    {
        ViewState["Sorting"] = value;
    }
}

Here, Consider "DTSorting" is the DataTable by which you binds the GridView "gv".

Best Answer

Related Solutions

How to make asp:GridView sortable

Related Topic