Sorting gridview

Question

I have a gridview where I bind a datasource, and I had to add sorting for this gridview; I added the code below to that, but it didn't work well.

private string ConvertSortDirectionToSql(SortDirection sortDireciton)
{
    string m_SortDirection = String.Empty;

    switch (sortDireciton)
    {
        case SortDirection.Ascending:
            m_SortDirection = "ASC";
            break;

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

    return m_SortDirection;
}

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

    if (m_DataTable != null)
    {
        DataView m_DataView = new DataView(m_DataTable);
        m_DataView.Sort = e.SortExpression + " " + ConvertSortDirectionToSql(e.SortDirection);

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

what is the issue, you are getting? how can you say it is not working well? — Muhammad Akhtar, Oct 19 '10 at 09:25
Possible duplicate of [GridView sorting: SortDirection always Ascending](https://stackoverflow.com/questions/250037/gridview-sorting-sortdirection-always-ascending) — , Jul 01 '17 at 15:19

score 1 · Answer 1 · edited Aug 09 '16 at 20:15

Try this out. This method worked for me.

dt is the datatable containing the values.

 protected void onSorting_Gridview1(object sender, GridViewSortEventArgs e)
            {
                string _sortDirection = dir.ToString();
                if(_sortDirection.Equals("Ascending"))
                {
                _sortDirection = "ASC";
                dir = SortDirection.Descending;

            }
            else
            {
                _sortDirection="DESC";
                dir = SortDirection.Ascending;

            }

            if (dt != null)
            {
                //Sort the data.
                dt.DefaultView.Sort = e.SortExpression + " " + _sortDirection;
                gridView1.DataSource = dt;
                gridView1.DataBind();
            }

        }


 public SortDirection dir
    {
        get
        {
            if (ViewState["DIR"] == null)
            {
               ViewState["DIR"] = SortDirection.Ascending;
            }
            return (SortDirection)ViewState["DIR"];
        }
        set
        {
           ViewState["DIR"] = value;
        }
    }

score 1 · Answer 2 · edited May 23 '17 at 12:08

1

Maybe this could help if your sortdirection is always ascending.

edited May 23 '17 at 12:08

Community

1
1

answered Oct 19 '10 at 10:20

Tim Schmelter

450,073
74
686
939

score 1 · Accepted Answer · edited Jun 05 '17 at 09:26

You can use this, as I had the same problem, and I solved it like this.

public string SortingExpression
{
    get
    {
        if (this.ViewState["SortExpression"] == null)
            return "";
        else
            return (string)this.ViewState["SortExpression"];
    }

    set
    {
        this.ViewState["SortExpression"] = value;
    }
}

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

    if (m_DataTable != null)
    {
        DataView m_DataView = new DataView(m_DataTable);
        SortingExpression = e.SortExpression + " " + (SortingExpression.Contains("ASC") ? "DESC" : "ASC");
        m_DataView.Sort =SortingExpression;

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

It didnot work But when I made breakpoint on GridView1_Sorting .I had null data in table .and this error apear (DataTable must be set prior to using DataView) when I hashed if (m_DataTable != null) — Myworld, Oct 19 '10 at 12:23

Sorting gridview

3 Answers3

Linked