How to sorting the gridview data

Question

See the below code, I am try to sorting Grid view data by calling function provided by the Microsoft vs 2008, but the paging is done well but the sorting process is not work, tell me where should i change the following code and yes i put grid view in updated penal,is there problem regarding to update penal?

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
    GridView1.PageIndex = e.NewPageIndex;
    showData();
}
protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
{
    try
    {
        SqlCommand cmd = new SqlCommand("showData", con);
        cmd.CommandType = CommandType.StoredProcedure;
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        if (ds.Tables[0] != null)
        {

            ds.Tables[0].DefaultView.Sort = e.SortExpression + " " + sortType(e.SortDirection);
            GridView1.DataSource = ds;
            GridView1.DataBind();
        }
    }
    catch (Exception ex)
    {
        Label1.Text = ex.ToString();
    }
}


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

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

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

    return newSortDirection;
}

score 0 · Answer 1 · edited May 23 '17 at 12:20

0

Can you ensure AllowSorting="true" and OnSorting="GridView1_Sorting"

Also refer

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.sorting.aspx

http://www.codeproject.com/Articles/26882/Gridview-Sorting-with-Up-and-Down-Icons-Paging

sorting and paging with gridview asp.net

http://www.c-sharpcorner.com/uploadfile/afenster/gridview-sorting/

Hope this helps

edited May 23 '17 at 12:20

Community

1
1

answered May 22 '12 at 04:56

Deepu Madhusoodanan

1,495
1
14
26

yes i did AllowSorting="true" and OnSorting="GridView1_Sorting" – Dadu May 22 '12 at 05:06
i use paging and sorting on the same grid view is it possible in asp.net – Dadu May 22 '12 at 05:17

score 0 · Answer 2 · answered May 22 '12 at 05:12

i think you have to assign dataview to the DataSource property of gridview, not the dataset object. like this

 DataTable dt = ds.Tables[0];

 DataView dv = new DataView(dt); 
 dv.Sort = e.SortExpression + " " + sortType(e.SortDirection);
 GridView1.DataSource = dv;
 GridView1.DataBind();

score -1 · Answer 3 · answered May 22 '12 at 05:17

-1

you are missing a default value for newSortDirection.

private string sortType(SortDirection sortDirection)
{
    string newSortDirection = "ASC";

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

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

    return newSortDirection;
}

answered May 22 '12 at 05:17

Ray Cheng

12,230
14
74
137

What's wrong with my answer? Please explain so I can learn from my mistakes. – Ray Cheng May 23 '12 at 02:22

How to sorting the gridview data

3 Answers3