Entering numerical data in the database

Question

I’m having trouble inserting into the database the field is formatted as DECIMAL(10,2)), when I try to insert the direct monetary value by Mysql works with the endpoint instead of the comma ex:

135.45 - The bank intends the two decimal places.

Now when I try to insert by my program, it records in the flock as follows:

13545.00

Follow my model.Cs for this field

class Modelo
{
 private float nValor;

  public float Valor

        {
            get { return nValor; }
            set { nValor = value; }
        }
}

The action of the button to record the entered value is like this:

private void btn_cadastrar_Click(object sender, EventArgs e)
        {
            Modelo mo = new Modelo();
            conexao con = new conexao();

            try
            {


                if (cbox_pagamento.SelectedItem.ToString() == "a vista")
                {
                    mo.Data_Compra = txt_dcompra.Text;
                    mo.Data_Alvo = txt_dalvo.Text;
                    mo.Fornecedor = txt_fornecedor.Text;
                    mo.Valor = float.Parse(txt_valor.Text);
                    mo.Tipo = cbox_tipo.Text;
                    mo.Pagamento = lbl_fiado.Text;
                    mo.Data_Pagamento = txt_dpagamento.Text;

                    con.cadastro(mo);

                    txt_fornecedor.Text = "";
                    txt_valor.Text = "";
                    MessageBox.Show("Dados gravados com sucesso!");
                }
                else
                {
                    mo.Data_Compra = txt_dcompra.Text;
                    mo.Data_Alvo = txt_dalvo.Text;
                    mo.Fornecedor = txt_fornecedor.Text;
                    mo.Valor = float.Parse(txt_valor.Text);
                    mo.Tipo = cbox_tipo.Text;
                    mo.Pagamento = lbl_fiado.Text;
                    mo.Data_Pagamento = txt_dpagamento.Text;

                    con.cadastro_aprazo(mo);

                    txt_fornecedor.Text = "";
                    txt_valor.Text = "";
                    MessageBox.Show("Dados gravados com sucesso!");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Falha ao salvar no banco de dados :" + ex);
            }


        }

Does anyone have any idea how I put the value in the bank correctly?

Answer 1

The first thing you need to change is the correct type in the code. Started doing well in the database, keep this in the code:

public class Modelo {
    public float Valor { get; set; }
}

Then do it:

private void btn_cadastrar_Click(object sender, EventArgs e) {
    var mo = new Modelo();
    var con = new conexao(); //espero que esteja bem feito para não dar vazamento
    try {
        if (Decimal.TryParse(txt_valor.Text.Replace(',', '.'), out var valor) {
            mo.Data_Compra = txt_dcompra.Text;
            mo.Data_Alvo = txt_dalvo.Text;
            mo.Fornecedor = txt_fornecedor.Text;
            mo.Valor = valor;
            mo.Tipo = cbox_tipo.Text;
            mo.Pagamento = lbl_fiado.Text;
            mo.Data_Pagamento = txt_dpagamento.Text;
            con.cadastro(mo);
            txt_fornecedor.Text = "";
            txt_valor.Text = "";
            //aqui precisa fazer a gravação
            MessageBox.Show("Dados gravados com sucesso!");
    } catch (MySqlException ex) { //capture uma exceção mais específica
        MessageBox.Show("Falha ao salvar no banco de dados :" + ex);
    }
}

I put in the Github for future reference.

Note that I have captured the more specific exception that is correct. But I do not know if the connection will not hang there. I think it will, but only with this excerpt I have no way to talk. You have to fix it.

I eliminated the if who did the same thing. But I put another one to pick up a value typing error. And I did with decimal which is the correct type for monetary values.

I did the manual semicolon inversion, but this is not the most correct, it is better to use culture. If you’re interested I can show you in this way that it’s a little more advanced, but it’s less common.

Answer 2

After much searching I figured out how to do to convert, 1º in your bank will have to put the value field as Decimal(10,2) 2º at the time you give the insert into vc you have to replace the comma by the point. It looks like this

string value = textboxvalue.text; value = value.replace(',','.');

The Insert will look like this: INSERT INTO TABLE(name_column)values('"+value+"');

Remembering that I use Visual Studio 2017 may change a little if using other software

Answer 3

It may be because of commas in your field, which are not identified in the conversion. Try changing the line

mo.Valor = float.Parse(txt_valor.Text);

for

mo.Valor = float.Parse(txt_valor.Text.Replace(',','.'));