1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| private void button1_Click(object sender, EventArgs e)
{
OracleConnection OraCon = new OracleConnection();
string connexionstring = "data source=centreRC;user=system;password=manager;";
OraCon.ConnectionString = connexionstring;
OraCon.Open();
OracleTransaction myOracleTransaction = OraCon.BeginTransaction();
String requete ="INSERT INTO inscription (" + " nom, prenom, activité, fonction, société,département, service, site_web, tel, fax, adr, codePos, ville, pays, connaissance_logivar, besoins, " + ") VALUES ('"+txtnom.Text.ToString()+"','"+txtprn.Text.ToString()+"','"+activité.Text.ToString()+"','"+fct.Text.ToString()+"', '"+txtsocieté.Text.ToString()+"','"+txtdep.Text.ToString()+"','"+txtservice.Text.ToString()+"','"+txtweb.Text.ToString()+"','"+txttel.Text+"','"+txtfax.Text+"','"+txtadr.Text.ToString()+"','"+txtcodpostal.Text+"','"+txtville.Text.ToString()+"','"+txtpays.Text.ToString()+"','"+comboconnaiLogivar.Text.ToString()+"','"+richTxtbesoin.Text.ToString()+"')";
OracleCommand myOracleCommand = new OracleCommand(requete, OraCon, myOracleTransaction);
myOracleCommand.ExecuteNonQuery();
myOracleTransaction.Commit();
OraCon.Close();
} |
Partager