private void BTN_Modif_Click(object sender, EventArgs e) { Form_Ajouter_Adherent Modifier = new Form_Ajouter_Adherent(); Modifier.conn = conn; Modifier.Text = "Modification"; Modifier.numAdherent = DGV_Adherent.SelectedRows[0].Cells[0].Value.ToString(); Modifier.nomAdherent = DGV_Adherent.SelectedRows[0].Cells[1].Value.ToString(); Modifier.prenomAdherent = DGV_Adherent.SelectedRows[0].Cells[2].Value.ToString(); if (Modifier.ShowDialog() == System.Windows.Forms.DialogResult.OK) { try { OracleCommand oraUpdate = new OracleCommand("GestionAdherents", conn); oraUpdate.CommandText = "GestionAdherents.ModifAdherent"; oraUpdate.CommandType = CommandType.StoredProcedure; OracleParameter paramNumAdherent = new OracleParameter("PNumAdherent", OracleDbType.Int32); OracleParameter paramNom = new OracleParameter("Pnom", OracleDbType.Varchar2, 40); OracleParameter paramPrenom = new OracleParameter("PPrenom", OracleDbType.Varchar2, 40); paramNumAdherent.Direction = ParameterDirection.Input; paramNom.Direction = ParameterDirection.Input; paramPrenom.Direction = ParameterDirection.Input; paramNumAdherent.Value = Modifier.numAdherent; paramNom.Value = Modifier.nomAdherent; paramPrenom.Value = Modifier.prenomAdherent; oraUpdate.Parameters.Add(paramNumAdherent); oraUpdate.Parameters.Add(paramNom); oraUpdate.Parameters.Add(paramPrenom); oraUpdate.ExecuteNonQuery(); ReloadDGV(); } catch (OracleException ex) { ErrorMessage(ex); } } }
private void BTN_Ajouter_Click(object sender, EventArgs e) { Form_Ajouter_Adherent Ajouter = new Form_Ajouter_Adherent(); Ajouter.conn = this.conn; Ajouter.Text = "Ajout"; if (Ajouter.ShowDialog() == System.Windows.Forms.DialogResult.OK) { try { OracleCommand oraAjout = new OracleCommand("GestionAdherents", conn); oraAjout.CommandText = "GestionAdherents.Insertion"; oraAjout.CommandType = CommandType.StoredProcedure; OracleParameter OraParaNom = new OracleParameter("PNom", OracleDbType.Varchar2, 40); OracleParameter OraParaPrenom = new OracleParameter("PPrenom", OracleDbType.Varchar2, 40); OraParaNom.Direction = ParameterDirection.Input; OraParaPrenom.Direction = ParameterDirection.Input; OraParaNom.Value = Ajouter.nomAdherent; OraParaPrenom.Value = Ajouter.prenomAdherent; oraAjout.Parameters.Add(OraParaNom); oraAjout.Parameters.Add(OraParaPrenom); oraAjout.ExecuteNonQuery(); ReloadDGV(); } catch (OracleException ex) { ErrorMessage(ex); } } }