Save As

  • Thread starter Thread starter John Grant
  • Start date Start date
J

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
 
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.
 
Back
Top