large values from database

  • Thread starter Thread starter Dave Cullen
  • Start date Start date
D

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