RowFilter Property

Gets or sets an expression used to filter rows in C1DataView.

Syntax

Visual Basic
C#

'Declaration
 
Public Property RowFilter As System.String

public System.string RowFilter {get; set;}

Remarks

The syntax of filter expression is the same as for WHERE clause of Definition, with the only exception that column names should reference C1DataView columns while column names in Definition reference columns of base DataTable objects.

There are some semantic differences in the calculation of this filter condition compared to expressions used View Definition Statements:

The <match_expression> [ NOT ] LIKE <pattern_expression> [ ESCAPE <escape_character> ] comparison condition mimics the behavior of this condition in the System.Data.DataColumn.Expression, that is, supports '*' char as an alternative to standard '%' char in a matching pattern and doesn't support '_' char. In addition to DataColumn.Expression implementation it supports 'Escape' clause and allows '*' or '%' char in any place of a matching pattern. The reason for following the DataColumn.Expression behavior in RowFilter implementation is that a value of the latter property can be set by user interface control via the IBindingListView.Filter property, but user interface control usually expects the behavior specific to the DataColumn.Expression property in this case.

Reference

C1DataView Class
C1DataView Members