I am using a RadNumericTextbox in a DetailsView control to display a decimal value coming from a SQL query.
The original value from the database is "23,3000" with decimal type.
When displayed in a conventional ASP Textbox, the value is correctly displayed, even when I use:
Text='<%# Convert.ToDecimal(Eval("PriceInclTax")) %>'
When I pass exactly the same value to the RadNumericTextbox, I always get the value "233000" as an integer.
I am using the following code in aspx:
<telerik:RadNumericTextBox ID="PriceInclTaxTextBox" runat="server" Value='<%# Convert.ToDecimal(Eval("PriceInclTax")) %>' NumberFormat-DecimalDigits="4"></telerik:RadNumericTextBox>
I tried to change the Culture, NumberFormat-DecimalDigits, NumberFormat-GroupSeparator, NumberFormat-DecimalSeparator and Datatype parameters but with no luck. Another aproach was to divide the result by 10000, but only dividing by 1000 is showing the "comma" in the original value as "233,0000". Dividing by 10000 has the same result as dividing by 1000.