ConvertToDouble when in French locale converting number incorrectly

Question

I have a number stored in the database as a float. In this case the number is 93.75

double localCultreResult;
double.TryParse(rs["CostClaim"].ToString(), System.Globalization.NumberStyles.Any, CultureInfo.CurrentCulture, out localCultreResult);
if (rs["CostClaim"].ToString().Length > 0) {
    Cost.Value = localCultreResult;
};

I want the cost value to display as 93,75 when in French locale but instead the above gives me 9375,00

I have also tried all solutions here: How do I parse a string with a decimal point to a double?

All are converting 93.75 to 9375 when in French locale

What is the type of `rs["CostClaim"]`? You may be able to use `localCultreResult=(double)rs["CostClaim"];` — Hans Keﬆing, Feb 24 '20 at 10:49
Try this `(double)rs["CostClaim"]`. Instead of trying to convert try to cast. — Rand Random, Feb 24 '20 at 10:50
You will need to switch "test for non-empty" and "use the contents" - don't use empty contents — Hans Keﬆing, Feb 24 '20 at 10:50
If the type of `rs["CostClaim"]` is `float` then you may need a double cast: first cast to float and then to double: `(double)(float)rs["CostClaim"]` — Hans Keﬆing, Feb 24 '20 at 10:51
The double case throws an exception: System.InvalidCastException: 'Specified cast is not valid.' — Eastbourne Echo, Feb 24 '20 at 10:57
The cast will fail for a value of DbNull.Value - so first check for that (which presumably is the point of your Length check) and *only* when not null, cast to the correct type. — Hans Keﬆing, Feb 24 '20 at 11:45

Guillaume Ladeuille · Answer 1 · 2020-03-11T14:58:14.733

1

If CultureInfo.CurrentCulture is french then rs["CostClaim"].ToString() will be parsed with a ',' as decimal point.

What do you think of:

if (double.TryParse(rs["CostClaim"].ToString(), System.Globalization.NumberStyles.Any, 
    CultureInfo.GetCultureInfo("en-US"), out double localCultreResult))
{
    Cost.Value = localCultreResult;
}

edited Mar 11 '20 at 14:58

answered Feb 24 '20 at 13:37

Guillaume Ladeuille

84
4

ConvertToDouble when in French locale converting number incorrectly

1 Answers1