public C_Modele Lire_ID(int idModele) { CreerCommande("SelectionnerModeleVoiture_ID"); Commande.Parameters.AddWithValue("@idModele", idModele); Commande.Connection.Open(); SqlDataReader dr = Commande.ExecuteReader(); C_Modele res = new C_Modele(); while (dr.Read()) { res.idModele = int.Parse(dr["idModele"].ToString()); res.nomModele = dr["nomModele"].ToString(); } dr.Close(); Commande.Connection.Close(); return(res); }
public List <C_Modele> Lire(string Index) { CreerCommande("SelectionnerModeleVoiture"); Commande.Parameters.AddWithValue("@Index", Index); Commande.Connection.Open(); SqlDataReader dr = Commande.ExecuteReader(); List <C_Modele> res = new List <C_Modele>(); while (dr.Read()) { C_Modele tmp = new C_Modele(); tmp.idModele = int.Parse(dr["idModele"].ToString()); tmp.nomModele = dr["nomModele"].ToString(); res.Add(tmp); } dr.Close(); Commande.Connection.Close(); return(res); }