title: add selected row from one gridview to another
body: <p>I have 2 <code>GridView</code> controls. I need to add the selected row from one GridView to a second GridView. (I select row from GridView by clicking direct to GridView.)</p>
  
  <p>Here's my code, but it copies all data from gridview1 to gridview2. I need the selected row only.</p>
  
  <pre><code>private void button6_Click(object sender, EventArgs e)
      {
         DataGridViewColumn newCol = null;
          foreach (DataGridViewColumn col in dataGridView1.Columns)
          {
              newCol = new DataGridViewColumn(col.CellTemplate);
              newCol.HeaderText = col.HeaderText;
              newCol.Name = col.Name;
              dataGridView2.Columns.Add(newCol);
          }
  
          dataGridView2.RowCount = dataGridView1.RowCount;
          foreach (DataGridViewRow row in dataGridView1.Rows)
          {
              foreach (DataGridViewColumn col in dataGridView1.Columns)
              {
                  dataGridView2.Rows[row.Index].Cells[col.Name].Value = row.Cells[col.Name].Value;
              }
          }
  </code></pre>
  
  <p>I populated <code>dataGridView1</code> with a DataTable:</p>
  
  <pre><code>SqlConnection con = new SqlConnection(@"Data Source=AFZAL\SQLEXPRESS;Initial Catalog=GIMS_LabInfo;Integrated Security=True");
  con.Open();
  SqlCommand sc = new SqlCommand("SELECT PROFCODE,PROFNAME FROM PROFNAMES$ WHERE (PROFNAME LIKE '" + textBox1.Text + "%') AND PROFCODE NOT IN (SELECT PROFCODE FROM MAP) ORDER BY Profname desc ", con);
  sc.ExecuteNonQuery();
  SqlDataAdapter sda = new SqlDataAdapter(sc);
  DataTable data = new DataTable();
  sda.Fill(data);
  dataGridView1.DataSource = data;
  </code></pre>