title: How to add a column when using SqlDataAdapter to fill a datagridview
body: <p>I am using SQL to fill my datagridview. I am doing that this way:</p>
  
  <pre><code>string cn = ConfigurationManager.ConnectionStrings["Scratchpad"].ConnectionString;
  SqlConnection myConnection = new SqlConnection(cn);
  
  string sql = "some text here";
  SqlDataAdapter dataadapter = new SqlDataAdapter(sql, myConnection);
  DataSet ds = new DataSet();
  myConnection.Open();
  dataadapter.Fill(ds, "Authors_table");
  myConnection.Close();
  dataGridView1.DataSource = ds;
  dataGridView1.DataMember = "Authors_table";
  </code></pre>
  
  <p>Now it deletes the old datagridview and paste the selection. But I want just to add the data to the column right of the existing data.</p>
  
  <p>Thanks in advance</p>