I have a form full of controls bound to a DataTable. This DataTable is one of two in the DataSet, each filled
by their respective DataAdapters and the data source amended accordingly by the DataAdapters Insert/Update/Delete
I want to build up my data base using my form, but in most cases each record I want to add is slightly different to the last. Instead of re-entering all the data into each control, I want to fill my form with a record (select command), make a slight change and then save it as a new record (insert command).
The myDataAdapter.Update(MyDataSet.MyDataTable1) will overwrite my original record. How do I explicitly insert the amended record as a new record in the data source?