Trying to convert "1.12" to double

[nadeaupn]

Trying to convert "1.12" to double :

Dim MyDouble as double
MyDouble = cdbl("1.2")

I obtain the following error message :

"La conversion de la chaîne "1.2" en type 'Double' n'est pas valide."

"Conversion of string "1.2" to double is invalid"

I have setted my international parameters in order to have the point (.) as my decimal setting. My other software on my computer understand "1.2" (Excel, Simply accounting...).

I am using Visual Studio 2005 and VB as my coding.

Please help me.

Regards,

Pierre

[Plater]

Have you tried:

Dim MyDouble as double
MyDouble = double.Parse("1.2")
 

[nadeaupn]

Yes I did and it does not work as well.

Thank you for trying to help.

Regards,

Pierre

[Plater]

How about:

Dim MyDouble as double
Dim nfi As New System.Globalization.NumberFormatInfo() 
nfi.NumberDecimalSeparator = "." 
MyDouble = Double.Parse("1.2", System.Globalization.NumberStyles.AllowDecimalPoint, nfi) 
 

[nadeaupn]

Hi PLater,

It partially works.

I do not have an error message and my string is converted to a double value, but this double value is 1,2 instead of 1.2.

My objective is as the following :

1- The possibility for the user to enter a value like 1.2
2- Save this value in a SQL Server field which is configured as real

SQL server does not accept 1,2, it accepts 1.2. When I convert 1.2 to double, if I obtain 1,2, it does not work. Consequently, the double value obtained must be 1.2.

Do you see a solution ?

Regards,

Pierre

[Plater]

Double values are not stored with a "." or a "," it's all how you present them with .ToString() and such.
either use a stored procedure that will take a double as a double, or change your myDouble.ToString() to something similar to what I used for the .Parse() so that it prints using a "." instead of a ","

[nadeaupn]

Hi Plater,

With your code lines + your comments, I succeeded.

Thanks a lot for your help.

Regards,

Pierre