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