When you want to apply a filter to your datatable in your dataset, you can use the method Select on the class DataTable. In our current project we use this method very often, also for databinding.<\/p>\n
Recently I discover an unexpected behaviour. Let\u2019s assume, that our datatable has 4 datarows and we will apply following filter for databinding: The first expression (0=1) is added by an other method, which checks if any rows should be visible. The second expression (Path = \u2018C:\\bin\u2019) is the standard part of the filter (Yes, I know you could implement it much more simplier).<\/p>\n Now, I programmed the following NUnit-Tests:<\/p>\n <\/p>\n <\/font>\/\/0=1 -> OK <\/font>\/\/Name = ‘Component 7’ -> OK <\/font>\/\/Path -> OK <\/font>\/\/0=1 and Path (with brackets) -> OK <\/font>\/\/Name = ‘Component 7’ and Path (without brackets) -> OK <\/font>\/\/0=1 and Path (without any brackets) -> OK <\/font>\/\/0=1 and Path (without outer brackets) -> Unexpected behaviour <\/font><\/p>\n Only the last test failed. If you add around the whole expression brackets, then it works fine. Obviously the Select-Methode has a problem with expressions which doesn\u2019t operate over a column. I didn\u2019t try other expressions, but my current workarounds are remove all brackets or add an additional bracket around the whole expression.<\/p>\n","protected":false},"excerpt":{"rendered":" When you want to apply a filter to your datatable in your dataset, you can use the method Select on the class DataTable. In our current project we use this method very often, also for databinding. Recently I discover an unexpected behaviour. Let\u2019s assume, that our datatable has 4 datarows and we will apply following filter for databinding:0=1 AND Path = ‘C:\\bin’ The first expression (0=1) is added by an other method, which checks if any rows should be visible….<\/p>\n
0=1 AND Path = ‘C:\\bin’<\/font><\/p>\n
<\/font>DataRow<\/font>[] rowsComp = tabComp.Select(<\/font>“0=1”<\/font>);
<\/font>Assert<\/font>.IsNotNull(rowsComp);
<\/font>Assert<\/font>.AreEqual(0, rowsComp.Length);<\/font><\/p>\n
<\/font>rowsComp = tabComp.Select(<\/font>“(Name = ‘Component 7’)”<\/font>);
<\/font>Assert<\/font>.IsNotNull(rowsComp);
<\/font>Assert<\/font>.AreEqual(0, rowsComp.Length);<\/p>\n
<\/font>rowsComp = tabComp.Select(<\/font>@”Path = ‘C:\\bin'”<\/font>);
<\/font>Assert<\/font>.IsNotNull(rowsComp);
<\/font>Assert<\/font>.AreEqual(4, rowsComp.Length);<\/p>\n
<\/font>rowsComp = tabComp.Select(<\/font>@”((0=1) AND (Path = ‘C:\\bin’))”<\/font>);
<\/font>Assert<\/font>.IsNotNull(rowsComp);
<\/font>Assert<\/font>.AreEqual(0, rowsComp.Length);<\/p>\n
<\/font>rowsComp = tabComp.Select(<\/font>@”(Name=’Component 7′) AND (Path = ‘C:\\bin’)”<\/font>);
<\/font>Assert<\/font>.IsNotNull(rowsComp);
<\/font>Assert<\/font>.AreEqual(0, rowsComp.Length);<\/p>\n
<\/font>rowsComp = tabComp.Select(<\/font>@”0=1 AND Path = ‘C:\\bin'”<\/font>);
<\/font>Assert<\/font>.IsNotNull(rowsComp);
<\/font>Assert<\/font>.AreEqual(0, rowsComp.Length);<\/p>\n
<\/font>rowsComp = tabComp.Select(<\/font>@”(0=1) AND (Path = ‘C:\\bin’)”<\/font>);
<\/font>Assert<\/font>.IsNotNull(rowsComp);
<\/font>Assert<\/font>.AreEqual(0, rowsComp.Length);<\/p>\n