title: fill data to already defined columns in datagridview
body: <p>i am trying to Bind DateTable to Datagridview that already have columns designed using Designer in VS. Source for DataTable is sql database. I am trying to do this using following code which adds only blank rows in datagridview. also i update the DataPropertyName property of a DGV column with the name of the column in the DataTable</p>
  
  <pre><code>SqlConnection CN = new SqlConnection(mysql.CON.ConnectionString);
  dataGridView1.AutoGenerateColumns = false;
  DataTable dt = new DataTable();
  foreach (DataGridViewColumn col in dataGridView1.Columns)
  {
      dt.Columns.Add(col.Name);
      col.DataPropertyName = col.Name;
  }
  SqlDataAdapter sda = new SqlDataAdapter("select id,name,age,notes  from test where id = '" + txtID.Text + "'", CN);
  sda.Fill(dt);
  dataGridView1.DataSource = dt;
  </code></pre>
  
  <p>please nead help to know why the rows are viewed empty with out data</p>