Home All Groups Group Topic Archive Search About

large values from database

Author
22 Nov 2007 2:15 PM
Dave Cullen
I have an Oracle table with very large numerical data values and I can't get
my VB program to display them with full precision. I'm using standard .NET
connectivity with OleDbConnection, OleDbDataAdapter and a Dataset.

If I preview the data in the OleDbDataAdapter the values get rounded off and
converted to scientific notation. E.g. 1800000000000002501 gets turned into
1.8000000000000026E+18. The same thing happens when I actually fill the
dataset in my code.

How do I retrieve the full value without scientific notation?

Thanks

Author
22 Nov 2007 5:17 PM
Terry
Look in the Help for 'OracleNumber'.
--
Terry


Show quoteHide quote
"Dave Cullen" wrote:

> I have an Oracle table with very large numerical data values and I can't get
> my VB program to display them with full precision. I'm using standard .NET
> connectivity with OleDbConnection, OleDbDataAdapter and a Dataset.
>
> If I preview the data in the OleDbDataAdapter the values get rounded off and
> converted to scientific notation. E.g. 1800000000000002501 gets turned into
> 1.8000000000000026E+18. The same thing happens when I actually fill the
> dataset in my code.
>
> How do I retrieve the full value without scientific notation?
>
> Thanks
>
>
>