Inserting records from a DataSet into a second table

[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

 

[Cor Ligthert [MVP]]

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