Currency fields 1.99 saving as 199 on Access

Question

I have a problem when I go to save the data of fields currency or decimal in an Access database using Visual Studio components.

When I save something like 1.99m or has 1,99 in the textbox the data goes to the database as 199. In short the comma is removed and I get the values multiplied by 100. How can I fix this? I’ve tried things like decimal.parse and Convert.toDecimal in addition to playing directly the dice in querys that I created:

tableAdapterprodutosTableAdapter.UpdateEstoquePreco(id, **1.99m**);

The problem occurs in any operation both insert how much in update.

Answer 1

I decided editing directly in Dataset Designer, somehow it was setting providerType to Numeric, all I did was change to currency

Answer 2

Searching I found the following material, but as I used the tableAdapter components and datasets throughout the system I can’t apply it! but follows the code!

public void Gravar(String Nome, DateTime Data, Decimal Salario, Boolean Status)
{
  using (OleDbConnection Conexao = new OleDbConnection(StringConexao))
  {
    Conexao.Open();
    using (OleDbCommand Commando = Conexao.CreateCommand())
    {
        Commando.CommandType = CommandType.Text;
        Commando.CommandText = "INSERT INTO Valores(Nome, Data, Salario, Status) VALUES(@Nome, @Data, @Salario, @Status);";
        Commando.Parameters.Add("@Nome", OleDbType.VarChar, 50).Value = Nome;
        Commando.Parameters.Add("@Data", OleDbType.Date).Value = Data;
        Commando.Parameters.Add("@Salario", OleDbType.Currency).Value = Salario;
        Commando.Parameters.Add("@Status", OleDbType.Boolean).Value = Status;
        Commando.ExecuteNonQuery();
    }
    Conexao.Close();
  }
}