Styjun

I'm writing a ASP.NET application (C# code, MySQL backend) that collect user data trough a form to be inserted into a SQL table using a stored procedure.
I'm using and wish to use DataSources as long as I can.

The form field that generate the error is the following TextBox (or any other TextBox related to decimal value present into this form):

<asp:TableCell>
<asp:TextBox ID="_txtImportoIVA" ClientIDMode="Static" TextMode="Number" Step="0.01" Width="120px" runat="server" />&nbsp;&euro;
</asp:TableCell>

It's value feeds the following DataSource togheter with values coming from similar widgets:

<asp:SqlDataSource
 runat="server"
 ID="_sdsDocumentiContabili"
 ConnectionString="<%$ ConnectionStrings:sos_db %>"
 ProviderName="<%$ ConnectionStrings:sos_db.ProviderName %>"
 InsertCommandType="StoredProcedure"
 InsertCommand="create_ndc_nlt"
 OnInserted="_sdsDocumentiContabili_Inserted" OnInserting="_sdsDocumentiContabili_Inserting">
 <InsertParameters>
 <asp:ControlParameter ControlID="_txtImportoIVA" PropertyName="Text" Name="_importo_iva" Type="Double" />
 <asp:Parameter Name="_id_ndc" Type="Int32" Direction="Output" />
 </InsertParameters>
</asp:SqlDataSource>

When Insert command is triggered the parameter:

<asp:ControlParameter ControlID="_txtImportoIVA" PropertyName="Text" Name="_importo_iva" Type="Double" />

is fed with a value that's correct only if the text inside the related TextBox is an integer number. When If I provide a decimal value (using Italian localization) the value is obviously interpreted as integer because, I think, the decimal separator is not recognized. I tried to fix this by changing the form localization with culture specific parameters in Page directive:

<%@ Page MasterPageFile="~/MasterPage.master" Language="C#" AutoEventWireup="true" CodeFile="NotaDiCreditoNLT.aspx.cs" Inherits="Intranet.NotaDiCreditoNLT" UICulture="it" Culture="it-IT" %>

But the result didn't change and the value keep being misinterpreted.
Please note that the TextBox is filled up trough javascript code and not by direct user input (as explained below):

var _totaleIVA = Math.round(100 * _totaleIE * g_faliquotaiva) / 100;
var _txtImportoIVA = document.getElementById('_txtImportoIVA');
_txtImportoIVA.value = _totaleIVA;

the first line is a little workaround to truncate decimal to the second digit but can be omitted (the form will NOT work anyway).

Javascript data handling in this form required also a little code-behind workaround because I wish some TextBoxes to be readonly (removing this code will not fix this issue either):

// Workaround to use readonly javascript modified textboxes
private void SetAttributes()

 _txtImportoIVA.Attributes.Add("readonly", "readonly");


protected void Page_Load(object sender, EventArgs e)

 SetAttributes();

The only way I've been able to find to overcome this issue is to handle by code-behind the text-to-double translation (that was exactly what I was trying to avoid):

protected void _sdsDocumentiContabili_Inserting(object sender, SqlDataSourceCommandEventArgs e)

 e.Command.Parameters["_importo_iva"].Value = Double.Parse(_txtImportoIVA.Text, CultureInfo.InvariantCulture);

Of course this requires related <asp:ControlParameter /> to be downgraded to trivial <asp:Parameter /> :

<asp:Parameter Name="_importo_iva" Type="Double" Direction="Input"/>

Is there a way to allow my form to correctly process decimal data without code-behind?