title: DataAdapter Update command
body: <p>I'm using a <code>DataAdapter</code> and <code>DataTable</code> to edit/add data in a <em>Oracle db</em> table, using <em>ODP.NET</em> provider.</p>
  
  <pre><code>DataSet ds = new DataSet("report");
  DataTable dt = new DataTable("report");
  adptr = new OracleDataAdapter();
  string myCmd = "select * from report";            
  
  OracleCommand _cmd = new OracleCommand(myCmd, myDbConnection);
  
  adptr.SelectCommand = _cmd;
  adptr.Fill(dt);
  ds.Tables.Add(dt);
  </code></pre>
  
  <p>After this i alter the data in the data table, by binding it to a grid and editing it and save like this :</p>
  
  <pre><code>OracleCommandBuilder _cmdBld = new OracleCommandBuilder(adptr);
  adptr.Update(ds, "report");
  </code></pre>
  
  <p>Everything great by now, it works as it's supposed to, every modification gets commited to the <em>DB</em>.
  But my problem is the following - when i get data from more than one table.
  like this :</p>
  
  <pre><code>string myCmd = 
      "select r.id, u.username, r.creation_date, r.owner 
       from report r inner join users u on r.user_id == u.id";
  </code></pre>
  
  <p>I know I could write the <code>DataAdapter</code>'s update command manually (<code>DataAdapter.UpdateCommand</code>) , before saving, but i'm not sure how. Can you give me some directions? </p>
  
  <p>Thanks!</p>