Save As

[John Grant]

I have a dataset with data populated with the adapter's select command from
SQL Server. I have changes some of the keys and would like to save the
dataset as new rows and not update the existing ones (i.e. Save As). Any
easy way to do that? Must I manually move one dataset to another?

thanks

 

[Miha Markic [MVP C#]]

Hi John,

Set adapter.AcceptChangesDuringFill = false.
When you load all rows they will be all marked as Added.
Change the rows you want, invoke AcceptChanges on those that you want to
insert and fire adapter.Update() method.