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();