title: Dataset does not reflect new primary key after insert
body: <p>This is my first question here and please excuse me with this presenting style.</p>
  
  <p>I have a MySQL table <code>categories</code> with following columns:</p>
  
  <ul>
  <li>c_id (<em>auto-increment</em>)</li>
  <li>c_code</li>
  <li>c_name</li>
  </ul>
  
  <p>Here is what I am trying to do;</p>
  
  <ul>
  <li>dataset contains one table - <code>categories</code></li>
  <li>add a row to dataset (new category)</li>
  <li>update database using <code>mysqldataadaptor</code>'s <code>update()</code> method</li>
  <li>view dataset entries in a datagridview</li>
  </ul>
  
  <p>Problem is after I insert new row, my dataset's relevant row does not show the last inserted primary key (auto-generated one). But it shows the values. </p>
  
  <p>This is the code where I add new row</p>
  
  <pre><code>var dr = ds.Tables["categories"].NewRow();
      dr["c_code"] = "tst123";
      dr["c_name"] = "123tdt";
  ds.Tables["categories"].Rows.Add(dr);
  </code></pre>
  
  <p>This is the code where I update database</p>
  
  <pre><code>adp.Update(ds.Tables[tempTableName]);
  </code></pre>
  
  <p>and finally this is how I view the dataset <strong>SOON AFTER</strong> above line</p>
  
  <pre><code>dataGridView1.DataSource = ds.Tables["categories"];
  </code></pre>
  
  <p>PROBLEM:<br>
  In the gridview only <code>c_code</code> and <code>c_name</code> appear there. </p>
  
  <p>How do I get the last inserted <code>id</code> to dataset?</p>