hopefully correct what I understand
add this in your code :
vb Code:
  1. adapter.Update(DataSet1, "table2")
  2. DataSet1.AcceptChanges()