[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 506
  • Last Modified:

Problem with decimal number insert into Access DB

Hi,
I'm trying to insert a value from TextBox into Access DB (Office 2007). This is a currency value (euro) with 4 decimal places.
A DB column is formated as Currency, ¬, 4 decimal places
A column in DataSet is formated as System.Decimal
Finally, a TextBox is binded to a DataSource and formated as Cyrrency (euro) with 4 decimal places (see attached image).
When I update a table adapter to the DB the value is rounded (31,2345 becomes 31,0000). I would like to preserve a value of all 4 decimal places.
If I edit this value in DB manualy, it compares correctly in software's form.
09-10-2008-21.23.00.jpg
09-10-2008-21.48.06.jpg
0
minjakon
Asked:
minjakon
1 Solution
 
Gustav BrockCIOCommented:
The default count of decimals is zero:

http://msdn.microsoft.com/en-us/library/xtba3z33(VS.80).aspx

You may need to adjust that to four.

/gustav
0
 
minjakonAuthor Commented:
Yes, that was it!
I used Double instead of Decimal
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now