This is a migrated thread and some comments may be shown as answers.

GridNumericColumn Currency problem

1 Answer 250 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Francesco Vivaldi
Top achievements
Rank 1
Francesco Vivaldi asked on 15 Apr 2011, 12:12 PM
Hi,

i have a grid width a GridNumericColumn,  when i edit and i insert a value with comma like "12,12" and press update button on grid
i have
Format of the input string is not correct
"11,12" is not a Valid Decimal Value.

 I must use dot for separate thousand, and comma for decimal digits.

 from db i bind a list of Decimal Value, and when i edit if i use the comma for decimal digit got the Format of the input string is not correct.
the grid column.
<telerik:GridNumericColumn    NumericType="Currency" DataField="Canone"
                            FilterControlAltText="Filter Canone column" HeaderText="Canone" DecimalDigits="2"                           
                            SortExpression="Canone" UniqueName="Canone"
                            FilterImageUrl="../App_Themes/ICTTheme/immagini/u58.png">
                        </telerik:GridNumericColumn>

the radgrid is bind to ObjectDataSource, and Select Method return a list of custom object, Canone Field is Decimal.

1 Answer, 1 is accepted

Sort by
0
Tsvetina
Telerik team
answered on 20 Apr 2011, 01:34 PM
Hello Francesco,

You could try overcomig this by accessing theRadNumericTextBox editor on ItemCreated and set its NumberFormat.DecimalSeparator and NumberFormat.GroupSeparator properties to the desired chars.

Kind regards,
Tsvetina
the Telerik team

Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.

Tags
Grid
Asked by
Francesco Vivaldi
Top achievements
Rank 1
Answers by
Tsvetina
Telerik team
Share this question
or