Filter Table

Applies a filter on a DataTable and returns the resulting DataTable.

Designer Properties

1. Data Table The DataTable to be filtered at runtime.
2. Filter The filter to be applied to the DataTable. For more details on the filter please check the following urls:
   • https://www.csharp-examples.net/dataview-rowfilter/
   • https://docs.microsoft.com/en-us/dotnet/api/system.data.dataview.rowfilter?view=net-5.0
   • https://docs.microsoft.com/en-us/dotnet/api/system.data.datacolumn.expression?redirectedfrom=MSDN&view=netframework-4.8#System_Data_DataColumn_Expression

Properties

Data

See Designer Properties above.

General Properties

See General Properties.

Misc

See Misc.

Out Error

See Out Error.

Example

Amazon Reviews with filter

In this example, we open an amazon product page and extracts all the negative reviews to a csv file. We use Filter Data Table to filter all rows without a name. In this way we remove all empty rows.

Below we have the edit DataTable dialog after running the above example with filter.