I'm having a problem when I'm going to save the data from currency
or decimal
fields to an Access database using the Visual Studio components.
When saving something of type 1.99m
or has 1,99
in textbox the data goes to the bank as 199
. In short the comma is removed and I get the values multiplied by 100. How can I solve this? I already tried things like decimal.parse
and Convert.toDecimal
in addition to directly playing the data in querys I created:
tableAdapterprodutosTableAdapter.UpdateEstoquePreco(id, **1.99m**);
The problem occurs in any operation both insert
and update
.