title: Fill a DataRow from SQL
body: <p>I'm aware of retrieving SQL Server CE data into various data types such as strings, ints, dataTables etc etc. But in this case I'm cycling through an infragistics <code>SelectedRowsCollection</code> using a <code>foreach</code> loop and doing some checks on each record.</p>
  
  <p>Based on the checks that I perform, I want some of these records to be added to a <code>DataTable</code>. What I'm doing is adding them to a table in my database, then selecting that information as a single row (there are other reasons for this, dont mind them). What is the best way of combining lots of single rows of data into on <code>DataTable</code>?</p>
  
  <p>I tried to use a <code>SqlCeDataAdapter</code> fill function, but it does not contain an overload that handles a single <code>DataRow</code>. Any ideas?</p>
  
  <p>I'm using SQL Server CE.</p>
  
  <p>To summarize, my question is: how do I get a single row from SQL Server CE to be added as a row in a <code>DataTable</code>?</p>