title: how to return single row using TableAdapter
body: <p>Hi I am currently using TableAdapter that returns a dataTable, which is fine to use when result table should have more than one row like :</p>
  
  <pre><code>MyItemsDataTable myItemsDataTable = Adapter.GetAllItems();  
  </code></pre>
  
  <p>but if we need only one row as a result, say an item, which has a particular ID</p>
  
  <pre><code>MyItemsDataSet.MyItemRow  itemRow = Adapter.GetItemByID(id)[0];  
  </code></pre>
  
  <p>how can I make Adapter to return one row instead of DataTable.
  I am using DataSet Designer wizard and gives me two options for putting in SELECT statement</p>
  
  <pre><code>Use SQL statements --&gt;  Select which return rows
  (returns one or many rows)
  Use SQL statements --&gt;  Select which returns a single value rows
  (returns a single value) 
  </code></pre>
  
  <p>and using similar query</p>
  
  <pre><code>SELECT * from
  FROM  FOOD_ITEMS
  WHERE (ITEM_ID = @ITEM_ID)
  </code></pre>
  
  <p>Do I need to override this method or add a new one ?</p>
  
  <pre><code>public virtual MyItemsDataSet.MyItemsDataTable  GetItemByID(int ITEM_ID)
  </code></pre>
  
  <p>probably something like </p>
  
  <pre><code>public virtual MyItemsDataSet.MyItemRow GetItemByID(int ITEM_ID)
  </code></pre>
  
  <p>If so, I cannot do it in designer generated file !! where can I do this ?</p>
  
  <p>Thanks</p>