private void LoadDB() { try { DGVCustomer.DataSource = MyDatabase.FillDataGridViews("Customer"); DGVCustomer.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); DGVMovies.DataSource = MyDatabase.FillDataGridViews("Movies"); DGVMovies.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); DGVRentedMovies.DataSource = MyDatabase.FillDataGridViews("RentedMovies"); DGVRentedMovies.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); DGVMostPopular.DataSource = MyDatabase.FillPopularDGV("MoviesRented"); DGVMostPopular.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); DGVCustomerRank.DataSource = MyDatabase.FillPopularDGV("CustomersRentedMovies"); DGVCustomerRank.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); } catch (System.Exception ex) { MessageBox.Show(" Error Something went wrong... " + ex.Message); } }
//LOAD THE MOVIES DATAGRID private void DisplayDataGridViewMovies() { DGVMovies.DataSource = null; try { DGVMovies.DataSource = myDatabase.FillDGVMoviesWithMovies(); //pass the datatable data to the DataGridView DGVMovies.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void rdoShowMoviesOut_CheckedChanged(object sender, EventArgs e) { DGVMovies.DataSource = null; try { DGVMovies.DataSource = myDatabase.FillDGVMoviesWithMoviesOut(); //pass the datatable data to the DataGridView DGVMovies.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); } catch (Exception ex) { MessageBox.Show(ex.Message); } }