//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();
}
}
