SqlCommand sqlcmd = new SqlCommand("select * from stagiaire where Id_stagiaire=@Id_stagiaire", sqlcon);
            SqlParameter sqlpr1 = new SqlParameter();
            sqlpr1.ParameterName = "@Id_stagiaire";
            sqlpr1.DbType = System.Data.DbType.Int16;
            sqlpr1.Direction = System.Data.ParameterDirection.Input;
            sqlpr1.Value = this.txtID.Text.ToString();
            sqlcmd.Parameters.Add(sqlpr1);
            sqlcon.Open();
            
            sqldr = sqlcmd.ExecuteReader();
            
            if (sqldr.Read())
            {
                this.txtNom.Text = sqldr.GetString(1).ToString();
                this.txtPrenom.Text = sqldr.GetString(2).ToString();
                this.CmbSp.Text = sqldr.GetString(3).ToString();
                if (sqldr.GetString(4).ToString()=="Feminin")
                
                    this.OppFemale.Checked=true;
                else
                    {
                    this.oppMale.Checked=true;
                    }
              this.txtAdrs.Text = sqldr.GetString(5).ToString();
                this.dateTimePicker1.Value = sqldr.GetDateTime(6);
                
                
    

            }
            else
            { MessageBox.Show("Ce ID Stagiaire N'existe pas dans la list des Stagiaires !");
            }
            sqlcon.Close();