[Solved] Sortingmodes

[Fredrik]

Hi.

I'm having a problem with sorting. I want my grid to always be sorted in either ascending or descending order. Is there any way to disable the grids unsorted state (so that Gridstate.Orderby is never null)?

Thank you

[Derek Trickett]

Wondering the same thing - is there any way to disable the unsorted step in the toggle cycle?  Would like to set the default sort to ascending or descending depending on requirement, then have the header toggle back and forth between ascending and descending.

[Atanas Korchev]

Hello,

 No, this is not currently possible. The grid always goes through the unsorted mode. We have it logged as a feature request and will implement that in a future release (probably Q1 2012).

Regards,
Atanas Korchev
the Telerik team

[Bill]

Atanas, others,

There is an easy way to do this and you wont have to wait until the Q1 2012 release. 

1. Add this javascript

<script type="text/javascript">
   function onDatabinding(e) {
        var grid = $('#UserGrid').data('tGrid'); //change UserGrid to your grid name
        if (grid.orderBy == "")
        { grid.orderBy = 'LoginId-asc'; }; //change LoginId to your column name
    }
</script>

2. Subscibe to databound event and set default order for your grid

            .ClientEvents(o => o.OnDataBinding("onDatabinding"))
            .Sortable(sorting => sorting
                .OrderBy(initSortOrder => initSortOrder.Add(o => o.LoginId).Ascending())) //change LoginId to your column name

Its that easy.  Note that I am databinding ajax with operation mode server, so if your setup is different, this solution may not work.

            .DataBinding(dataBinding => dataBinding.Ajax()
                .OperationMode(GridOperationMode.Server)  //[.Server|.Client]

[Fredrik]

Thanks. I'll try it out as soon as I get the time. I think it should be compatible with my setup.

[Varun]

Thanks much!