C# Currency to string

Question

I am querying a database field that returns a money value, I am assigning this to a string but it is adding extra 00 on the end.

e.g. Query returns 30.00

I assign this to a string (string value = Convert.ToString(ReturnValue);) but when I output it, it is showing as 30.0000

Can you advise me where I'm going wrong and the best way to approach this?

Answer 1

MartGriff,

My best advice would be to convert it to a double using the SqlMoney type. From there, you can output it however you would like!

Here's an example:

System.Data.SqlTypes.SqlMoney ReturnValue;

//Set your returnValue with your SQL statement
ReturnValue = ExecuteMySqlStatement();

//Get the format you want

//$30.00
string currencyFormat = ReturnValue.ToDouble().ToString("c");

//30.00
string otherFormat = ReturnValue.ToDouble().ToString("0.00");

For more formatting options, check out the MSDN:

http://msdn.microsoft.com/en-us/library/system.double.tostring.aspx

Best of luck, I hope this helps.