1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| OleDbDataReader objRdr;
objCmd = new OleDbCommand("UPDATE employee SET nn = @editBox1,Datee= @dateTimePicker1,employee= @emp,cin=@cin,entrer=@dateTimePicker2,heurentre=@timePicker1,heurstop=@timePicker2,heurcontinue=@timePicker4,heursortie=@timePicker5,herutarv=@trav,prixheur=@prix,avance=@avance,heur_supp=@supp,total=@total,payemment=@choose WHERE nn='"+editBox1.Text+"'",con);
objCmd.Parameters.AddWithValue("@nn", @editBox1.Text);
objCmd.Parameters.AddWithValue("@Datee", dateTimePicker1.Value.ToString());
objCmd.Parameters.AddWithValue("@employee", emp.Text); //checkbox named chkDayNight
objCmd.Parameters.AddWithValue("@cin", cin.Text);
objCmd.Parameters.AddWithValue("@entrer", dateTimePicker2.Value.ToString());
objCmd.Parameters.AddWithValue("@heurentre", timePicker1.Text);
objCmd.Parameters.AddWithValue("@heurstop", timePicker2.Text);
objCmd.Parameters.AddWithValue("@heurcontinue", timePicker4.Text);
objCmd.Parameters.AddWithValue("@heursortie", timePicker5.Text);
objCmd.Parameters.AddWithValue("@herutarv", trav.Text);
objCmd.Parameters.AddWithValue("@prixheur", prix.Text);
objCmd.Parameters.AddWithValue("@avance", avance.Text);
objCmd.Parameters.AddWithValue("@heur_supp", supp.Text);
objCmd.Parameters.AddWithValue("@total", total.Text);
objCmd.Parameters.AddWithValue("@payemment", choose.Text);
con.Open();
objCmd.ExecuteNonQuery();
con.Close();*/ |
Partager