large values from database

[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

 

[Guest]

Look in the Help for 'OracleNumber'.