title: DataGridView linked with DataTable not showing data ODBC
body: <p>I have a datatable filled using an OdbcAdapter. I know for a fact that this table has data in it because if I put a break point I see that it has 5 columns and a count of 852. </p>
  
  <p>I tried putting this table as the data source of a bindingsource then attaching this bindingsource to a DataGridView as well as setting the table as the DataGridView's source directly.</p>
  
  <p>In both cases, the gridview has 0 rows in it and displays nothing. Any help would be much appreciated.</p>
  
  <p>Here is my code:</p>
  
  <pre><code>private void populateTable() {
          String query = "SELECT * FROM MASKENCODE";
          OdbcCommand command = new OdbcCommand(query, Program.myConnection);
  
  
          OdbcDataAdapter adapter = new OdbcDataAdapter(query, Program.myConnection);
  
          DataTable table = new DataTable();
          adapter.Fill(table);
  
          table.DefaultView.AllowDelete = false;
          table.DefaultView.AllowEdit = false;
          table.DefaultView.AllowNew = false;
          //table.Locale = System.Globalization.CultureInfo.InvariantCulture; 
          //bindingSource1.DataSource = table;
          //dataGridView1.DataSource = bindingSource1;
  
          dataGridView1.DataSource = table.DefaultView;
  
          if (table.Rows.Count &gt; 0) {
              Console.WriteLine("TABLE EXISTS");
          }
          if (dataGridView1.RowCount &gt; 0) {
              Console.WriteLine("GRID EXISTS");
          }
  }
  </code></pre>
  
  <p>I always get the "TABLE EXISTS" print but not the "GRID EXISTS" one</p>