title: How do I fill a single row with a dataadapter (or otherwise)
body: <p>I have a mysql database on phpmyadmin.
  one of the tables in the database has a primary key field and I want to select a record from the database with a specific primary key. obviously this will only return 1 row however I am at a loss as to how I can run the query and then put the result into a single datarow object. all the da.fill overloads require a datset and while this is possible it feels inefficient to define a dataset and always reference it as: </p>
  
  <pre><code>dataset.tables("table").rows(0).item.....
  </code></pre>
  
  <p>when I could be using:</p>
  
  <pre><code>row.item.....
  </code></pre>
  
  <p>TL;DR, how can I populate a datarow with a dataadapter in vb.net?</p>