ASPxGridBehaviorSettings.SortMode Property

Specifies how the control sorts its data.

Assembly : DevExpress.Web.v25.2.dll

Declaration

C#
VB.NET

csharp

[DefaultValue(ColumnSortMode.Default)]
public ColumnSortMode SortMode { get; set; }

<DefaultValue(ColumnSortMode.Default)>
Public Property SortMode As ColumnSortMode

Property Value

Type	Default	Description
ColumnSortMode	Default

One of the ColumnSortMode enumeration values.

Available values:

Name	Description
Default

The actual sort mode is determined by a control. See the property description for more details.

| | Value |

Sorts the column’s data by the column’s edit values (these are synchronized with the bound data source’s values).

| | DisplayText |

Sorts the column’s data by the column’s display text (the strings displayed within the column’s cells).

| | Custom |

Applies sort options specified in the CustomColumnSort event handler.

In data grids, this mode also applies group options from the CustomColumnGroup event handler.

Remarks

Specify the SortMode property to define the control’s sort algorithm. When the grid’s SortMode property is set to Default, the control applies the Value sort algorithm.

To apply custom sort settings to the grid control, follow the steps below:

Set the SortMode property to Custom.
Handle the ASPxGridView.CustomColumnSort, ASPxCardView.CustomColumnSort, or ASPxVerticalGrid.CustomRowSort event.

At the column level, use the GridDataColumnSettings.SortMode property to specify how the control sorts data in a particular column (a row for ASPxVerticalGrid).

For more information on the sort mode in a particular control, refer to the following topics:

Example

The example below sorts data in the grid by character length.

ASPX

aspx

<dx:ASPxGridView ID="grid" runat="server" OnCustomColumnSort="grid_CustomColumnSort">
    <%--...--%>
    <SettingsBehavior SortMode="Custom" />
</dx:ASPxGridView>

C#
VB.NET

csharp

protected void grid_CustomColumnSort(object sender, DevExpress.Web.CustomColumnSortEventArgs e) {
    e.Handled = true;
    string s1 = e.Value1.ToString(), s2 = e.Value2.ToString();
    if(s1.Length > s2.Length)
        e.Result = 1;
    else
        if(s1.Length == s2.Length)
        e.Result = Comparer.Default.Compare(s1, s2);
    else
        e.Result = -1;
}

Protected Sub grid_CustomColumnSort(ByVal sender As Object, ByVal e As DevExpress.Web.CustomColumnSortEventArgs)
    e.Handled = True
    Dim s1 As String = e.Value1.ToString(), s2 As String = e.Value2.ToString()

    If s1.Length > s2.Length Then
        e.Result = 1
    ElseIf s1.Length = s2.Length Then
        e.Result = Comparer.[Default].Compare(s1, s2)
    Else
        e.Result = -1
    End If
End Sub

Online Demos

Run Demo: ASPxGridView - Sort Data

Run Demo: ASPxCardView - Sorting

Run Demo: ASPxVerticalGrid - Sorting