Jun
21

Casting from MSSQL money to C# double

Rating: 3.0/5 (2 votes cast)

I’m just beginning to transition to ASP.NET and C# from a largely Java / C++ / C background, and along the way, I’m finding myself often stumped with what seems like really simple problems.

For example, today, when writing a ASP.NET web service in C#, I had trouble casting a money value retrieved from a MSSQL database to a double. The following code would always report an error:

NOTE FROM THE AUTHOR, RORY HANSEN
Have you found this post helpful?
If so, I'd appreciate if you could indicate so by pressing the Google Plus button below.

C#
double cost; cost = (double) dr["cost"];

I also tried using a float, but that didn’t fix the problem either.

The _correct_ type to use in this case is actually Decimal, and I learned this only after a co-worker sent me a link to a document on the MSDN site that has a table showing all of the proper type conversions from one system to another. So, this code _does_ work:

C#
Decimal cost; cost = (Decimal) dr["cost"];

You can find the table here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconusingparameterswithdataadapters.asp

(Scroll about halfway down; you can’t miss it.)

Rating: 3.0/5 (2 votes cast)

June 21, 2005 // .net // 8 Comments //

8 Comments to “Casting from MSSQL money to C# double”

July 13, 2006 at 9:35 pm
Satish says:

I hv some problem in money data type of MSSQL i wt to when to use that data type and my problem is if i insert 12.58 then i wt when ever i retrive data i wt same figur not 12.5800 or something else

Replay Soon
June 16, 2007 at 4:30 am
Aditya Kumar says:

I hv some problem in money data type of MSSQL i wt to when to use that data type and my problem is if i insert 12.58 then i wt when ever i retrive data i wt same figur not 12.5800 or something else
April 7, 2008 at 3:22 am
filip says:

Use double for value
for sqldbtype use float
in database
use money
May 4, 2010 at 1:45 pm
erik says:

You need to change (double) dr["cost"]; to Convert.ToDouble(dr["cost"];
May 4, 2010 at 1:46 pm
erik says:

oops should be this Convert.ToDouble(dr["cost"]);
October 13, 2010 at 1:06 pm
Dale says:

erik… you’re awesome. That worked for me. Not sure why money is 4 decimals long in SQL fields but thanks to you, I was able to convert my money field in SQL to a correctly US formated two decimal places. Thanks. Dale n Orlando, Florida
May 26, 2011 at 10:20 am
Searock says:

Thanks a lot, you saved me from a headache !
September 11, 2011 at 6:21 am
Phiqfzqy says:

Who do you work for?