copy datagrid to table

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

Is the new table already in the DB?

Yes it is

Ok, I'll do a quick demo when I get home.

Thanks for the help DevGrp!
:D

1 Attachment(s)

Here ya go. This was compile with VS.NET 2003 BTW

haven't had a chance to run with it yet...but thanks for the file!!