SelectQuery.Skip Property

Specifies the number of rows to skip in a returned query result set.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v18.1.dll

Declaration

C#

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

VB.NET

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

Property Value

Type	Default	Description
Int32	0	A non-negative integer value, specifying the number of rows to skip in a returned query result set (starting with the first data record).

Remarks

Before specifying the Skip property, the query result set should be sorted by one of the columns (using the SelectQuery.Sorting property).

To specify the number of rows to return after skipped rows, use the SelectQuery.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 Skip 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#L42

SelectQuery selectQuery = query as SelectQuery;
if (selectQuery != null && selectQuery.Tables.Count == 1 && selectQuery.Columns.Count == 1 && string.IsNullOrEmpty(selectQuery.FilterString) && selectQuery.Skip == 0) {
    var columns = selectQuery.Columns[0] as AllColumns;

VB.NET

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

Dim selectQuery As SelectQuery = TryCast(query, SelectQuery)
If selectQuery IsNot Nothing AndAlso selectQuery.Tables.Count = 1 AndAlso selectQuery.Columns.Count = 1 AndAlso String.IsNullOrEmpty(selectQuery.FilterString) AndAlso selectQuery.Skip = 0 Then
    Dim columns = TryCast(selectQuery.Columns(0), AllColumns)