Filter and case sensitive

[rtk]

I just found out that filter is case sensitive if i use Contains with at string. Is it possible to do something about this?

Thanks

John

[Vlad]

Hi John,

Can you post a bit more info how the grid is bound in your case? Is it .NET 2.0 or 3.5? Let us know.

Greetings,
Vlad
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[rtk]

The grid is bound with NeedDataSource. And it's a simple "select * from tablename"

I'm using .Net 3.5 and RadControls for ASP.Net AJAX

If i have a string like "John" in my database, and use the filter option "contains",  "john" would not give me any result.

[Vlad]

Hi John,

Please set GroupingSettings.CaseSensitive and EnableLinqExpressions to false and let me know how it goes.

Greetings,
Vlad
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[rtk]

Thank you, works fine.

[Kabir]

Just ran into the same problem with my grid. I tried all of the recommendations, but none of them worked. However, I did figure out the problem. My grid is using LinqDataSource for binding, but in order to do some custom filtering, I was putting in a strongly-typed list that I retrieved from the db and setting it to the Result object in the "Selecting" event of the LinqDataSource. For whatever reason, that made filtering case sensitive. I changed my method to return an IQueryable object, and case sensitivity issue went away.

Hope this helps.