asp.net - Storing French (decimal values) in database? -


I also have my form set in French, and it automatically sets the text format to use ',' Changes. But when I try to insert my value into the database then it says that you can not convert nvarchar to decimal?

The worst thing is, is there any way that I can disable the number to change ',' and 'bus'. Always what is the language?

My working language is vb.net

thanks,

Robert

If you are passing values ​​from the database as nvarchar, then you have to convert it to a string using yourDecimalValue.ToString (Globalization.CultureInfo.InvariantCulture) or the same SQL Server will always expect to be a decimal in 1903 - you can submit questions with WHERE myvalue IN (1,25, 1,33, 1,45) Resultant problem Can Imagine!


Comments