Hi, one table with two columns is data source of binding source. We want to filter data first my “Name”, and after that by “City”.
Name
City
John
London
New York
Jim
bindingSource.Filter="Name = 'John'";
Result:
If another filter is applied (WITHOUT bindingSource.RemoveFilter())
bindingSource.Filter="City = 'London'";
My question is: If once binding source is filtered and filter is not removed, why second filter is not applied only on already filtered data?
if first filter filtered data once and is applied second filter on filtered data why we have not situation like
bindingSource.Filter="Name ='John' AND City = 'London'";