I have GridNumericColumn:
and Polish locale settings on my PC (comma as decimal separator)
When I type "1,2" in filter i get System.Data.EntitySqlException.
I can't type "1.2" in filter to test if it works.
When I use integer values like "1" filter works without errors.
<telerik:GridNumericColumn DataField="CostLimit" HeaderText="Limit" SortExpression="CostLimit" UniqueName="CostLimit" />When I type "1,2" in filter i get System.Data.EntitySqlException.
I can't type "1.2" in filter to test if it works.
When I use integer values like "1" filter works without errors.
1 Answer, 1 is accepted
0
Hello,
Generally the GridNumericColumn uses internally a RadNumericTextBox which holds a double value. This value is not culture related and is being passed to the filter expression build by the control. Generally such a problem like the described may occur when the ASP.NET server culture settings differ from that of the SQL server. Could you ensure that this is not the case? Additionally please check the corresponding decimal separator in the PC's Regional and Language settings. In attachments you can find a sample website which I have tested in order to determine whether the problem lies in the grid implementation.
Regards,
Angel Petrov
Telerik
Generally the GridNumericColumn uses internally a RadNumericTextBox which holds a double value. This value is not culture related and is being passed to the filter expression build by the control. Generally such a problem like the described may occur when the ASP.NET server culture settings differ from that of the SQL server. Could you ensure that this is not the case? Additionally please check the corresponding decimal separator in the PC's Regional and Language settings. In attachments you can find a sample website which I have tested in order to determine whether the problem lies in the grid implementation.
Regards,
Angel Petrov
Telerik
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 the blog feed now.