How to: Sort Data Against Two or More Columns

• Nov 13, 2018

The following example sorts data by two columns in a Grid View. The code is enclosed within calls to the ColumnView.BeginDataUpdate and BaseView.EndDataUpdate methods. This speeds up performance by sorting the data only once, after the BaseView.EndDataUpdate method is called.

C#

    gridView1.BeginDataUpdate();
    try {
        gridView1.ClearSorting();
        gridView1.Columns["Trademark"].SortOrder = DevExpress.Data.ColumnSortOrder.Ascending;
        gridView1.Columns["Model"].SortOrder = DevExpress.Data.ColumnSortOrder.Ascending;
    }
    finally {
        gridView1.EndDataUpdate();
    }

VB.NET

    gridView1.BeginDataUpdate()
    Try
        gridView1.ClearSorting()
        gridView1.Columns("Trademark").SortOrder = DevExpress.Data.ColumnSortOrder.Ascending
        gridView1.Columns("Model").SortOrder = DevExpress.Data.ColumnSortOrder.Ascending
    Finally
        gridView1.EndDataUpdate()
    End Try