Initial sorting

[Dmitry]

Hello,
I want to make an initial sorting when grid is loaded first but, when I press column header to sort, I want to dismiss initial sorting expressions and follow the grid default sorting procedures. Is that possible? I already know how to sort programmatically but I cannot correctly remove sorting expressions when I don't need them.
Thank you.

[Shinu]

Hello Dmitry,

You can clear the initial sorting expression in PreRender event as shown below.
C#:

protected void RadGrid1_PreRender(object sender, EventArgs e)
{
 GridSortExpression expression = new GridSortExpression();
 expression.FieldName = "ColumnUniqueName";
 expression.SortOrder = GridSortOrder.None;
 RadGrid1.MasterTableView.SortExpressions.AddSortExpression(expression);
}

Thanks,
Shinu.

[Dmitry]

Hello Shinu,
Thank you for reply but I'm not sure how sort expression can be cleared by adding new expression, and moreover, when all expressions have already been applied?

[Dmitry]

Hello,
Any workaround please?

[Dmitry]

Hello,
Can anybody please help me with this issue?

[Dmitry]

Is anyone responding on this forum?

[Sebastian]

Hello Dmitry,

What Shinu proposed it to set GridSortOrder.None for the initially sorted grid column (you need to replace  'ColumnUniqueName' with the unique name of the actual column). Thus when you modify the SortExpressions collection of the grid, the initially applied sort expression will be cleared. Probably the more appropriate place would be to do that intercepting the OnDataBound event of the grid instead of its PreRender event.

Another approach would be to clear the SortExpressions collection each time a new sort expression is applied, to reflect solely the last sort order chosen by the user. For more information please refer to this help article.

Regards,
Sebastian
the Telerik team

[Dmitry]

Thank you for reply.
I tried to do what Shinu have proposed but this works as follows:
1. Grid loads with initial sorting (code below)
2. I click any column header to sort it. Sort will not change and predefined sorting will still apply
3. I click the same column header again and THIS time it will sort as it should.
Below is code I use. It's all in Grid_DataBound event handler.
What am I doing wrong?

UPD. I made a mistake, sorry. When I click column header 1st time, all sorting will be cleared but new sorting order will not apply.
UPD2. Sorry again. Both issues are right in my case. I cannot say, why sometimes it will clear initial sorting, and why sometimes it will not.

 if (!Page.IsPostBack)
            {
                foreach (var sortExpression in _columnBuilder.SortExpressions)
                {
                    MasterTableView.SortExpressions.AddSortExpression(sortExpression);
                }
            }
            else
            {
                GridSortExpression expression = new GridSortExpression
                                                    {
                                                        FieldName = "id", 
                                                        SortOrder = GridSortOrder.None
                                                    };
                MasterTableView.SortExpressions.AddSortExpression(expression);
            }

[Dmitry]

Solution was simple.
In ItemCommand handler:

switch (e.CommandName)
            {
                case SortCommandName:
                    MasterTableView.SortExpressions.Clear();
                    break;
            }

Thank you.