title: Populate a datagridview with sql query results
body: <p>I'm trying to present query results, but I keep getting a blank data grid. 
  It's like the data itself is not visible</p>
  
  <p>Here is my code:</p>
  
  <pre><code> private void Employee_Report_Load(object sender, EventArgs e)
   {
       string select = "SELECT * FROM tblEmployee";
       Connection c = new Connection();
       SqlDataAdapter dataAdapter = new SqlDataAdapter(select, c.con); //c.con is the connection string
       SqlCommandBuilder commandBuilder = new SqlCommandBuilder(dataAdapter);
  
       DataTable table = new DataTable();
       table.Locale = System.Globalization.CultureInfo.InvariantCulture;
       dataAdapter.Fill(table);
       bindingSource1.DataSource = table;
  
       dataGridView1.ReadOnly = true;        
       dataGridView1.DataSource = bindingSource1;
  }
  </code></pre>
  
  <p>What's wrong with this code?</p>