Update and delete buttons C#
<p>I wrote the code for the update button and the delete button.
My purpose is update and delete the datas that I've inserted into the database (that was created in mysql with phpmyadmin).</p>

<p>Update button code:</p>

<pre><code>void ModificaBtnClick(object sender, EventArgs e)
    {
        Connessione.Open();
        MySqlDataAdapter SDA=new MySqlDataAdapter("UPDATE INTO GARA set nome_gara='"+textBox1.Text+"',giudice='"+textBox2.Text+"',località='"+textBox3.Text+"',data='"+textBox4.Text+"',tpsopm='"+textBox5.Text+"',tpmopm='"+textBox6.Text+"',tpstot='"+textBox7+"',tpmtot='"+textBox8.Text+"')VALUES'"+textBox1.Text+"','"+textBox2.Text+"','"+textBox3.Text+"','"+textBox4.Text+"','"+textBox5.Text+"','"+textBox6.Text+"','"+textBox7.Text+"','"+textBox8.Text+"')",Connessione);
        SDA.SelectCommand.ExecuteNonQuery();
        Connessione.Close();

        MessageBox.Show("Dati modificati correttamente!");

    }
</code></pre>

<p>Delete button code:</p>

<pre><code>void CancellaBtnClick(object sender, EventArgs e)
    {
        Connessione.Open();
        MySqlDataAdapter SDA=new MySqlDataAdapter("DELETE FROM GARA(nome_gara,giudice,località,data,tpsopm,tpmopm,tpstot,tpmtot)VALUES'"+textBox1.Text+"','"+textBox2.Text+"','"+textBox3.Text+"','"+textBox4.Text+"','"+textBox5.Text+"','"+textBox6.Text+"','"+textBox7.Text+"','"+textBox8.Text+"')",Connessione);
        SDA.SelectCommand.ExecuteNonQuery();
        Connessione.Close();
        MessageBox.Show("Dati cancellati correttamente!");
    }
</code></pre>

<p>I haven't syntax error, but when I run the program and I try to modify or delete the data, the compiler show me an unhandled exception (An Unhandled exception of type MySql.Data.MySqlClient.MySqlException was thrown). When I quit the window this line is selected <code>SDA.SelectCommand.ExecuteNonQuery();</code></p>

<p>I use the same instruction for the insert button, but it works.</p>

<p>Can you help me, please?</p>

<p><strong>Edit:</strong> I've tried your solutions, but the values don't update into the db. I can modify them into the dataGridView, but when I press the update button they don't change</p>