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 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53
| private void button4_Click(object sender, EventArgs e)
{
try
{
string oradb = "Data Source=XE;User Id=SYSTEM;Password=bizerte;";
OracleConnection conn = new OracleConnection(oradb); // C#
conn.Open();
OracleCommand Cmd = new OracleCommand();
OracleCommand cmd = conn.CreateCommand();
OracleCommand Cmd1 = new OracleCommand();
OracleCommand cmd1 = conn.CreateCommand();
OracleCommand Cmd2 = new OracleCommand();
OracleCommand cmd2 = conn.CreateCommand();
cmd.Connection = conn;
String q = "select max(IDBULLETIN)+1 from hr.bulletin";
cmd.CommandText = q;
cmd.CommandType = CommandType.Text;
cmd.ExecuteReader();
OracleDataReader dr = cmd.ExecuteReader();
dr.Read();
l = dr.GetValue(0).ToString();
cmd1.Connection = conn;
String q1 = "SELECT TO_CHAR(sysdate, 'DD/MM/YYYY') FROM dual";
cmd1.CommandText = q1;
cmd1.CommandType = CommandType.Text;
cmd1.ExecuteReader();
OracleDataReader dr1 = cmd1.ExecuteReader();
dr1.Read();
d = dr.GetValue(0).ToString();
cmd2.Connection = conn;
String query = "insert into hr.BULLETIN(IDBULLETIN,FAIT_LE,MATRICULE,OBJET,DEPART,RETOUR,NBJOURS,OBSERVATION) VALUES('" + l + "',''" + d + "'','" + textBox9.Text + "','" + comboBox1.Text + "',''" + Date1.Text + "'',''" + Date2.Text + "'','" + textBox3.Text + "','null')";
cmd2.CommandText = query;
cmd2.CommandType = CommandType.Text;
cmd2.ExecuteReader();
conn.Close();
}
catch (OracleException ex)
{
MessageBox.Show("L'erreur suivante a été rencontrée :" + ex.Message);
}
} |
Partager