Is there any way a datatable, that is populated with te colums Hdate, State1, State2, State3, etc
can be filtered with an OR condition?
The dt is populated by selecting the colums Hdate and State1, State2, State3, StateN.
If the Hdate is valid for that StateX then the StateX = "Y"
For example if the 1 July 2004 is valid for State2 then the Hdate, State1, State2, State3 would look like
1/7/2004, NULL, "Y", Null,etc
the problemm is the following filter does not just include the States selected
dtHolidays.DefaultView.RowFilter = "State1='Y' OR " + sCurrLoc + "='Y'"; where sCurrLoc is State3
the filter shows it as "State1='Y' OR State3='Y'"
but instead of the expect 12 rows returned it returns 13 rows becuase it is including State2 =Y as well.
Any ideas?
--------------------------------
From: Ian Bennett
-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)
<Id>lScPm4VI10eK8M052gaQ0Q==</Id>