public static Genero GetGenero(int id) { conn.Open(); string sql = String.Format("SELECT * FROM Generos WHERE Id = {0}", id); SqlCommand command = new SqlCommand(sql, conn); var reader = command.ExecuteReader(); Genero genero = new Genero(); while (reader.Read()) { genero.id = (int)reader["Id"]; genero.genero = reader["genero"].ToString(); } conn.Close(); return genero; }
public static List<Genero> GetGeneros() { conn.Open(); string sql = "SELECT * FROM Generos"; SqlCommand command = new SqlCommand(sql, conn); var reader = command.ExecuteReader(); var generos = new List<Genero>(); while (reader.Read()) { Genero genero = new Genero(); genero.id = (int)reader["id"]; genero.genero = reader["genero"].ToString(); generos.Add(genero); } conn.Close(); return generos; }