Hi There!

I'm on .NET framework 1.1 with .NET framework SP1. My OS is Windows XP with
SP2.

I have the RowFilter property of the DataView set to...

"[column_one] <= 2 AND [column_two] >= 4"

But I didn't get the filtered result set, instead I get all the results from
the table unfiltered. So I checked the DataView.RowFilter property
immediately after I set the filter and it return "True" instead of the
filter condition "[column_one] <= 2 AND [column_two] >= 4".

However, if I set the condition to just "[column_one] <= 2", then it works.
Only when I do multiple conditions, it changes the RowFilter to "True" and
return all the rows from the table without filtering.

What I'm missing here?

Thank you all in advance!!!
MK

Forget it, I found the error. Forgot to put the double quotes on literal
strings :P

MK

"Mike Kline" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi There!
>
> I'm on .NET framework 1.1 with .NET framework SP1. My OS is Windows XP
> with SP2.
>
> I have the RowFilter property of the DataView set to...
>
> "[column_one] <= 2 AND [column_two] >= 4"
>
> But I didn't get the filtered result set, instead I get all the results
> from the table unfiltered. So I checked the DataView.RowFilter property
> immediately after I set the filter and it return "True" instead of the
> filter condition "[column_one] <= 2 AND [column_two] >= 4".
>
> However, if I set the condition to just "[column_one] <= 2", then it
> works. Only when I do multiple conditions, it changes the RowFilter to
> "True" and return all the rows from the table without filtering.
>
> What I'm missing here?
>
> Thank you all in advance!!!
> MK
>

Here's an example where I use multiple conditions as well as functions in
them http://www.knowdotnet.com/articles/a...rowfilter.html
Can you show the actual value you're using?

--
W.G. Ryan MVP (Windows Embedded)

TiBA Solutions
www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Mike Kline" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> Hi There!
>
> I'm on .NET framework 1.1 with .NET framework SP1. My OS is Windows XP
with
> SP2.
>
> I have the RowFilter property of the DataView set to...
>
> "[column_one] <= 2 AND [column_two] >= 4"
>
> But I didn't get the filtered result set, instead I get all the results
from
> the table unfiltered. So I checked the DataView.RowFilter property
> immediately after I set the filter and it return "True" instead of the
> filter condition "[column_one] <= 2 AND [column_two] >= 4".
>
> However, if I set the condition to just "[column_one] <= 2", then it
works.
> Only when I do multiple conditions, it changes the RowFilter to "True" and
> return all the rows from the table without filtering.
>
> What I'm missing here?
>
> Thank you all in advance!!!
> MK
>
>