//RentedMovie Gridview Bind Data here private void RentedMovieGridData() { DataTable ds = new RentedMOvies().ShowAllRentedMovies(); RentalDataGridView.DataSource = ds; RentalDataGridView.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); }
//Get Customers who borrow most movies private void button3_Click(object sender, EventArgs e) { try { TabControlSystem.SelectedTab = TabControlSystem.TabPages["RentedMovies"]; DataTable dt = new RentedMOvies().CustBorrowMostMovies(); RentalDataGridView.DataSource = dt; RentalDataGridView.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
//Display all rented movies from customer private void DropDownAllCust_SelectedIndexChanged(object sender, EventArgs e) { try { int customerId = int.Parse(DropDownAllCust.SelectedValue.ToString()); if (customerId > 0) { ddlRentedMovies.Enabled = true; DataTable dsRented = new RentedMOvies().ShowRentedMoviesDDL(customerId); if (dsRented.Rows.Count > 0) { DataRow row = dsRented.NewRow(); row[0] = 0; row[1] = "Select..."; dsRented.Rows.InsertAt(row, 0); // add item at INDEX = 0; ddlRentedMovies.DisplayMember = "Title"; ddlRentedMovies.ValueMember = "MovieId"; ddlRentedMovies.DataSource = dsRented; } else { ddlRentedMovies.Enabled = false; } } else { ddlRentedMovies.Enabled = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }