BetweenOperator Class

An operator which determines whether a criteria expression lies between the specified range of values.

Namespace: DevExpress.Data.Filtering

Assembly: DevExpress.Data.v18.2.dll

Declaration

C#

public sealed class BetweenOperator :
    CriteriaOperator

VB.NET

Public NotInheritable Class BetweenOperator
    Inherits CriteriaOperator

Related API Members

The following members return BetweenOperator objects:

• BetweenOperator.Clone()

Remarks

The BetweenOperator can be used to build criteria expressions when filtering objects. To learn more, see Creating Criteria and Criteria Operators.

To create a between operator, create a new instance of the BetweenOperator class. The constructor’s parameters allow the lower and upper values in the range to be specified.

Note

The upper and lower values in the range are included in the range.

Example

This sample code selects customers who are older than 20 years and younger than 30.

The image below shows the result:

C#

using DevExpress.Xpo;
using DevExpress.Data.Filtering;

// ...

CriteriaOperator filter = new BetweenOperator("Age", 20, 30);
xpCustomers.Filter = filter;

VB.NET

Imports DevExpress.Xpo
Imports DevExpress.Data.Filtering

' ...

Dim filter As CriteriaOperator = New BetweenOperator("Age", 20, 30)
XpCustomers.Filter = filter

Related GitHub Examples

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

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#

XDL_how-to-delete-all-criteria-corresponding-to-a-particular-field-from-criteriaoperator-e3396/CS/PatchCriteriaExample/Filtering/CriteriaPatcherSkipProperties.cs#L34

public override CriteriaOperator Visit(BetweenOperator theOperator) {
     theOperator = (BetweenOperator)base.Visit(theOperator);

VB.NET

XDL_how-to-delete-all-criteria-corresponding-to-a-particular-field-from-criteriaoperator-e3396/VB/PatchCriteriaExample/Filtering/CriteriaPatcherSkipProperties.vb#L51

End Function
Public Overrides Function Visit(ByVal theOperator As BetweenOperator) As CriteriaOperator
    theOperator = CType(MyBase.Visit(theOperator), BetweenOperator)

Inheritance

Object

CriteriaOperator

BetweenOperator