How to send the Data Time Picker date to the Mysql database

Question

Speak guys I have a problem that is send my DTPentrar alias DataTimePicker, follows photo of the error and the code, if anyone can give a light thank you. Hugs

   private void btnSalvar_Click(object sender, EventArgs e)
    {
        try
        {

            conectar.Open();

            //int DataEntrada = Convert.ToInt32(DTPEntrada.Text);


            //MessageBox.Show("Conectado");

            MySqlCommand Inserir = new MySqlCommand();
            Inserir.Connection = conectar;
            Inserir.CommandText = Inserir.CommandText = "INSERT INTO Pacote (peca, Nome, Quantidade, Data_entrada) VALUES ('"
                                    + cbxPeca.Text + "', '" + txtNome.Text + "', '"
                                    + txtQuantidade.Text + "', '" + DTPEntrada + "'); ";

            Inserir.ExecuteNonQuery();
            conectar.Close();
            MessageBox.Show("Cadastro Realizado!", "Concluido",
              MessageBoxButtons.OK,
              MessageBoxIcon.Information);
            selecionarCategoria();
        }
        catch (SqlException)
        {
            MessageBox.Show("Falha na conexao!", "falha",
              MessageBoxButtons.OK,
              MessageBoxIcon.Information);
        }
    }

Screenshot of the above error and the bank code below

Here the error, after the suggestion of @Augusto

Answer 1

Try instead of passing the concatenated parameters, go through Mysql. That is to say:

    Inserir.CommandText = "INSERT INTO Pacote (peca, Nome, Quantidade, Data_entrada) VALUES (@peca, @nome, @quantidade, @dataentrada)";

inserir.Parameters.AddWithValue("@peca",cbxPeca.Text);
inserir.Parameters.AddWithValue("@nome",txtNome.Text);
inserir.Parameters.AddWithValue("@quantidade",txtQuantidade.Text);
inserir.Parameters.AddWithValue("@dataentrada",DTPEntrada .Text);

Or even if you can’t pass the values directly from the components, create a model class, assign the values, and pass them by parameter to the method. PS.: Best way to work.