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

  • Thread starter Thread starter Randy Smith
  • Start date Start date
R

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
 
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
Click to expand...

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.
 
Back
Top