public C_t_patients Lire_ID(int IDPat) { CreerCommande("Selectionnert_patients_ID"); Commande.Parameters.AddWithValue("@IDPat", IDPat); Commande.Connection.Open(); SqlDataReader dr = Commande.ExecuteReader(); C_t_patients res = new C_t_patients(); while (dr.Read()) { res.IDPat = int.Parse(dr["IDPat"].ToString()); res.NomPat = dr["NomPat"].ToString(); res.PrenomPat = dr["PrenomPat"].ToString(); res.AdressePat = dr["AdressePat"].ToString(); res.GSMPat = int.Parse(dr["GSMPat"].ToString()); } dr.Close(); Commande.Connection.Close(); return(res); }
public List <C_t_patients> Lire(string Index) { CreerCommande("Selectionnert_patients"); Commande.Parameters.AddWithValue("@Index", Index); Commande.Connection.Open(); SqlDataReader dr = Commande.ExecuteReader(); List <C_t_patients> res = new List <C_t_patients>(); while (dr.Read()) { C_t_patients tmp = new C_t_patients(); tmp.IDPat = int.Parse(dr["IDPat"].ToString()); tmp.NomPat = dr["NomPat"].ToString(); tmp.PrenomPat = dr["PrenomPat"].ToString(); tmp.AdressePat = dr["AdressePat"].ToString(); tmp.GSMPat = int.Parse(dr["GSMPat"].ToString()); res.Add(tmp); } dr.Close(); Commande.Connection.Close(); return(res); }