ComponentOne ADO.NET DataExtender
C1.C1DataExtender.2 Assembly / C1.C1DataExtender Namespace / C1DataView Class / RowFilter Property

In This Topic
    RowFilter Property
    In This Topic
    Gets or sets an expression used to filter rows in C1DataView.
    Syntax
    '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.
    See Also