Implement Insensitive Diacritic Filtering for RadGrid

Hi!

I tried this project. I noticed that if I type more than, for instance, 10 characters, the "w3wp.exe" process crashes with a 'System.StackOverflowException'.  

Any clues why this is happening?

Thanks

Hello,

I reached out to my technical team and they advised to please submit a support ticket or forum post as this is the best place for support

Best,

Matt

Hi Regula,

Sorry for not removing this sample earlier. This was an experimental attempt to achieve this scenario but it turned out that it is not possible. And this sample should have been removed long ago.

I am afraid diacritic accent-insensitive filtering for the grid is not supported. So if you have 2 or multiple different symbols for the same logical letter, this requirement won't be possible to achieve with the built-in filtering of the grid. For comparison, the combo uses a client-side JavaScipt filtering implementation so the source code can be overriden and altered to achieve this requirement:
https://www.telerik.com/support/kb/aspnet-ajax/combobox/details/combobox-filtering-with-diacritic-accents

However, I am afraid this is not possible for the grid since it uses code-behind internal filtering queries on the server-side. 

https://docs.telerik.com/devtools/aspnet-ajax/controls/grid/how-to/Filtering/operate-with-the-filterexpression-manually

Basically, you can filter the datasource manually using the values defined by the users and pass the resulting data to the grid in its NeedDataSource event handler. There is a handy COLLATE operator in the SQL arsenal for this kind of scenarios:
https://stackoverflow.com/questions/2461522/how-do-i-perform-an-accent-insensitive-compare-e-with-%C3%A8-%C3%A9-%C3%AA-and-%C3%AB-in-sql-ser

Another approach would be to add a new string field in your data source to hold "clean" values without any diacritics. Then, you can create a GridTemplateColumn with its DataField property set to "CleanField". In its ItemTemplate you can place a Label and set its Text to '<%# Eval("DiacriticsField") %>'.

Alternatively, you can create 2 columns and filter by the second column instead, which will be hidden, similar to the attached web site sample.

Also, I've updated your Telerik points for any inconvenience this might have caused you.

Regards,
Eyup
Progress Telerik

Me too: System.StackOverflowException. 

Faulting application name: w3wp.exe, version: 7.5.7601.17514, time stamp: 0x4ce7a5f8
Fault module name: System.Core.ni.dll, version: 4.8.3928.0, time stamp: 0x5d39014b
Exception code: 0xc00000fd
Failed offset: 0x002054d4
Failed process ID: 0x4694
Failed application start time: 0x01d68d4aa5fc9a09
Faulting application path: C: \ Windows \ SysWOW64 \ inetsrv \ w3wp.exe
Failure module path: C: \ Windows \ assembly \ NativeImages_v4.0.30319_32 \ System.Core \ 31fae3290fad30c31c98651462d22724 \ System.Core.ni.dll
Report ID: f423a9f5-f940-11ea-a722-082e5f82e957

Hi Roberto,

I am afraid this Code Library is no longer valid. It was an experimental attempt and didn't work properly in the long run. The main conclusion is that this feature is not related to RadGrid and cannot be handled on RadGrid level, but on the database level.

Thank you for your understanding. More information you can find on my previous reply in this thread. I am now closing this thread.

Regards,
Eyup
Progress Telerik