title: How to update two tables with one dataset?
body: <p>I have a dataset with data from two SQL tables in.</p>
  
  <p>How can I update both tables with the updated dataset? (since join does not work)</p>
  
  <pre><code>             da = new SqlDataAdapter("select * from xxxx join.....", conn);
               builderForTable1 = new SqlCommandBuilder(da);
               da.Update(dataSetEmp, "Table");
  </code></pre>