Merge dataset into identical table?

  • Thread starter Thread starter Chris Ashley
  • Start date Start date
C

Chris Ashley

Hi there,

If i have a dataset which has a datatable which has fields matching an
existing SQL Server DB Table exactly, is there an easy way to merge all
the records from the datatable into my SQL table without having to
write a stored procedure or SQL insert statement?

Cheers,

Chris
 
No - but if the table has a key what you can do is create two dataadapter
and set the AcceptChangesDuringFill property of the first adapter to false.
Then you can use a CommandBuilder for the second, and call Update on it
passing in the newly filled dataset to it. The commandbuilder will
effectively write the Insert statement, but short of that, there's no
automagic way. Obviosuly you could use DTS to move data around, but not
between a System.Data.DataTable natively.
 
W.G. Ryan - MVP said:
No - but if the table has a key what you can do is create two dataadapter
and set the AcceptChangesDuringFill property of the first adapter to false.
Then you can use a CommandBuilder for the second, and call Update on it
passing in the newly filled dataset to it. The commandbuilder will
effectively write the Insert statement, but short of that, there's no
automagic way. Obviosuly you could use DTS to move data around, but not
between a System.Data.DataTable natively.
Click to expand...

Thanks for that - wouldn't have thought of doing it that way myself.
Seems to work a charm!

Chris
 
Back
Top