Data type 'Double' keeps rounding up or down! RRS feed

  • Question

  • I have  an app i have created in vb.net that uses an access database and i have a field in this database with the type 'double'. When i update this field from my program it either rounds it up or down. There is no problem with the database storing doubles as i have gone in and manualy added data and displayed it in the datagridview. It rounds it on the update or insert.


    I have made sure the field is type double in the dataset and obviously the database, so i cant understand, somewhere it seems to think it is a type integer perhaps?


    Any hints as to what i should look for.


    Cheers, Darren.

    Sunday, July 1, 2007 10:12 PM

All replies

  • Try the decimal type. Double is floating point, wheareas decimal can hold values with greater accuracy
    Sunday, July 1, 2007 10:19 PM
  • Darren,


    How are you updating the database?



    Monday, July 2, 2007 1:46 AM