title: Keep adding query results to datatable
body: <p>I have a dataset which contains two tables.  Table[0] gets filled with multiple rows.  I then need to iterate those rows and for each row run another query and fill those results to Table[1].  What is the correct way to fill a dataset with multiple rows within a loop?  Abbreviated code sample of where I am:</p>
  
  <pre><code> DataSet ds = new DataSet();
      sql = myquery1;
      SqlDataAdapter da = new SqlDataAdapter(sql, conn);
      da.Fill(ds, "Products");
  
  foreach (DataRow dr in ds.Tables[0].Rows)
  {
     productID = ds.Tables[0].Rows[0]["ProductID"].ToString();
  
     if (productID != String.Empty)
     {
        sql = String.Empty;
        sql = myquery2 where productID = 'xxxxx'
        da = new SqlDataAdapter(sql, conn);
        da.Fill(ds, "ProductProperties");
      }
  }
  </code></pre>
  
  <p>This fills the "ProductProperties" datatable on the first loop but doesn't add future results.  What's the right way to keep adding multiple result sets to the datatable?</p>