sorting gridview in asp.net/c#

Question

I have a gridview which is defined as follows:

<asp:GridView ID="ComponentGridView" runat="server" AutoGenerateColumns="true" OnPageIndexChanging="ComponentGridView_PageIndexChanging" OnSorting="ComponentGridView_Sorting">
</asp:GridView>

and these are the methods that get invoked on ComponentGridView_Sorting

    protected void ComponentGridView_Sorting(object sender, GridViewSortEventArgs e)
    {
        DataTable dataTable = ComponentGridView.DataSource as DataTable;

        if (dataTable != null)
        {
            DataView dataView = new DataView(dataTable);
            dataView.Sort = e.SortExpression + " " + ConvertSortDirection(e.SortDirection);

            ComponentGridView.DataSource = dataView;
            ComponentGridView.DataBind();
        }
    }

and

 private string ConvertSortDirection(SortDirection sortDirection)
    {
        string newSortDirection = String.Empty;

        switch (sortDirection)
        {
            case SortDirection.Ascending:
                newSortDirection = "ASC";
                break;

            case SortDirection.Descending:
                newSortDirection = "DESC";
                break;
        }

        return newSortDirection;
    }

But it seems like nothing is happening when i click on the column headers.

What am i doing wrong ?

Please help me

Thanks in anticipation

When i debugged the dataTable is null

DataTable dataTable = ComponentGridView.DataSource as DataTable;

mservidio · Accepted Answer · 2011-04-09 22:49:59Z

4

Keep in mind that by default, this is stateless. So you'll need to retain a reference to your datasource, or query once again for the data.

protected void Page_Load(object sender, EventArgs e)
{
    if (!Page.IsPostBack)
    {
        DataTable dt = new DataTable();
        dt.Columns.Add("col1");
        dt.Columns.Add("col2");

        dt.Rows.Add(new object[] { 5, 1 });
        dt.Rows.Add(new object[] { 4, 2 });
        dt.Rows.Add(new object[] { 3, 3 });
        dt.Rows.Add(new object[] { 2, 4 });
        dt.Rows.Add(new object[] { 1, 5 });

        this.ComponentGridView.DataSource = dt;
        this.ComponentGridView.DataBind();

        Session["data"] = dt;
    }
}

protected void ComponentGridView_Sorting(object sender, GridViewSortEventArgs e)
{
    DataTable dataTable = Session["data"] as DataTable;

    if (dataTable != null)
    {
        DataView dataView = new DataView(dataTable);
        dataView.Sort = e.SortExpression + " " + ConvertSortDirection(e.SortDirection);

        ComponentGridView.DataSource = dataView;
        ComponentGridView.DataBind();
    }
}

private string ConvertSortDirection(SortDirection sortDirection)
{
    string newSortDirection = String.Empty;

    switch (sortDirection)
    {
        case SortDirection.Ascending:
            newSortDirection = "ASC";
            break;

        case SortDirection.Descending:
            newSortDirection = "DESC";
            break;
    }

    return newSortDirection;
}

answered Apr 9, 2011 at 22:49

mservidio

13.1k9 gold badges61 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Dev Over a year ago

from where did you get this code? Code Project ?? :) 3465 reputation dude.. :)

mservidio Over a year ago

@Dev - Most of the code was posted in the original question. I just updated it slightly.

SearchForKnowledge Over a year ago

I am getting Cannot find column 'ColumnName' error. Please help.

mservidio Over a year ago

@SearchForKnowledge can you provide more information/code on your error? Where is the error occurring?

SearchForKnowledge Over a year ago

I have four columns and I would like to sort based on any header clicked on any of the row. I opened a question here...stackoverflow.com/questions/25148278/…

|

Neel Bhasin · Accepted Answer · 2014-03-14 12:15:22Z

I've been reading and the sorting seems to break when you are manually providing the gridview a datasource. Not sure if that is your case, but this works for me..

When you first load the page and have queried the database, you must save the datatable in a Session variable (only the first time the page is loaded)

Session["GridData"] = myDBTier.GetData();
GridView1.DataSource = Session["GridData"];
GridView1.DataBind();

Then, in the Sorting event for the Gridview, place the following..

string strSortExpression = e.SortExpression + " ASC";
if (Convert.ToString(ViewState["SortExpression"]) == strSortExpression)
{
   strSortExpression = e.SortExpression + " DESC";
}
ViewState["SortExpression"] = strSortExpression;

//This is done by sorting the Default View of the underlying data and then re-binding this //to the grid.

System.Data.DataTable myData = HttpContext.Current.Session["GridData"] as System.Data.DataTable;
if (myData != null)
{
  myData.DefaultView.Sort = strSortExpression;
  GridView1.DataSource = myData;
  GridView1.DataBind();
}

Collectives™ on Stack Overflow

sorting gridview in asp.net/c#

2 Answers 2

6 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related