SqlCommand sqlcmd = new SqlCommand("delete from stagiaire where Id_stagiaire = @Id_stagiaire", sqlcon);
SqlDataReader sqldr;
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);
if (this.txtID.Text == "") MessageBox.Show("Le Champ de Identifiant est vide!");
else
sqlcon.Open();
sqlcmd.ExecuteNonQuery();
MessageBox.Show("Supprimer Avec Succès !");
sqlcon.Close();