dot net gridview sorting problem

Question

I have a web application (with C#). I have a GridView and want to be able to sort its contents. I have added the tags

...

AllowSorting="True"
onsorting="MyGridView_Sorting">

and

asp:BoundField DataField="NAME" HeaderText="Name" SortExpression="NAME"

inside the GridView. I have implemented the MyGridView_Sorting method. Thing is: it does not work. Does nothing. The header text "Name" looks like an active link, but clicking produces no effect. Putting a break point inside

MyGridView_Sorting

shows that it actually never goes inside the function. What is wrong? What do I miss?

Thanks!!!

Sep

< asp:GridView ID="MyGridView"
runat="server"                               
CssClass="pvgrid" 
Width="90%" 
AutoGenerateColumns="false"
OnRowCommand="MyGridView_RowCommand"
AllowPaging="True" 
PageSize="10" 
AllowSorting="True"
onsorting="MyGridView_Sorting" 
onpageindexchanging="MyGridView_PageIndexChanging" >

< Columns >
< asp:BoundField DataField="NAME" HeaderText="Name" SortExpression="NAME"  />
< /Columns >
< /asp:GridView >


protected void MyGridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
    MyGridView.PageIndex = e.NewPageIndex;
    MyGridView.DataBind();
}

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

    if (dataTable != null)
    {
        DataView dataView = new DataView(dataTable);
        dataView.Sort = e.SortExpression + " "+ ConvertSortDirectionToSql(e.SortDirection);
        MyGridView.DataSource = dataView;
        MyGridView.DataBind();
    }
}

this. __curious_geek · Accepted Answer · 2010-06-30 08:49:02Z

3

GridView delegates sorting to underlying DataSource. GridView does not perform sorting on its own, it just delegates. So you need to look into your DataSource for sorting. What is the DataSource ? What kind of Data does it display ? Are those custom objects coming from ObjectDataSource or you're using SqlDataSource or LinqDataSource ?

answered Jun 30, 2010 at 8:49

this. __curious_geek

43.2k22 gold badges117 silver badges137 bronze badges

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

3 Comments

Giuseppe Over a year ago

I populate the data source with a custom function that interrogates the database and binds a dataset to the gridview. What I do not understand is why the application does not even get inside my sorting function. Not even the first line. The function is not called at all. I am sure I am not understanding properly the logic of this business...

Giuseppe Over a year ago

the editor does not like "<", ">" how do I put the code inside my post?

Giuseppe Over a year ago

what I would like to understand first is why clicking on the bound field with a sort expression does not make the application call the sorting method

Collectives™ on Stack Overflow

dot net gridview sorting problem

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related