PC Review


Reply
Thread Tools Rate Thread

Converting decimal to another decimal with a different culture

 
 
Jan tde Witt
Guest
Posts: n/a
 
      10th Dec 2008
Hi,

I have a webform which has the culture set to NL-nl so the decimals have the
comma as the decimalseperator.. However, my database is using the US-en
culture so I need to convert the NL-nl decimal to a new decimal with the
EN-us culture (so it will have the period as a decimalseperator).

How can I do this?

THX


 
Reply With Quote
 
 
 
 
Jeff Johnson
Guest
Posts: n/a
 
      11th Dec 2008
"Jan tde Witt" <(E-Mail Removed)> wrote in message
news:ghp5c0$f8o$(E-Mail Removed)...

> I have a webform which has the culture set to NL-nl so the decimals have
> the comma as the decimalseperator.. However, my database is using the
> US-en culture so I need to convert the NL-nl decimal to a new decimal with
> the EN-us culture (so it will have the period as a decimalseperator).
>
> How can I do this?


If in your code you're handling this value as a decimal data type then it
doesn't matter. Numbers are numbers are numbers. The thousands separator and
decimal point are for DISPLAY only; they have no bearing on how the number
is STORED.


 
Reply With Quote
 
Jeff Johnson
Guest
Posts: n/a
 
      11th Dec 2008
"Jan tde Witt" <(E-Mail Removed)> wrote in message
news:ghp5c0$f8o$(E-Mail Removed)...

> I have a webform which has the culture set to NL-nl so the decimals have
> the comma as the decimalseperator.. However, my database is using the
> US-en culture so I need to convert the NL-nl decimal to a new decimal with
> the EN-us culture (so it will have the period as a decimalseperator).
>
> How can I do this?


By the way, what does this question have to do with WINDOWS forms?


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text box formatted to General Number with 2 decimal places NOTallowing the decimal place. p-rat Microsoft Access Form Coding 3 14th Jan 2008 05:20 PM
Decimal.TryParse failed in da-DK culture. dehranph@gmail.com Microsoft C# .NET 1 27th Feb 2007 10:45 PM
Batch converting CSV files from comma-decimal to period-decimal Nodles Microsoft Excel Misc 3 5th Jul 2006 06:57 PM
Make decimal work properly in fixed decimal entry in Excel 2003. =?Utf-8?B?am9obmdpaWk=?= Microsoft Excel Crashes 0 12th Apr 2006 06:05 AM
Converting 2-place decimal value to floating point decimal number with leading zero Kermit Piper Microsoft Excel Misc 3 18th Mar 2006 06:20 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:34 AM.