title: Quick way to insert the same record as copy using Tableadapter
body: <p>I have a datatable with a bunch of fields, and it's filled data by tableadapter. Usually, records that need to be inserted are a little bit different (only id). I don't want user to retypes everything again so, is there a quick way to insert current record into database. Notice that all my insert, update and delete operations are based on my tableadapter.</p>
  
  <pre><code>//Get only one last record that has been added when the form load.
  bookTableAdapter.FillByLastID(bookDataSet.dtBook);
  
  private void btnNew_Click(object sender, EventArgs e)
  {  
    bookBindingSource.AddNew();  
  }
  
  private void btnSave_Click(object sender, EventArgs e)
  {
    this.Validate();
    bookBindingSource.EndEdit();
    bookTableAdapter.Update(bookDataSet.dtBook);
  }
  </code></pre>