private void PopulateUpcomingEpisodes() { dgvUpcomingEpisodes.DataSource = null; dgvUpcomingEpisodes.Rows.Clear(); DataTable dataTable = new DataTable(); dataTable.Columns.Add("Series Name"); dataTable.Columns.Add("Episode Number"); dataTable.Columns.Add("Episode Name"); dataTable.Columns.Add("Air Date"); _dbManager.OpenConnection(); Dictionary <int, Episode> upcomingEpisodes = _dbManager.GetUpcomingEpisodes(false); _dbManager.CloseConnection(); foreach (Episode episode in upcomingEpisodes.Values) { object[] row = new object[4] { episode.SeriesName, episode.Season + "-" + episode.EpisodeNumber, episode.Name, episode.FirstAired.ToString("ddd dd-MMM") }; dataTable.Rows.Add(row); } dgvUpcomingEpisodes.DataSource = dataTable; dgvUpcomingEpisodes.Columns["Series Name"].SortMode = DataGridViewColumnSortMode.NotSortable; dgvUpcomingEpisodes.Columns["Series Name"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; dgvUpcomingEpisodes.Columns["Episode Number"].SortMode = DataGridViewColumnSortMode.NotSortable; dgvUpcomingEpisodes.Columns["Episode Number"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; dgvUpcomingEpisodes.Columns["Episode Name"].SortMode = DataGridViewColumnSortMode.NotSortable; dgvUpcomingEpisodes.Columns["Episode Name"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; dgvUpcomingEpisodes.Columns["Air Date"].SortMode = DataGridViewColumnSortMode.NotSortable; dgvUpcomingEpisodes.Columns["Air Date"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; }