[Solved] Case-Insensitive Search and Paging

[Intro]

Dear Support Team,

We are using LinqDataSource to populate a grid using version Q2 2008. The grid needs linqExpressions to be set to true for paging; however this leads to case-sensitive search. Setting GroupingSettings->CaseSensitive:=false did not work either.

The proposed solutions in the thread: Filter is case-sensitive did not work Can you please suggest a solution to overcome this problem.

Best Regards,
Oner

P.S. Following is the settings for the grid:

<telerik:RadGrid runat="server" ID="RadGrid1"

PagerStyle-Position="TopAndBottom"

EditItemStyle-BackColor="#ccff99" Skin="Hay" GridLines="Vertical"

DataSourceID="LinqDataSource1"

AllowFilteringByColumn="True"

ClientSettings-AllowColumnsReorder="True"

AllowSorting="True"

AutoGenerateColumns="False"

AllowPaging="True" PageSize="20"

ShowStatusBar="True"

OnItemCommand="RadGrid1_ItemCommand"

OnItemCreated="RadGrid1_ItemCreated"

OnItemDataBound="RadGrid1_ItemDataBound"

OnUpdateCommand="RadGrid1_UpdateCommand"

OnInsertCommand="RadGrid1_InsertCommand"

OnItemUpdated="RadGrid1_ItemUpdated"

OnItemInserted="RadGrid1_ItemInserted"

OnPreRender="RadGrid1_PreRender"

EnableLinqExpressions="True">

<PagerStyle Mode="NextPrevAndNumeric" />

<GroupingSettings CaseSensitive="false" />

[Vladimir]

Hi Oner,

You can try the application in my last reply - the filter is not case sensitive.

Vlad

[Intro]

Hi Vlad,

The posted web site works perfectly.

However, when we changed the code to use the caching technique described in Boosting Performence with LINQ;grid behaves as described in the previous post. (Telerik.Web.UI.dll in the web site has been updated from Bin35 folder of Q2 2008 release.)

In the modified web site, when EnableLinqExpressions is set to true:

• Paging works normally,
• Filters are case sensitive,
• Filtering in Region column throws exception.

When EnableLinqExpressions is set to false:

• Paging does not work,
• Filters are case sensitive (In our grid, filters are case-insensitive),
• Filtering in Region works normally.

Can you please suggest a solution to overcome this issue ?

Thanks,
Oner

[Nikolay Rusev]

Hello oner,

Thank you for pointing us this issue.

Unfortunately we need to investigate the matter in detail in order to provide a solution. For now if you are using RadGrid with Linq expressions enabled and cash its the data source, you will not be able to perform case-insensitive filtering.

I hope this is applicable workaround for you. I updated your Telerik points for the report.

Kind regards,
Nikolay
the Telerik team

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

[Greg]

Any progress on resolving this issue? It has been a month.

Note that more and more developers are switching to LINQ and need the flexibility of case insensitive filtering while using LINQ results.

Thanks.

[Intro]

Hi,

How is the work on this problem going, is there any progress ? Speedy resolution will be appreciated as this is a basic issue with grids.

Thanks,
Oner

[Vlad]

Hi oner,

The problem is fixed and the fix will part of our Q3 release (early November).

Best wishes,
Vlad
the Telerik team

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

[Intro]

Hi Vlad,

Thanks for the good news.

Best Regards,
Oner