Decimal Seperator change in c#

Question

3.50/5 (2 votes)

See more:

i am developing an asp.net application site.the site is hosted in European server.

In european server the decimal seperator is ","
i have some double values in my application like 0.125
and some string to convert to double "0.125"
its working fine in local server,but showing comma instead of dot in live server.

i searched in google to change the decimal seperator and got more more ideas but not even single works for me.

my last attempt is following

static System.Globalization.NumberFormatInfo numberformat = null;
System.Globalization.CultureInfo info = System.Globalization.CultureInfo.InstalledUICulture;
numberformat = (System.Globalization.NumberFormatInfo)
info.NumberFormat.Clone();
numberformat.NumberDecimalSeparator = ".";
double duration=double.Parse("0.125",numberformat);

its not working.

Please help me to do it.

Posted 27-Apr-11 19:20pm

kishore Rajendran

Updated 29-Dec-17 20:34pm

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Olivier Levrey · Accepted Answer · 2011-04-27T23:37:00

Solution 2

In addition to SA's answer, you can use InvariantCulture:

C#

double a = 0.125;
//decimal separator will always be '.'
string txt = a.ToString(System.Globalization.CultureInfo.InvariantCulture);
//back to a double
double a2 = double.Parse(txt, System.Globalization.CultureInfo.InvariantCulture);

I prefer this solution to store standard formated data into a file. You don't need to bother wich culture you used once you want to load them.

Posted 27-Apr-11 23:37pm

Olivier Levrey

Updated 27-Apr-11 23:41pm

v2

Comments

kishore Rajendran 28-Apr-11 6:02am

Works for me
thanks

Olivier Levrey 28-Apr-11 6:08am

You are welcome.
You can accept the answer then or vote for it.
Thanks.

kishore Rajendran 28-Apr-11 6:20am

is regional settings affect sql server?
am saving a value say 1.5 to DB
its saving as 1,5
any idea regarding this?

Please inform me

Olivier Levrey 28-Apr-11 6:33am

I am sorry I have no knowledge about sql server. But if the value saved is 1,5 instead of 1.5 it means it is using regional settings. So you will have to use SA's answer.
Maybe you can setup your sql server to work with InvariantCulture?

kishore Rajendran 28-Apr-11 6:45am

its ok np

Sergey Alexandrovich Kryukov · Accepted Answer · 2011-04-27T19:32:00

Solution 1

Use format provider implemented by the type System.Globalization.CultureInfo.

For example:

C#

System.IFormatProvider cultureUS =
   new System.Globalization.CultureInfo("en-US");

System.Globalization.CultureInfo cultureFr =
   new System.Globalization.CultureInfo("fr-fr");

//...

double duration = double.Parse("0.125", cultureUS);
double length = double.Parse("25,1415", cultureFr);

—SA

Posted 27-Apr-11 19:32pm

Sergey Alexandrovich Kryukov

Updated 27-Apr-11 19:35pm

v4

Comments

Abhinav S 28-Apr-11 1:38am

Good answer. My 5.

Sergey Alexandrovich Kryukov 28-Apr-11 1:40am

Thank you, Abhinav,
--SA

Ankit Rajput 28-Apr-11 1:46am

Nice Answer. My 5.

Sergey Alexandrovich Kryukov 28-Apr-11 2:04am

Thank you, Ankit.
--SA

kishore Rajendran 28-Apr-11 1:56am

Not Working For me

Sergey Alexandrovich Kryukov 28-Apr-11 2:01am

For a programmer, there is no "not working". Compile-time, exceptions? What type, message? in what line?..

What exactly not working? Did you use the culture you want? (Mine is just for example.) Did you check a decimal separator format for the cultures? Exceptions? What?

--SA

kishore Rajendran 28-Apr-11 6:46am

*

Sergey Alexandrovich Kryukov 28-Apr-11 2:33am

This culture expects a dot!
--SA

kishore Rajendran 28-Apr-11 6:46am

*

Sergey Alexandrovich Kryukov 28-Apr-11 10:12am

I tested it. It works as expected; "fr-fr" expects comma, "en-us" expects dot.

May I suggest why do you think it is not working?
You parse correctly, but when you type back numbers of both cases you still see them in the same format. But they should be in the same format! The numbers themselves do not have format, they are all binary. Whey you print them, they show in current culture. If you need them as strings in a different culture, use double.ToString in a different culture.

Is that you problem?
--SA

Kim Togo 28-Apr-11 4:46am

Good answer, my 5.

Sergey Alexandrovich Kryukov 28-Apr-11 11:53am

Thank you, Kim.
Just got an idea why OP still did not get it, commented.
--SA

Olivier Levrey 28-Apr-11 5:39am

Good answer, have a 5. But personnaly, I prefer using InvariantCulture since you can easily store/load data into/from a standard formated file.

Sergey Alexandrovich Kryukov 28-Apr-11 10:09am

Thank you, Olivier.
I agree with you, thank you for this note.
I only show how to use culture.
--SA