1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
|
private void EraseButton_Click(object sender, EventArgs e)
{
//gestion de l'erreur (L'event se lançait à la fermeture et provoque un erreur)
if (CPYComboBox.Text == "...")
{
}
else
{
NomContrepartie = CPYComboBox.Text;
//Connection
DataSet oDS;
// ouvrir la base de données
DbProviderFactory dbpf = DbProviderFactories.GetFactory("System.Data.OleDb");
DbConnection oConn = dbpf.CreateConnection();
oConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=BDD.mdb";
DbDataAdapter oDA = dbpf.CreateDataAdapter();
oDA.SelectCommand = oConn.CreateCommand();
oDA.SelectCommand.CommandText = "DELETE FROM Sauvegarde_Autorisation WHERE CounterPartyName = '" + CPYComboBox.Text + "'";
oDS = new DataSet();
oDA.Fill(oDS);
CPYComboBox.Update();
CPYComboBox.Refresh();
}
} |
Partager