Copy the rows of Datatabe to another DataTable

sometimes we need to make a complex filter for each row of a DataTable, and then filter out the rows to be added to another DataTable:
for example: DT. Rows.Add (DR) if the DR is coming to another DataTable, it will be an error: Dr is already part of another DataTable
This is what we need to use: dt. Rows.Add (Dr.ItemArray) is equivalent to copying an array and adding it to the new DataTable


Here is an example of copying a row of DT1 data into a DT2
dim dt1=executeselect ("SELECT * from dual")    
dim dt2=dt1. Clone ()

for each Dr. in Dt1. rows      

    DT2. Rows.Add (Dr. ItemArray)
NEXT 

Original address: http://bbs.delit.cn/thread-649-1-1.html

Reprint please specify the source:

Author: metric Technology http://bbs.delit.cn/thread-649-1-1.html

Copy the rows of Datatabe to another DataTable