public C_t_medecins Lire_ID(int IDMed) { CreerCommande("Selectionnert_medecins_ID"); Commande.Parameters.AddWithValue("@IDMed", IDMed); Commande.Connection.Open(); SqlDataReader dr = Commande.ExecuteReader(); C_t_medecins res = new C_t_medecins(); while (dr.Read()) { res.IDMed = int.Parse(dr["IDMed"].ToString()); res.NomMed = dr["NomMed"].ToString(); res.PrenomMed = dr["PrenomMed"].ToString(); res.GSMMed = int.Parse(dr["GSMMed"].ToString()); res.IDSpe = int.Parse(dr["IDSpe"].ToString()); } dr.Close(); Commande.Connection.Close(); return(res); }
public List <C_t_medecins> Lire(string Index) { CreerCommande("Selectionnert_medecins"); Commande.Parameters.AddWithValue("@Index", Index); Commande.Connection.Open(); SqlDataReader dr = Commande.ExecuteReader(); List <C_t_medecins> res = new List <C_t_medecins>(); while (dr.Read()) { C_t_medecins tmp = new C_t_medecins(); tmp.IDMed = int.Parse(dr["IDMed"].ToString()); tmp.NomMed = dr["NomMed"].ToString(); tmp.PrenomMed = dr["PrenomMed"].ToString(); tmp.GSMMed = int.Parse(dr["GSMMed"].ToString()); tmp.IDSpe = int.Parse(dr["IDSpe"].ToString()); res.Add(tmp); } dr.Close(); Commande.Connection.Close(); return(res); }