Currency format
This is a discussion on Currency format within the ASP and ASP.NET Programming forums, part of the Web Development category; While saving the values in the SQL in the currency datatype, the value is stored with a period(dot). Example : ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
03-12-2008, 09:05 PM
| |||
| |||
 Currency format While saving the values in the SQL in the currency datatype, the value is stored with a period(dot). Example : If we store 100000 in the DB, then it will be stored as 100.000 How can we format it as 100,000. And how can we add comma for every three digit as 100,000,000 ?     |
|
#2
03-12-2008, 11:32 PM
| |||
| |||
 Re: Currency format Hi, U can use money datatype for column in DB. Then u can store the values as 10000.00 If u want to insert comma after every three numbers.do it using script or in code-behind and then store it in DB..While storing 100,000.00 like this in DB, u should have datatype as varchar.. |
|
#3
03-13-2008, 02:26 AM
| |||
| |||
| Re: Currency format Thank you for your timely help madam. |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Embedded Currency Conversion | Alkazar | HTML, CSS and Javascript Coding Techniques | 1 | 08-27-2007 06:57 AM |
| How to Create an Excel Macro that converts currency in numbers into words? | itbarota | VB.NET Programming | 2 | 08-08-2007 05:23 AM |
| How can you convert them to another format? | devarajan.v | PHP Programming | 1 | 07-26-2007 09:33 AM |
| How to Create word Macro that converts currency in numbers into words? | itbarota | VB.NET Programming | 1 | 07-25-2007 03:03 AM |
| Better Image Format | Joe | Web Design Help | 12 | 03-06-2007 10:31 PM |
All times are GMT -7. The time now is 02:52 PM.