//Mise à jour d'un enregistrement public void Update(Personne ancPers, Personne nvPers) { string query = "UPDATE matable SET nom='" + nvPers.Nom + "', ddn='" + nvPers.Convert2MySQL(nvPers.Dnaissance) + "' WHERE nom='" + ancPers.Nom + "'"; //Open connection if (this.OpenConnection() == true) { //create mysql command MySqlCommand cmd = new MySqlCommand(); //Assign the query using CommandText cmd.CommandText = query; //Assign the connection using Connection cmd.Connection = connection; //Execute query cmd.ExecuteNonQuery(); //close connection this.CloseConnection(); } }
//Insertion d'un enregistrement public void Insert(Personne unePers) { string query = "INSERT INTO matable (nom, ddn) VALUES('" + unePers.Nom + "', '" + unePers.Convert2MySQL(unePers.Dnaissance) + "')"; //open connection if (this.OpenConnection() == true) { //create command and assign the query and connection from the constructor MySqlCommand cmd = new MySqlCommand(query, connection); //Execute command cmd.ExecuteNonQuery(); //close connection this.CloseConnection(); } }