Sorting in ASP.NET Gridview

Question

Its Arun. This time I have a sorting issue in ASP.Net. For the first click, descending is working fine but on the second click ascending is not taken again. Its still in the descending order. I m using Tableadapter to display the gridview content. Please review the code and correct me where I ve missed.

    protected void gv1_Sorting(object sender, GridViewSortEventArgs e)
    {
        string sdir = e.SortDirection == SortDirection.Ascending ? "DESC" : "ASC";
        DataView dv = new DataView(ds2.AllocationPending(ClientLoggedIn.Text));
        dv.Sort = e.SortExpression + " " + sdir;
        gv1.DataSource = dv;
        gv1.DataBind();
    }

Also please explain - Is there any other way to apply sorting without Dataview.

Thank you .

GridView Amazing Link By Microsoft

Shaik Raffi
– Shaik Raffi

2013-06-18 09:48:41 +00:00
Commented Jun 18, 2013 at 9:48 — Shaik Raffi
– Shaik Raffi, Commented Jun 18, 2013 at 9:48

Arun · Accepted Answer · 2013-05-08 06:18:03Z

2

I have found the solution for this issue. The reason is e.SortDirection always returns Ascending. So I need to store the e.SortDirection in a ViewState and sort the dataview with that value. Updated coding follows:

    protected void gv1_Sorting(object sender, GridViewSortEventArgs e)
    {
        string SortDirection = "DESC";
        if (ViewState["SortExpression"] != null)
        {
            if (ViewState["SortExpression"].ToString() == e.SortExpression)
            {
                ViewState["SortExpression"] = null;
                SortDirection = "ASC";
            }
            else
            {
                ViewState["SortExpression"] = e.SortExpression;
            }
        }
        else
        {
            ViewState["SortExpression"] = e.SortExpression;
        }

        DataView dv = new DataView(ds2.AllocationPending(ClientLoggedIn.Text));
        dv.Sort = e.SortExpression + " " + SortDirection;
        gv1.DataSource = dv;
        gv1.DataBind();
    }

answered May 8, 2013 at 6:18

Arun

7384 gold badges16 silver badges31 bronze badges

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

1 Comment

Kai Hartmann Over a year ago

I don't get for what e.SortDirection is used then... Microsoft actually says that it should change automatically, if you click the same column header twice...

Johnny Bones · Accepted Answer · 2014-08-27 11:39:50Z

1

 protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
    {      
        DataTable dtSortTable = GridView1.DataSource as DataTable;

        if (dtSortTable != null)
        {
            DataView dvSortedView = new DataView(dtSortTable);

            dvSortedView.Sort = e.SortExpression + "" + getSortDirectionString(e.SortDirection);

            GridView1.DataSource = dvSortedView;
            GridView1.DataBind();
        }
    }

private string getSortDirectionString(SortDirection sortDirection)
    {
        string newSortDirection = String.Empty;
        if(sortDirection== SortDirection.Ascending)
        {
            newSortDirection = "DESC";
        }
        else
        {
            newSortDirection = "ASC";
        }
        return newSortDirection;
}

Try this code for sorting the gridview

edited Aug 27, 2014 at 11:39

Johnny Bones

8,4927 gold badges61 silver badges127 bronze badges

answered May 7, 2013 at 10:08

Chetan Sanghani

2,1313 gold badges22 silver badges39 bronze badges

4 Comments

Arun Over a year ago

I m not using the Radgrid. I m developing the ASP.Net Gridview. The above code is applicable to Radgrid only. So no use for me.

Arun Over a year ago

Thank you Chetan for the gridview code. But its the same code logic which I posted in my question. You called the Sortdirection as a separate function whereas I included in the same one. Also a small correction in your code - if(sortDirection== SortDirection.Ascending) then newSortDirection = "DESC"; Anyway its working fine for the first time but not the second time. Please look on that.

Arun Over a year ago

I have found the solution for this issue. The reason is e.SortDirection always returns Ascending. So I need to store the e.SortDirection in a ViewState and sort the dataview with that value. Updated coding follows:

Arun Over a year ago

string SortDirection = "DESC"; if (ViewState["SortExpression"] != null) { if (ViewState["SortExpression"].ToString() == e.SortExpression) { ViewState["SortExpression"] = null; SortDirection = "ASC"; } else { ViewState["SortExpression"] = e.SortExpression; } } else { ViewState["SortExpression"] = e.SortExpression; }

Collectives™ on Stack Overflow

Sorting in ASP.NET Gridview

2 Answers 2

1 Comment

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related