move data from one datatable to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,
I have 2 datatable, "dt1" and "dt2"
I would like to know what is the best way to move the data across?
I just want to move all the data from "dt1" which the "Category" column is
"CatA" to "dt2", so the data will no longer left in "dt1".

please help, many thanks.
 
hi
You can do it many way , really depend on your schema . the most strait
forward why it loop on rows and move the values one by one to the new table
( if you are going to do this operation only once I would recommend you do
it that way as it the most close to make sure of data integrity ) .
Mohamed Mahfouz
MEA Developer Support Center
ITworx on behalf of Microsoft EMEA GTSC
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy data from another datasets 1
Update one DataTable from another 8
SQL query on Datatables [VB 2005] 7
Returning multiple resultsets usind datadreader 11
Copy a Subset of Datatable 2
question about dataset merge 1
DateTimePicker 2
Running parameter queries from VBA, suppressing parameter prompts 4

Back
Top