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/lib...addatarow.aspx
Others like more the ItemArray property from the datarow
http://msdn2.microsoft.com/en-us/lib...itemarray.aspx
I hope this gives an idea,
Cor
"John" <Jo**@nospam.infovis.co.ukschreef in bericht
news:eK**************@TK2MSFTNGP05.phx.gbl...
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