Moving data between datatables

12 May 2006 9:58 PM

noel

I have two data tables and I need to move data from datatable to the other.
The two data tables are not exactly the same so I cannot merge. Moving the
data is based on a field in datatable1 that maps to datatable2. The only
way to do this I assume is to loop through table1 and use table1.fieldmap to
get the value in table2. Any suggestions?

Thanks

13 May 2006 7:50 AM

Cor Ligthert [MVP]

Noel,

As they are in one datatasets and there is a one to one or one to many
relation, you can use the relation as well. Probably will looping be the
best. If you don't do it, probably it is done than behind the scene.

Cor

Show quote

"noel" <n***@hasnoemail.com> schreef in bericht
news:O$z4L8gdGHA.3840@TK2MSFTNGP04.phx.gbl...
>I have two data tables and I need to move data from datatable to the other.
>The two data tables are not exactly the same so I cannot merge. Moving the
>data is based on a field in datatable1 that maps to datatable2. The only
>way to do this I assume is to loop through table1 and use table1.fieldmap
>to get the value in table2. Any suggestions?
>
> Thanks
>