public CSeries Lire_ID(int serieId) { CreerCommande("SelectionnerSeries_ID"); Commande.Parameters.AddWithValue("@SerieId", serieId); Commande.Connection.Open(); SqlDataReader dr = Commande.ExecuteReader(); CSeries res = new CSeries(); while (dr.Read()) { res.SerieId = serieId; res.Denomination = dr["Denomination"].ToString(); } dr.Close(); Commande.Connection.Close(); return(res); }
public List <CSeries> Lire(string index) { CreerCommande("SelectionnerSeries"); Commande.Parameters.AddWithValue("@Index", index); Commande.Connection.Open(); SqlDataReader dr = Commande.ExecuteReader(); List <CSeries> res = new List <CSeries>(); while (dr.Read()) { CSeries tmp = new CSeries { SerieId = int.Parse(dr["SerieId"].ToString()), Denomination = dr["Denomination"].ToString() }; res.Add(tmp); } dr.Close(); Commande.Connection.Close(); return(res); }