C1DataColumn.FilterOperator Property

Gets or sets the operator that is used for a filter expression.

[Visual Basic]

Public Property FilterOperator As String

[C#]

public string FilterOperator {get;set;}

[Delphi]

public property FilterOperator: String read get_FilterOperator write set_FilterOperator;

Remarks

Leaving this property at it's default state uses the "=" operator for all expressions except for strings. String data types use the Like operator for example:

CustName like "john*"

If you define an operator for string type columns, no wildcards are inserted into the filter. For example if you set the FilterOperator to "=" then the above sample would filter as:

CustName = "john"

Example

The following code uses the FilterOperator property to filter the expression Like:

· Visual Basic

Me.C1TrueDBGrid1.Columns(0).FilterOperator = "Like"

· C#

this.c1TrueDBGrid1.Columns[0].FilterOperator = "Like";

· Delphi

Self.C1TrueDBGrid1.Columns[0].FilterOperator := 'Like';