I have a datagrid that i have populated from a sql server 200 database. Once the user modifies the data it is to be saved into a new table. How would i go about doing this.?
I have tried to populate a dataadapter with the data, then save it to a ataset and then to the table but have no idea how to start.

I would usually just
Code:
myDataAdapter.Update(myDataSet, "infoTrack_Supplier")
update the adapter to save the changed data but i need all new info saved to new table.

Thanks for any ideas