Hell all,

   I wanted to do something which I though was fairly simple, but I seem to be have trouble finding how to do it.
   What I want to do is copy rows from a dataset table into another table in another dataset. (ex ds1.table(0).rows.copyto ds2.table(0)) The schemas are exactly the same. I can't seem to find the right syntax. Can anyone help?

Thanks,

Jim

You can copy a datatable entirely by:

ds2.tables.add(ds1.tables(0).copy())

I believe there may be a copy() method for the row too, but I'm not sure.

Brian

thanks, but I do not want to copy the entire table since I have the structure setup already. I am using ImportRow() and that works, however I am getting NULLs on the key column. That is the new problem :)

thanks again

Hey,

You can't add a row to two tables, because it gives you an ownership error, I believe if I remember correctly...

Brian