Converting SQL Server "money" datatype to double????

[Randy Smith]

Hi,
Does anyone have any good techniques on how to convert an SQL Server 2005
"money" datatype into the ASP.Net "double" datatype?

OR, should we be using "decimal" at both ends?

TIA, Randy Smith

 

[Guest]

Hi,
Does anyone have any good techniques on how to convert an SQL Server 2005
"money" datatype into the ASP.Net "double" datatype?

OR, should we be using "decimal" at both ends?

TIA, Randy Smith

I think decimal will work: Decimal m = (Decimal) dr["moneydatatype"];

http://msdn2.microsoft.com/en-us/library/ms131092.aspx

 

[Joey]

Hi,
Does anyone have any good techniques on how to convert an SQL Server 2005
"money" datatype into the ASP.Net "double" datatype?

OR, should we be using "decimal" at both ends?

TIA, Randy Smith

Not sure if this is what you're looking for, but it will work...

double MyDouble =
double.Parse(drdSQLDataReader.GetSqlMoney(MyOrdinal).ToString());

where MyOrdinal is the ordinal/index of the data field in the current
row.