Edit Trainer [Parameters]

SqlCommand sqlcmd = new SqlCommand("update stagiaire set nom=@nom,prenom=@prenom,code_sp=@code_sp,sexe=@sexe,adresse=@adresse,datenaissance=@datenaissance where Id_stagiaire =@Id_stagiaire");

sqlpr1 = new SqlParameter();

sqlpr1.ParameterName = "@Id_stagiaire";

sqlpr1.DbType = System.Data.DbType.Int16;

sqlpr1.Direction = System.Data.ParameterDirection.Input;

sqlpr1.Value = this.txtID.Text;

sqlcmd.Parameters.Add(sqlpr1);

sqlpr2 = new SqlParameter();

sqlpr2.ParameterName = "@nom";

sqlpr2.DbType = System.Data.DbType.String;

sqlpr2.Direction = System.Data.ParameterDirection.Input;

sqlpr2.Value = this.txtNom.Text;

sqlcmd.Parameters.Add(sqlpr2);

sqlpr3 = new SqlParameter();

sqlpr3.ParameterName = "@prenom";

sqlpr3.DbType = System.Data.DbType.String;

sqlpr3.Direction = System.Data.ParameterDirection.Input;

sqlpr3.Value = this.txtPrenom.Text;

sqlcmd.Parameters.Add(sqlpr3);

sqlpr4 = new SqlParameter();

sqlpr4.ParameterName = "@code_sp";

sqlpr4.DbType = System.Data.DbType.String;

sqlpr4.Direction = System.Data.ParameterDirection.Input;

sqlpr4.Value = this.CmbSp.Text;

sqlcmd.Parameters.Add(sqlpr4);

sqlpr5 = new SqlParameter();

sqlpr5.ParameterName = "@sexe";

sqlpr5.DbType = System.Data.DbType.String;

sqlpr5.Direction = System.Data.ParameterDirection.Input;

if (OppFemale.Checked == true)

sqlpr5.Value = "Feminin";

else

sqlpr5.Value = "Masculine";

sqlcmd.Parameters.Add(sqlpr5);

sqlpr6 = new SqlParameter();

sqlpr6.ParameterName = "@adresse";

sqlpr6.DbType = System.Data.DbType.String;

sqlpr6.Direction = System.Data.ParameterDirection.Input;

sqlpr6.Value = this.txtAdrs.Text;

sqlcmd.Parameters.Add(sqlpr6);

sqlpr7 = new SqlParameter();

sqlpr7.ParameterName = "@datenaissance";

sqlpr7.DbType = System.Data.DbType.Date;

sqlpr7.Direction = System.Data.ParameterDirection.Input;

sqlpr7.Value = this.dateTimePicker1.Value.Date;

sqlcmd.Parameters.Add(sqlpr7);

sqlcon.Open();

sqlcmd.Connection = sqlcon;

sqlcmd.ExecuteNonQuery();

MessageBox.Show("Modifier Effectué Avec Succès");

sqlcon.Close();