RadGrid Custom Sorting with header context menu

[Dee]

Hi,

I'm using a radgrid with custom paging & custom sorting. Custom sorting by clicking on headers works fine except that when I right click on the header and use the context menu to sort columns, it sorts them with natural sort and does not invoke my OnSortCommand server side callback. 

<telerik:RadGrid ID="SearchResultGrid"
        AllowPaging="True" AllowCustomPaging="true" EnableViewState="True" AllowFilteringByColumn="False"
        AllowSorting="true" AllowNaturalSort="false" AllowCustomSorting="true" OnSortCommand="SearchResultGrid_OnSort"
        AutoGenerateColumns="False" runat="server" PageSize="20"
        EnableLinqExpressions="false" EnableAJAX="false" ItemStyle-Wrap="false" AlternatingItemStyle-Wrap="false" ...>
    <HeaderContextMenu OnItemClick="HeaderContextMenu_ItemClick" OnItemCreated="HeaderContextMenu_ItemCreated"
            OnPreRender="HeaderContextMenu_PreRender">
        <CollapseAnimation Duration="200" Type="OutQuint" />
    </HeaderContextMenu>
    ...

How can I make the header context menu sorting use custom sorting?

[Pavlina]

Hello Dee,

The SortCommand is not firing when sorting with header context menu. You can wire an event handler for the ItemClick event of the header context menu and there put the logic for custom sorting:

protected void HeaderContextMenu_ItemClick(object sender, RadMenuEventArgs e)
        {
            if (e.Item.Text=="Sort Ascending")
            {
                //custom code here
            }
        }

Greetings,
Pavlina
the Telerik team

[Dee]

Pavlina,

Thanks for the reply, I will try that.

How can I find out the column name on which the Sort Ascending header item was clicked? 

protected void HeaderContextMenu_ItemClick(object sender, RadMenuEventArgs e)
        {
            if (e.Item.Text=="Sort Ascending")
            {
                // How can I find out the column name here?
            }
        }

Also,  already have  AllowNaturalSort="false" but the header context menu still does a client side sort when I click Sort Ascending item on the header. How can I prevent that?

Thanks,
Dee

[Pavlina]

Hello Dee,

You can use the code snippet below to find the column on which the Sort Ascending was clicked:

if (e.Item.Text=="Sort Ascending")
{
    string columnName = e.Item.Attributes["columnUniqueName"];
    //get instance to the column from the respective GridTableView
    GridColumn gridColumn = RadGrid1.MasterTableView.GetColumnSafe(columnName);
}

Give it a try and let me know how it goes.

Kind regards,
Pavlina
the Telerik team

[Pavlina]

Hello Dee,

You can use the code snippet below to find the column on which the Sort Ascending was clicked:

if (e.Item.Text=="Sort Ascending")
{
    string columnName = e.Item.Attributes["columnUniqueName"];
    //get instance to the column from the respective GridTableView
    GridColumn gridColumn = RadGrid1.MasterTableView.GetColumnSafe(columnName);
}

Give it a try and let me know how it goes.

Kind regards,
Pavlina
the Telerik team

[Rob]

I am trying to make this work on a grid with multiple GridImageColumns and a GridTemplateColumn.

The following line always resolves into an empty string for all columns:
 string columnName = e.Item.Attributes["columnUniqueName"];  

Using
string columnName = e.Item.Attributes["ColumnName"];
will resolve a name for the simpler GridBoundColumns, but not my image or template columns.

Is there something I'm missing or has the most recent answer on this thread become dated?