ApplyAdvancedFilter Method
This method is called whenever an advanced filter (translated using the
TranslateFilterSyntax method) should be applied to the data source.
This sample demonstrates how the ApplyAdvancedFilter method is implemented for the AdoDataProvider class. The filter is directly set as RowFilter, combined with any existing filter that might have been set before.
public void ApplyAdvancedFilter(string filter, object[] parameters)
{
DataViewSetting setting = _dataView.DataViewManager.DataViewSettings[_dataView.Table.TableName];
string rowFilter = setting.RowFilter;
string effectiveFilter = filter;
if (!String.IsNullOrEmpty(rowFilter))
{
effectiveFilter = String.Format("({0}) AND ({1})", rowFilter, filter);
}
_dataView.RowFilter = effectiveFilter;
}