List<Sesion> sesiones = new List<Sesion>();
                conn.Open();
                string consulta = "SELECT * from sesion WHERE IdPelicula=?id;";
                MySqlCommand cmdConsulta = new MySqlCommand(consulta, conn);
                cmdConsulta.Parameters.AddWithValue("?id", id);
                MySqlDataReader LectorPeliculas = cmdConsulta.ExecuteReader();
                while (LectorPeliculas.Read())
                {
                    Sesion s = new Sesion();
                    s.IdSala = (int)LectorPeliculas["IdSala"];
                    s.Hora = LectorPeliculas["Hora"].ToString();
                    s.Vendidas = (int)LectorPeliculas["Entradas"];
                    sesiones.Add(s);
                }

                conn.Close();
                List<Sesion> restantes = new List<Sesion>();
                foreach (Sesion s in sesiones)
                {
                    conn.Open();
                    string consulta1 = "SELECT * from sala WHERE IdSala=?id;";
                    MySqlCommand cmdConsulta1 = new MySqlCommand(consulta1, conn);
                    cmdConsulta1.Parameters.AddWithValue("?id", s.IdSala);
                    MySqlDataReader LectorPeliculas1 = cmdConsulta1.ExecuteReader();
                    while (LectorPeliculas1.Read())
                    {
                        s.Butacas= (int)LectorPeliculas1["Butacas"];
                        s.Restantes = (int)LectorPeliculas1["Butacas"]-s.Vendidas;
                        restantes.Add(s);
                    }
                    conn.Close();
                }