public List <C_T_Liaison_G> Lire(string Index) { CreerCommande("SelectionnerT_Liaison_G"); Commande.Parameters.AddWithValue("@Index", Index); Commande.Connection.Open(); SqlDataReader dr = Commande.ExecuteReader(); List <C_T_Liaison_G> res = new List <C_T_Liaison_G>(); while (dr.Read()) { C_T_Liaison_G tmp = new C_T_Liaison_G(); tmp.Id_Liaison_G = int.Parse(dr["Id_Liaison_G"].ToString()); if (dr["Id_Activite"] != DBNull.Value) { tmp.Id_Activite = int.Parse(dr["Id_Activite"].ToString()); } if (dr["Id_Anime"] != DBNull.Value) { tmp.Id_Anime = int.Parse(dr["Id_Anime"].ToString()); } res.Add(tmp); } dr.Close(); Commande.Connection.Close(); return(res); }
public C_T_Liaison_G Lire_ID(int Id_Liaison_G) { CreerCommande("SelectionnerT_Liaison_G_ID"); Commande.Parameters.AddWithValue("@Id_Liaison_G", Id_Liaison_G); Commande.Connection.Open(); SqlDataReader dr = Commande.ExecuteReader(); C_T_Liaison_G res = new C_T_Liaison_G(); while (dr.Read()) { res.Id_Liaison_G = int.Parse(dr["Id_Liaison_G"].ToString()); if (dr["Id_Activite"] != DBNull.Value) { res.Id_Activite = int.Parse(dr["Id_Activite"].ToString()); } if (dr["Id_Anime"] != DBNull.Value) { res.Id_Anime = int.Parse(dr["Id_Anime"].ToString()); } } dr.Close(); Commande.Connection.Close(); return(res); }