title: Find a row in dataGridView based on column and value
body: <p>I have a dataGridView that has 3 columns: SystemId, FirstName, LastName that is bound using database information.  I would like to highlight a certain row, which I would do using:</p>
  
  <pre><code>dataGridView1.Rows[????].Selected = true;
  </code></pre>
  
  <p>The row ID I however do not know and the bindingsource keeps changing, thus row 10 could be "John Smith" in one instance but not even exist in another (I have a filter that filters out the source based on what user enters, so typing in "joh" would yield all rows where first / last name have "joh" in them, thus my list can go from 50 names to 3 in a click).  </p>
  
  <p>I want to find a way how I can select a row based on SystemId and a corresponding number.  I can get the system ID using the following method:</p>
  
  <pre><code>systemId = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["SystemId"].Value.ToString();
  </code></pre>
  
  <p>Now I just need to apply it to the row selector.  Something like dataGridView1.Columns["SystemId"].IndexOf(systemId} but that does not work (nor does such method exist).  Any help is greatly appreciated.</p>