Archive for January, 2009

In classic ASP we had FormatCurrency to take a value (number) and display it as a formatted currency.
In C#, how do we achieve the same?

To map a SQL 205 Money datatype to a C# class property, I use Decimal Data Type – which gives you the precision you need.
A simple .ToString() on this, would display just that – the decimal, as a string.

But what if you want to display a price??

Well, you can use String.Format

See below for an example:

var priceString = String.Format("Price: {0:C}", priceValue.ToString());

Now, in our example above, we use priceValue – this is the decimal value, with a .ToString() on the end (not entirely sure if this is required)

This will display:

Price: £20.38

(assuming the value of priceValue was 20.38)

This is dependant on the set up of the server / computer the application is running on… for example, if it is set up for USA, it will display $ instead of £.