DataView::RowFilter Property
.NET Framework (current version)
Gets or sets the expression used to filter which rows are viewed in the DataView.
Assembly: System.Data (in System.Data.dll)
public: property String^ RowFilter { virtual String^ get(); virtual void set(String^ value); }
Property Value
Type: System::String^A string that specifies how rows are to be filtered. For more information, see the Remarks section.
To form a RowFilter value, specify the name of a column followed by an operator and a value to filter on. The value must be in quotation marks. For example:
"LastName = 'Smith'"
See the Expression property of the DataColumn class for more information.
To return only those columns with null values, use the following expression:
"Isnull(Col1,'Null Column') = 'Null Column'"
.NET Framework
Available since 1.1
Available since 1.1
Show: