We as using Telerik Ajax ASP.NET control version 2009.1.402.35.
We have a requirement whether we need to show some numeric values and perform filtering on them with respect to Browser Language selected.
The first part that is fomatting of data displayed in Grid column is working file and we get the approapiate Group seperator and Decimal seperator.Below is the code which i have used
<
telerik:GridNumericColumn DataField="MyField" HeaderText="My Numeric Data" UniqueName="MyNumericData"
Resizable="true" HeaderTooltip="Sort by 'My Numeric Data'" DataType="System.Double" DataFormatString="{0:##,###0.00}" ItemStyle-HorizontalAlign="Right" FilterControlWidth="75%" HeaderStyle-Width="10%">
</telerik:GridNumericColumn>
This part is working fine and my data is formatted automatically when i change the Browser Language.
But filter on that data is leading to issue.
As this is numeric column while perfoming filtering i am only allowed to enter the numeric value with culture specific decimal seperator , which is great.But when i perform the search it does not work except for ENGLISH(EN-US).So if i select Germany the same filter operation is failing.
Is this a bug in Telerik and is there any workaround for this.
Regards,
Aayam
1 Answer, 1 is accepted
The behavior which you described is normal and expected. The reason for it is, that the control will match the value entered by the user, to the value in the database. One possible option in this case would be to intercept the ItemCommand event, and verify the value(s) entered by the user. This may include replacing a dot separator by a comma, or vice versa.
I hope this suggestion gets you started properly.
Greetings,
Yavor
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.