TableQuery.Sorting Property

Provides access to sort settings used to order the result set of the current TableQuery by the specified column(s).

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v24.1.dll

NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap

Declaration

C#

[Browsable(false)]
public SortingInfoList Sorting { get; }

VB.NET

<Browsable(False)>
Public ReadOnly Property Sorting As SortingInfoList

Property Value

Type	Description
SortingInfoList	A SortingInfoList object providing access to the collection of SortingInfo objects that specify sort settings.

Remarks

You can sort the result set by the specified column contained in the TableQuery in the following way.

1. Pass the table name, the column name and the sort order to the SortingInfo constructor.
2. Add the resulting SortingInfo object to the Sorting collection using the SortingInfoList.Add method.