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

RadNumericTextBox cannot handle properly decimal(18,2)

5 Answers 190 Views

General Discussions

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

Jacek asked on 28 Jun 2012, 10:57 AM

Hi,

I can't force following code to work, meaning the values of the decimals are multiplied by 100 and no combination of DecimalSeparator nor DecimalDigits nor Culture setting renders 5.19m as 5,19 (or 5.19 for that matter) - the result is always 519

<%@ Page Language="C#" AutoEventWireup="true" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

<title></title>

</head>

<body>

<form id="form1" runat="server">

<div>

<asp:ScriptManager runat="server" ID="ScriptManager1">

</asp:ScriptManager>

<script type="text/C#" runat="server">

protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)

{

System.Data.DataTable table = new System.Data.DataTable();

table.Columns.Add("ID", typeof(int));

table.Columns.Add("pct", typeof(decimal));

table.Rows.Add(1, 5.19m);

table.Rows.Add(2, 99.49m);

table.Rows.Add(3, 19.69m);

table.Rows.Add(4, 5.99m);

RadGrid1.DataSource = table;

}

</script>

<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="false" OnNeedDataSource="RadGrid1_NeedDataSource">

<MasterTableView>

<Columns>

<telerik:GridBoundColumn DataField="ID" DataType="System.Int32" HeaderText="ID" UniqueName="ID">

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn UniqueName="perComplete" HeaderText="Percent Complete"

AllowFiltering="false">

<ItemTemplate>

<telerik:RadNumericTextBox ID="pct" runat="server" Text='<%#Eval("pct") %>' Width="70px">

<NumberFormat AllowRounding="false" />

</telerik:RadNumericTextBox>

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

</div>

</form>

</body>

</html>

5 Answers, 1 is accepted

answered on 29 Jun 2012, 04:03 AM

Capture.PNG

Hi,

I tried the same code in this version(2012, 1, 215, 35) in which decimal separator works as expected. Attached is the screenshot.
aspx:

<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="false" onneeddatasource="RadGrid1_NeedDataSource">

<MasterTableView>

<Columns>

<telerik:GridBoundColumn DataField="ID" DataType="System.Int32" HeaderText="ID" UniqueName="ID"></telerik:GridBoundColumn>

<telerik:GridTemplateColumn UniqueName="perComplete" HeaderText="Percent Complete" AllowFiltering="false">

<ItemTemplate>

<telerik:RadNumericTextBox ID="pct" runat="server" Text='<%#Eval("pct") %>' Width="70px">

<NumberFormat AllowRounding="false" DecimalSeparator="," />

</telerik:RadNumericTextBox>

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

C#:

protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)

{

System.Data.DataTable table = new System.Data.DataTable();

table.Columns.Add("ID", typeof(int));

table.Columns.Add("pct", typeof(decimal));

table.Rows.Add(1, 5.19m);

table.Rows.Add(2, 99.49m);

table.Rows.Add(3, 19.69m);

table.Rows.Add(4, 5.99m);

RadGrid1.DataSource = table;

}

Thanks,
Shinu.

answered on 29 Jun 2012, 01:49 PM

rntb-local.png

Hi,

It works or not depending whether server locale is en-US or not (regardless of culture setting for radnumerictextbox control).

On my local computer (win7 eng, with pl-PL culture) it doesn't work regardless of culture and other settings (see attachment rntb_local), however on Windows Azure server (as I understand it is win2008r2 eng with en-US culture) it works as expected.

It seems that solution for the problem is to bind data to DbValue instead of Text property (as recommended on http://www.telerik.com/community/forums/aspnet-ajax/grid/radnumerictextbox-culture-compatibility-issues.aspx ), but still, it is a bug.

Jacek

PS Telerik UI 2012.2.607.40

Accepted