XpoDataSource.DefaultSorting Property

Specifies how data source contents are sorted by default, when sort order is not specified by the bound control.

Namespace: DevExpress.Xpo

Assembly: DevExpress.Xpo.v24.1.dll

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

Declaration

C#

[DefaultValue("")]
public string DefaultSorting { get; set; }

VB.NET

<DefaultValue("")>
Public Property DefaultSorting As String

Property Value

Type	Default	Description
String	String.Empty	A String object which contains the names of the columns against which data source contents are sorted.

Remarks

This property accepts a string containing a column name followed by the sort order - “ASC” (ascending) or “DESC” (descending).

C#

dataSource.DefaultSorting = "UnitPrice DESC";

VB.NET

dataSource.DefaultSorting = "UnitPrice DESC"

Columns are sorted ascending by default - “ASC” can be omitted.

C#

dataSource.DefaultSorting = "Name";

VB.NET

dataSource.DefaultSorting = "Name"

Multiple columns can be separated by semicolons.

C#

dataSource.DefaultSorting = "UnitPrice DESC; Name";

VB.NET

dataSource.DefaultSorting = "UnitPrice DESC; Name"