[C#]2nd Filter is overriding the 1st One.

[vern021]

I'm working on my project and this is the last thing that I need to fix. I need to filter products based on the selected supplier. The problem comes in my filter(see below).

 

 

dv.RowFilter = "SupplierName= '" + stcSalesInv.SuppSearch + "'";

dv.RowFilter = fieldName1 + " " + filterOption1 + searchText1 + " OR " + fieldName2 + " " + filterOption2 + searchText2;

 

When I use this one, the second statement overrides the first one.

 

 

dv.RowFilter = fieldName1 + " " + filterOption1 + searchText1 + " OR " + fieldName2 + " " + filterOption2 + searchText2;

dv.RowFilter = "SupplierName= '" + stcSalesInv.SuppSearch + "'";

 

same problem here.

 

Any suggestions?

(Note: I might not reply immediately because I'll be inactive in a few mins/hrs)

[r3bify]

Could it be that you are overwriting your filters with the second one? Your second line replaces the first one, or so it seems here. 

Change the second line in both scenarios to "+=" instead of "="?

[vern021]

Could it be that you are overwriting your filters with the second one? Your second line replaces the first one, or so it seems here. 

Change the second line in both scenarios to "+=" instead of "="?

I've solved it. I combined it using the "AND" statement. Thanks for the help tho. ^-^