Filtering function not working fine for Equal

[soo]

Hi,

My filtering function in radgrid not working fine. I'm using advanced data binding function. When i want filter by equal, it cant get the result that i want.
Let say i want filter by "3" using Equal To, inside my grid got two "3" records, but when i do filter by using "equal to", it returns no record. While if i do filter by "contains" it will returns me 2 records.

Please advice.

May i know is it possible to do trim function during filtering??

Thanks.

Regards,
Soo

[Shinu]

Hi Soo,

Can you check the DataType of the field that you have set in the DataBase.Try setting the DataType to int and see whether it is working or not.

Shinu.

[soo]

Hi Shinu,

The datatype of this field is varchar(25). If datatype is integer, it will not have this problem. So, may i know have any solution for this if the datatype is varchar?

Please help!
Thanks.

Regards,
Soo

[Shinu]

Hi Soo,

I tried with both DataType(int and varchar) and it is working fine in both the cases. The only difference is that in the case of int the FilterMenuOptions will be reduced(Contains, StartsWith etc will not be there). But when I used varchar filter menu options such as Contains and EqualTo worked as expected. Which version of the Grid you are using?

Thanks
Shinu.

[soo]

Hi Shinu,

Thanks of your help!

The filtering works well already.

Regards,
Soo