Manipulating data between data adapters

[John]

Hi

I have two data adapters bound to two separate tables. How can I;

1. Loop through all records one by one in one of them while reading column
values, and

2. Insert a record from data adapter A into data adapter B

via code?

Thanks

Regards

 

[Cor Ligthert [MVP]]

John,

Don't call those things DataAdapters. It are DataSets, to be more precise
Strongly Typed DataSets.

A datarow in a table has a reference set to that table in the datarow. That
is needed to know the description of the items which are in the Columns
collection, even if it is not in the table.

As well is there often not one row, but two rows, the original one and the
current one in a datatable.

All this makes it difficult to pull a row from one table and to place it in
the other.

The receiving table to be a clone of the sending one.

Therefore it is mostly only possible to create a datarow in whatever way in
the new table and than to fill the items for that.

For that I like very much the loaddatarow from the datatable
http://msdn2.microsoft.com/en-us/library/system.data.datatable.loaddatarow.aspx

Others like more the ItemArray property from the datarow
http://msdn2.microsoft.com/en-us/library/system.data.datarow.itemarray.aspx

I hope this gives an idea,

Cor

 

[Miha Markic [MVP C#]]

Hi John,

I would use two commands and two connections.
One command should read data while the other should write.
But you'll need two connections - one per each command as reading needs a
conneciton opened all the time.

 

[William \(Bill\) Vaughn]

Ah no. Do not use ADO.NET for this (or any data access query interface). Use
an INSERT to move the rows on the server (the database engine). Don't bring
rows to your client to do bulk updates.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________