title: Database connection doesn't work C#
body: <p>I'm working on a program in C#. I created a database with MySQL on phpMyAdmin and I want to connect this database with my program.
  After the connection I have to insert, update, delete and view all the data, but I have a problem: the connection doesn't work.</p>
  
  <p>I post here my code for the connection:</p>
  
  <pre><code>public static string StringaConnessione = "Data Source=localhost;Database=agility;userid=root;password='';";
  public static MySqlConnection Connessione = new MySqlConnection(StringaConnessione);
  </code></pre>
  
  <p>When I write the code for the insert button I have another problem (is certainly for the database)</p>
  
  <pre><code>Connessione.Open();
  SQLDataAdapter SDA=new SqlDataAdapter("INSERT INTO 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 salvati correttamente!");
  </code></pre>
  
  <p>May you help me, please? Thank you!</p>