sort in descending order

[Ryann]

hi.
I want the sorting to sort in descending order first rather than ascending which is the default behaviour.

[Princy]

Hi Ryann,

Please try the following code snippet to have sorting in descending order at first.

C#:

protected void RadGrid1_SortCommand(object sender, GridSortCommandEventArgs e)
{
    GridSortExpression sortExpr = new GridSortExpression();
    switch (e.OldSortOrder)
    {
        case GridSortOrder.None:
            sortExpr.FieldName = e.SortExpression;
            sortExpr.SortOrder = GridSortOrder.Descending;
            e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr);
            break;
        case GridSortOrder.Ascending:
            sortExpr.FieldName = e.SortExpression;
            sortExpr.SortOrder = RadGrid1.MasterTableView.AllowNaturalSort ? GridSortOrder.None : GridSortOrder.Descending;
            e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr);
            break;
        case GridSortOrder.Descending:
            sortExpr.FieldName = e.SortExpression;
            sortExpr.SortOrder = GridSortOrder.Ascending;
            e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr);
            break;
    }

    e.Canceled = true;
    RadGrid1.Rebind();

    if (!e.Item.OwnerTableView.SortExpressions.ContainsExpression(e.SortExpression))
    {
        sortExpr.FieldName = e.SortExpression;
        sortExpr.SortOrder = GridSortOrder.Ascending;
        e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr);
    }
}

Thanks,
Princy