|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
large values from databaseI 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 Look in the Help for 'OracleNumber'.
-- Show quoteHide quoteTerry "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 > > >
How do you use GetProperty.SetValue with the index parameter?
EventHandler for late-bound COM object name parser How to check a string to see that it is a valid file name How to change the name of multiple textboxes CD Burning with VB.NET Silly syntactic question Opening Folder Browse Dialog On Client Side Extension Methods in VB 2008 Express? OT: Nant + VB 3.0 / 3.0 |
|||||||||||||||||||||||