title: Finding a specific value in a datatable row
body: <p>I am trying to search a datatable for a specific value, which is based on an ID. In sql it would be something like:</p>
  
  <pre><code>Select FIlepath Where ID = 'x'
  </code></pre>
  
  <p>but so far I have had no luck, I have tried a few methods including passing the entire row into an array and selecting the value from the array but nothing has worked so far.</p>
  
  <p>However I just found the .Where function for searching a datatable and thought this might be the quickest, cleanest way to do things. But it requires a predicate.</p>
  
  <p>The below code is what I have for this at the moment but I think the problem is with the "ofString" part of the code.</p>
  
  <pre><code>objDataTable_FailCodeDetails.Select(("FilePath")).Where(Of String("ID ='" &amp; i - 1 &amp; "'"))
  </code></pre>
  
  <p>Any help would be greatly appreciated.</p>
  
  <p>cheers.</p>