This is a migrated thread and some comments may be shown as answers.

Filter and case sensitive

5 Answers 64 Views
Grid
This is a migrated thread and some comments may be shown as answers.
rtk
Top achievements
Rank 1
rtk asked on 19 Sep 2008, 02:06 PM
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

5 Answers, 1 is accepted

Sort by
0
Vlad
Telerik team
answered on 19 Sep 2008, 02:29 PM
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.
0
rtk
Top achievements
Rank 1
answered on 19 Sep 2008, 03:16 PM
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.
0
Vlad
Telerik team
answered on 19 Sep 2008, 03:20 PM
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.
0
rtk
Top achievements
Rank 1
answered on 21 Sep 2008, 09:27 PM
Thank you, works fine.
0
Kabir
Top achievements
Rank 1
answered on 16 Oct 2008, 11:18 PM
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.
Tags
Grid
Asked by
rtk
Top achievements
Rank 1
Answers by
Vlad
Telerik team
rtk
Top achievements
Rank 1
Kabir
Top achievements
Rank 1
Share this question
or