Hello. I have RadGrid with EntityDataSource. When I filter grid by column where expression is generated like :
where it.someValue = 'unicode text'
but it should be like
where it.someValue = N'unicode text'
Is there a way to make it work?
thanks in advance
3 Answers, 1 is accepted
0
Marin
Telerik team
answered on 17 Feb 2012, 09:53 AM
Hi,
If you need to modify the filter expressions prior to filtering you can do this in the in the ItemCommand event as shown in this help topic.
Greetings,
Marin
the Telerik team
Sharpen your .NET Ninja skills! Attend Q1 webinar week and get a chance to win a license! Book your seat now >>
Is there any simple way for grid to know that specific column is in unicode so that where text would be
"([CustomerID] LIKE N'%ALFKI%')";
instead of "([CustomerID] LIKE '%ALFKI%')";
0
Marin
Telerik team
answered on 24 Feb 2012, 06:38 PM
Hi,
The grid does not automatically generate the filter expression based on the unicode type of the column. That's why you can modify it in the ItemCommand event and simple add the additional (N) to the filter expression as I specified in the my previous post.
All the best,
Marin
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.