public void setTypeSport(TypeClub Type)
{
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
connection.Open();
MySqlCommand command = connection.CreateCommand();
command.CommandText = "INSERT INTO type(Libelle) VALUES (@Libelle)";
command.Parameters.AddWithValue("@Libelle", Type.getLibelle());
command.ExecuteNonQuery();
connection.Close();
}
}
public void supTypeSport(TypeClub type)
{
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
connection.Open();
string query = "DELETE FROM type WHERE Libelle=@Libelle";
//on crée la commande
MySqlCommand command = new MySqlCommand(query, connection);
command.Parameters.AddWithValue("@Libelle", type.getLibelle());
command.ExecuteNonQuery();
connection.Close();
}
}