public void ThrillerMovie(ListBox lb)
{
//THRILLER MOVIE CONTAINER
DBUtility thriller = new DBUtility();
SqlDataReader rdr = thriller.GetReader("select MovieName from Movie,Info where info.FilmCategoryID=4 and Movie.FilmCategoryID=3 ");
while (rdr.Read())
{
//ListBoxrdr.Items.Add("Product = " + rdr[0] + ", Id of category =" + rdr["categoryid"]);
lb.Items.Add(rdr["MovieName"].ToString());
}
thriller.CloseConnection();
}
public void AnimationMovie(ListBox lb)
{
//ANIMATION MOVIE CONTAINER
DBUtility animation = new DBUtility();
SqlDataReader rdr = animation.GetReader("select MovieName from Movie,Info where info.FilmCategoryID=4 and Movie.FilmCategoryID=2 ");
while (rdr.Read())
{
//ListBoxrdr.Items.Add("Product = " + rdr[0] + ", Id of category =" + rdr["categoryid"]);
lb.Items.Add(rdr["MovieName"].ToString());
}
animation.CloseConnection();
}
public void ScienceMovie(ListBox lb)
{
//SCIENCE MOVIE CONTAINER
DBUtility science = new DBUtility();
SqlDataReader rdr = science.GetReader("select MovieName from Movie,Info where info.FilmCategoryID=4 and Movie.FilmCategoryID=4 ");
while (rdr.Read())
{
//ListBoxrdr.Items.Add("Product = " + rdr[0] + ", Id of category =" + rdr["categoryid"]);
lb.Items.Add(rdr["MovieName"].ToString());
}
science.CloseConnection();
}