public C_Plat Lire_ID(int ID) { CreerCommande("SelectionnerPlat_ID"); Commande.Parameters.AddWithValue("@ID", ID); Commande.Connection.Open(); SqlDataReader dr = Commande.ExecuteReader(); C_Plat res = new C_Plat(); while (dr.Read()) { res.ID = int.Parse(dr["ID"].ToString()); res.nom = dr["nom"].ToString(); res.Type = int.Parse(dr["Type"].ToString()); res.Photo = dr["Photo"].ToString(); } dr.Close(); Commande.Connection.Close(); return(res); }
public List <C_Plat> Lire(string Index) { CreerCommande("SelectionnerPlat"); Commande.Parameters.AddWithValue("@Index", Index); Commande.Connection.Open(); SqlDataReader dr = Commande.ExecuteReader(); List <C_Plat> res = new List <C_Plat>(); while (dr.Read()) { C_Plat tmp = new C_Plat(); tmp.ID = int.Parse(dr["ID"].ToString()); tmp.nom = dr["nom"].ToString(); tmp.Type = int.Parse(dr["Type"].ToString()); tmp.Photo = dr["Photo"].ToString(); res.Add(tmp); } dr.Close(); Commande.Connection.Close(); return(res); }