String to Double Asp.NET C#

Question

I need to convert a String value (returned by the database) to Double but when I do, it simply modifies the value. Example: the database returns 22.5, when I convert to Double at 225.0.

String val_serv = consultaserv[2].ToString();
Double buffer = Convert.ToDouble(val_serv);
totalserv = buffer + totalserv;

Answer 1

You can use the overload of the method Convert.ToDouble who receives a IFormatProvider as a parameter. If Convert.ToDouble without this overload is used the culture in which the program is running. That is why when you convert the value 25.5 it becomes 255, for the "." is hundred separator, not decimal in some cultures (en-BR being one of these).

Convert.ToDouble(val_serv, System.Globalization.CultureInfo.InvariantCulture)

or

Convert.ToDouble(val_serv, System.Globalization.CultureInfo.GetCultureInfo("pt-BR"));
Convert.ToDouble(val_serv, System.Globalization.CultureInfo.GetCultureInfo("en-US"));

etc....

Answer 2

Thus:

double.Parse(consultaserv[2].ToString(), CultureInfo.InvariantCulture);