title: How to select and scroll to new Row in Datagridview?
body: <p>I have a DataGridView bound to a DB Table.
  The DataGridView is not editable, there are some text fields where the data can be edited, which is controlled with buttons.
  I have a NewRow Button with the following code:</p>
  
  <pre><code>        dataGridView1.AllowUserToAddRows = true;
          foreach (DataGridViewRow row in dataGridView1.Rows)
          {
              if (row.Selected)
              { row.Selected = false; }
          } 
          dataGridView1.Rows[dataGridView1.NewRowIndex].Selected = true;
  </code></pre>
  
  <p>Wat I need is:</p>
  
  <ul>
  <li>the datagridview should scroll to the bottom (where the newRow is)</li>
  <li>the newRow should be focused, so that the textfields show the new (empty) row (content)</li>
  </ul>
  
  <p>I've tried:</p>
  
  <pre><code>        bindSourceGS.Position = dataGridView1.NewRowIndex;
  </code></pre>
  
  <p>but that doesn't select the datagridview's newRow.
  I want to use the datagridview's newRow because when user presses cancel button I don't have to delete the row in the Dataset and the datagridview.Rows[i] has a IsNewRow Property.</p>