SelectQuery.Top Property

Specifies the number of rows returned in the query result set.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v18.1.dll

Declaration

C#

[TypeConverter(typeof(PositiveIntegerTypeConverter))]
[DefaultValue(0)]
[LocalizableCategory(DataAccessStringId.QueryPropertyGridTableSelectionCategoryName)]
public int Top { get; set; }

VB.NET

<LocalizableCategory(DataAccessStringId.QueryPropertyGridTableSelectionCategoryName)>
<DefaultValue(0)>
<TypeConverter(GetType(PositiveIntegerTypeConverter))>
Public Property Top As Integer

Property Value

Type	Default	Description
Int32	0	A non-negative integer value, specifying the number of selected records (starting with the first data record).

Remarks

Use the TableQuery.Sorting property to predictably indicate which rows are affected by the Top property.

The default zero value indicates that all rows are selected.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Top property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

Reporting_data-source-wizard-how-to-customize-the-standard-query-builder-dialog-t333785/CS/ReplaceQueryBuilderSample/MyConfigureQueryPage.cs#L46

    tableName = selectQuery.Tables[0].Name;
    topRecords = selectQuery.Top;
}

VB.NET

Reporting_data-source-wizard-how-to-customize-the-standard-query-builder-dialog-t333785/VB/ReplaceQueryBuilderSample/MyConfigureQueryPage.vb#L49

    tableName = selectQuery.Tables(0).Name
    topRecords = selectQuery.Top
End If