public CClubs Lire_ID(int clubId) { CreerCommande("SelectionnerClubs_ID"); Commande.Parameters.AddWithValue("@ClubId", clubId); Commande.Connection.Open(); SqlDataReader dr = Commande.ExecuteReader(); CClubs res = new CClubs(); while (dr.Read()) { res.ClubId = clubId; res.Indice = dr["Indice"].ToString(); res.Nom = dr["Nom"].ToString(); res.NomCourt = dr["NomCourt"].ToString(); res.Adresse = dr["Adresse"].ToString(); } dr.Close(); Commande.Connection.Close(); return(res); }
public List <CClubs> Lire(string index) { CreerCommande("SelectionnerClubs"); Commande.Parameters.AddWithValue("@Index", index); Commande.Connection.Open(); SqlDataReader dr = Commande.ExecuteReader(); List <CClubs> res = new List <CClubs>(); while (dr.Read()) { CClubs tmp = new CClubs { ClubId = int.Parse(dr["ClubId"].ToString()), Indice = dr["Indice"].ToString(), Nom = dr["Nom"].ToString(), NomCourt = dr["NomCourt"].ToString(), Adresse = dr["Adresse"].ToString() }; res.Add(tmp); } dr.Close(); Commande.Connection.Close(); return(res); }
public WClubs(Iclubs InterfazClubs) { objClubs = new CClubs(); Manager = new ManagerBD(); ViewClubs = InterfazClubs; }