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