Sorting Modes and Custom Sorting
- 2 minutes to read
#Overview
The DXGrid for Silverlight supports data sorting by cell values and display text. For each column, you can specify how its data should be sorted - by either edit or display values, or by using custom logic. To specify the required sort mode, use the ColumnBase.SortMode property.
Sorting by Edit Values (Default)
Sorts a column's data by its edit values. To enable this mode, set the ColumnBase.SortMode property to ColumnSortMode.Value.
Sorting by Display Text
Sorts a column's data by its display text (the strings displayed within data cells). To enable this mode, set the ColumnBase.SortMode property to ColumnSortMode.DisplayText.
Custom Sorting
Enables you to implement custom sorting rules. To do this, handle the GridControl.CustomColumnSort event. To enable this mode, set the ColumnBase.SortMode property to ColumnSortMode.Custom.
#Custom Sorting
To sort column values using custom logic, set a column's ColumnBase.SortMode property to ColumnSortMode.Custom and handle the GridControl.CustomColumnSort event.
When this event is fired, two rows should be compared. The column being processed is specified by the Column parameter. The Value1 and Value2 parameters identify the values of the rows within this column. The result of the custom comparison should be set to the Result parameter as follows.
- -1 if the first row should be positioned above the second row when data is sorted in ascending order. When data is sorted in descending order, the first row will be positioned below the second row.
- 1 if the first row should be positioned below the second row when data is sorted in ascending order. When data is sorted in descending order the first row will be positioned above the second row.
- 0 to indicate that the rows are equal. In this case, rows will be arranged within a View according to their indices in a data source.
The event parameter's Handled property should be set to true if the comparison operation was handled. You can leave this parameter set to false to invoke the default comparison mechanism after your event handler has finished. In this instance, the custom comparison operation's result is ignored.