title: programmatically select a row based on gridview values
body: <h3>What I have</h3>
  
  <p>I have a DataGridView with 3 columns (metric_key, metric_name, metric_value).</p>
  
  <p>There are for example, 6 ROWS in this table (6 different metrics), added programmatically (DGV is not bound in any way)</p>
  
  <p>Now, when I assign values in my grid I do: </p>
  
  <pre><code>dataGridView1.item("Metric_value",0).value = "value of the metric in row 0, in the column named "metric_Value".
  </code></pre>
  
  <h3>What I'd like</h3>
  
  <p>However I'm looking for a way to use the value in the <code>metric_Key</code> column to do my assignment, something like:  </p>
  
  <pre><code>datagridView1.item("metric_Value","My_metric_Key")   
  </code></pre>
  
  <p>instead of putting the row ID, or maybe:</p>
  
  <pre><code>datagridview1.item("metric_value",Indexof("My_metric_Key"))
  </code></pre>
  
  <p>Or </p>
  
  <pre><code>datagridview1.item("metric_value",findValue("my_metric_key","metric_key"))
  </code></pre>
  
  <p>etc.</p>
  
  <p>I don't want to create any other objects (dataview, etc.).</p>
  
  <p>How can I do this?</p>