private void ProductsRatingButton_Click(object sender, EventArgs e) { SqlProductRepository products = new SqlProductRepository(connectionString); IReadOnlyList <Product> productList = products.RetrieveHighestRatings(); dataGridView1.DataSource = productList; for (int i = 0; i < dataGridView1.Columns.Count; i++) { DataGridViewColumn columnOne = dataGridView1.Columns[0]; columnOne.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; } }