which sqlcedatareader method should I call for a numeric f..

I am developing a sql server 2005 ce appliaction. I have a numeric(18,10)
filed in my db table.
When I call oReader.GetDouble(0) after oCmd.ExecuteReader() and
oReader.Read(), I got a sql exception: invalidCastException.

So I am confusing... Which other method should I call for numeric field than
GetDouble()?

Thank you in advance.

> So I am confusing... Which other method should I call for numeric field
> than GetDouble()?

SQL Server numeric and decimal data types map to a .Net decimal. See
http://msdn.microsoft.com/en-us/library/4e5xt97a(VS.80).aspx for a complete
list.

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"newsgroup" wrote in message

> I am developing a sql server 2005 ce appliaction. I have a numeric(18,10)
> filed in my db table.
> When I call oReader.GetDouble(0) after oCmd.ExecuteReader() and
> oReader.Read(), I got a sql exception: invalidCastException.
>
> So I am confusing... Which other method should I call for numeric field
> than GetDouble()?
>
> Thank you in advance.
>