title: How to select data from datatable
body: <p>I am little bit stuck here .. I have a datatable as _</p>
  
  <pre><code>Dim dtPupil As New DataTable
  
  dtPupil.Columns.Add("PupilId", GetType(Integer))
  dtPupil.Columns.Add("Forename", GetType(String))
  dtPupil.Columns.Add("Surname", GetType(String))
  </code></pre>
  
  <p>I made a select (assuming names combination will be unique)</p>
  
  <pre><code>Dim strQuery As String = "Forename ='" &amp; forename &amp; "' and Surname = '" &amp; surname &amp; "'"
  Dim dr As DataRow()
  dr = dTablePupil.Select(strQuery)
  </code></pre>
  
  <p>I wanna have <code>PupilId</code> as an Integer of the row that match, so</p>
  
  <pre><code>Dim PupilID As Integer = ?????????? 
  </code></pre>
  
  <p>What do I need to write here? There will only be 1 row returned.</p>