 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / Languages / C# / February 2008Setting decimal symbol
Hi everybody! I have question about setting decimal symbols... In some countries, for example in my country we use comma for decimal symbol, but in in some other countries it is decimal point. The problem is when I use comma and want to save data in database. For example if i want to save number 4,50 it saves like 450, but if i write 4.50 it regulary saves the number in that format. My question is how to make to program knows what to act if my app is working on system where decimal symbol is comma or decimal point. Or should i use only comma and when saving data i just parse the number and replace comma with point? > I have question about setting decimal symbols... In some countries, > for example in my country we use comma for decimal symbol, but [quoted text clipped - 6 lines] > Or should i use only comma and when saving data i just parse the > number and replace comma with point? You can either explicit specify CultureInfo for the Parse or if you have really special requirements explicit specify a NumberFormatInfo. Arne > I have question about setting decimal symbols... In some countries, > for example in my country we use comma for decimal symbol, but [quoted text clipped - 6 lines] > Or should i use only comma and when saving data i just parse the > number and replace comma with point? Don't specify the number as text at all when you pass it to the database - use a parameterised command, and leave it as a number.  SignatureJon Skeet - <skeet@pobox.com> http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet World class .NET training in the UK: http://iterativetraining.co.uk Hello Joza, it's called "turkey test" http://www.moserware.com/2008/02/does-your-code-pass-turkey-test.html just use the .Parse with NumberFormatInfo.Invariant as were recommended --- WBR, Michael Nemtsev [.NET/C# MVP] :: blog: http://spaces.live.com/laflour "The greatest danger for most of us is not that our aim is too high and we miss it, but that it is too low and we reach it" (c) Michelangelo J> Hi everybody! J> J> I have question about setting decimal symbols... In some countries, J> for example in my country we use comma for decimal symbol, but J> in in some other countries it is decimal point. The problem is when J> I use comma and want to save data in database. J> For example if i want to save number 4,50 it saves like 450, but J> if i write 4.50 it regulary saves the number in that format. J> My question is how to make to program knows what to act if my app J> is working on system where decimal symbol is comma or decimal point. J> Or should i use only comma and when saving data i just parse the J> number and replace comma with point > Hello Joza, > > it's called "turkey test" > http://www.moserware.com/2008/02/does-your-code-pass-turkey-test.html > > just use the .Parse with NumberFormatInfo.Invariant as were recommended can you provide me some piece of code how to do that? Thnx. Hello Joza, there are sample in the article I posted http://www.moserware.com/2008/02/does-your-code-pass-turkey-test.html I recommend to read that article --- WBR, Michael Nemtsev [.NET/C# MVP] :: blog: http://spaces.live.com/laflour "The greatest danger for most of us is not that our aim is too high and we miss it, but that it is too low and we reach it" (c) Michelangelo J> Michael Nemtsev [MVP] wrote: J> >> Hello Joza, >> [quoted text clipped - 3 lines] >> just use the .Parse with NumberFormatInfo.Invariant as were >> recommended J> can you provide me some piece of code how to do that? J> J> Thnx. J> > Hello Joza, > > there are sample in the article I posted > http://www.moserware.com/2008/02/does-your-code-pass-turkey-test.html > I recommend to read that article > --- Yes, i have read that article, but if i quite well understand i must treat numbers like strings to use NumberFormatInfo or what?! That it very confusing for me! > it's called "turkey test" http://www.moserware.com > /2008/02/does-your-code-pass-turkey-test.html > > just use the .Parse with NumberFormatInfo.Invariant as were recommended Why do that when the aim is to get the number into a *database*? That's what db command parameters are for :) SignatureJon Skeet - <skeet@pobox.com> http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet World class .NET training in the UK: http://iterativetraining.co.uk >> it's called "turkey test" http://www.moserware.com >> /2008/02/does-your-code-pass-turkey-test.html [quoted text clipped - 3 lines] > Why do that when the aim is to get the number into a *database*? That's > what db command parameters are for :) True. But before he can do that he need to get it as a number. Which is where the parse is needed. Arne > >> it's called "turkey test" http://www.moserware.com > >> /2008/02/does-your-code-pass-turkey-test.html [quoted text clipped - 8 lines] > But before he can do that he need to get it as a number. Which is > where the parse is needed. There's no indication from the OP's question that he has it as a string to start with, as far as I can tell. SignatureJon Skeet - <skeet@pobox.com> http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet World class .NET training in the UK: http://iterativetraining.co.uk >>>> it's called "turkey test" http://www.moserware.com >>>> /2008/02/does-your-code-pass-turkey-test.html [quoted text clipped - 9 lines] > There's no indication from the OP's question that he has it as a string > to start with, as far as I can tell. The original post was not very specific. I got associations to the classic: sqlstr = "INSERT ... VALUES(...," + double.Parse(tb.Text) + ",...)"; But maybe it was more hallucinations than associations ... :-) Arne Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.