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;
}
