Inserting records from a DataSet into a second table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi;

This has me confused.

I have a dataset which was populated from one database. Can I insert this
dataset's rows into a different database table using the same dataAdapter
or would I have to create a second adapter?

Isn't a dataTable just an memory resident data table ?

So I am thinking that I could iterate through it's rows and call inserts on
my other
table as I do ?

Or do I need another approach ?

Thanks
 
Gordon,

In my idea is as you ask it the most simple way to create everytime a new
row in your receiving table and than copy the itemarray. Be aware that you
should add it after that you are sure the key is put in the row and not
before.

I hope this helps,

Cor
 
Back
Top