By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,088 Members | 992 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,088 IT Pros & Developers. It's quick & easy.

move data from one datatable to another

P: n/a
Jon
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.
Nov 21 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.