GridColumn.SortMode Property

Gets or sets how the column's data are sorted/grouped.

Namespace: DevExpress.XtraGrid.Columns

Assembly: DevExpress.XtraGrid.v20.1.dll

Declaration

[DXCategory("Data")]
[DefaultValue(ColumnSortMode.Default)]
[XtraSerializableProperty]
[XtraSerializablePropertyId(2)]
public ColumnSortMode SortMode { get; set; }
<DXCategory("Data")>
<DefaultValue(ColumnSortMode.Default)>
<XtraSerializableProperty>
<XtraSerializablePropertyId(2)>
Public Property SortMode As ColumnSortMode

Property Value

Type Default Description
ColumnSortMode

Default

The sort mode for column data.

Remarks

The SortMode property determines the algorithm used to sort the column data (by display text, by edit value, or using a custom sort algorithm).

To provide custom sorting and/or grouping, set the SortMode property to ColumnSortMode.Custom and handle the ColumnView.CustomColumnSort and GridView.CustomColumnGroup events. See the ColumnSortMode topic for details on other available sorting modes.

To apply sorting to a column, the column's GridColumn.SortOrder property can be set to ColumnSortOrder.Ascending or ColumnSortOrder.Descending. This will arrange the column values in ascending or descending order using the algorithm specified by the SortMode property.

NOTE

In server mode, don't use the SortMode property to enable data sorting and grouping by display values. Use the GridColumn.FieldNameSortGroup property instead.

See the Custom sorting module demo which shows how to sort a string column with decimal values.


    // Custom Column Sorting            
    GridColumn column = gridView.Columns["Length"];
    column.SortMode = ColumnSortMode.Custom;
    gridView.CustomColumnSort += (sender, e) => {
        // Always show 0 at the bottom
        if (e.Column.FieldName == "Length") {
            if ((double)e.Value1 == 0 && (double)e.Value2 != 0) {
                e.Result = e.SortOrder == ColumnSortOrder.Ascending ? 1 : -1;
            }
            else if ((double)e.Value2 == 0 && (double)e.Value1 != 0) {
                e.Result = e.SortOrder == ColumnSortOrder.Ascending ? -1 : 1;
            }
            else {
                // default comparison
                e.Result = Comparer.Default.Compare(e.Value1, e.Value2);
            }
            e.Handled = true;
        }
    };
    column.SortOrder = ColumnSortOrder.Ascending;
See Also