Copy rows from one Datatable to another DataTable

Question

How can I copy specific rows from DataTable to another Datable in c   There will be more than one row

User · Answer

For those who want single command SQL query for that:

INSERT INTO TABLE002 
(COL001_MEM_ID, COL002_MEM_NAME, COL002_MEM_ADD, COL002_CREATE_USER_C, COL002_CREATE_S)
SELECT COL001_MEM_ID, COL001_MEM_NAME, COL001_MEM_ADD, COL001_CREATE_USER_C, COL001_CREATE_S
FROM TABLE001;

This query will copy data from TABLE001 to TABLE002 and we assume that both columns had different column names.

Column names are mapped one-to-one like:

COL001_MEM_ID -> COL001_MEM_ID

COL001_MEM_NAME -> COL002_MEM_NAME

COL001_MEM_ADD -> COL002_MEM_ADD

COL001_CREATE_USER_C -> COL002_CREATE_USER_C

COL002_CREATE_S -> COL002_CREATE_S

You can also specify where clause, if you need some condition.

User · Answer

Check this out  you may like it  previously  please  clone table1 to table2    table1 AsEnumerable   Take recodCount  CopyToDataTable table2 LoadOption OverwriteChanges     Or   table1 AsEnumerable   Where   yourcondition     CopyToDataTable table2 LoadOption OverwriteChanges

User · Answer

There is better way to do this  DataTable targetDataTable   new DataTable    targetDataTable   changedColumnMetadata AsEnumerable   Where dataRow   gt  entityName Equals dataRow  quot EntityName quot     CopyToDataTable    Please try this and let me know in case of any issues

User · Answer

below sample would be the fastest way to copy one row  each cell is being copied based on the column name  in case you dont need a specific cell to copy then have a try catch or add if  if your going to copy more than 1 row then loop the code below   DataRow dr   dataset1 Tables 0  NewRow    for  int i   0  i  lt  dataset1 Tables 1  Columns Count  i          dr dataset1 Tables 1  Columns i  ColumnName    dataset1 Tables 1  Rows 0  i      datasetReport Tables 0  Rows Add dr     dataset1 Tables 1  Rows 0  i   change the index 0 to your specified row index or you can use a variable if your going to loop or if its going to be logical

User · Answer

To copy whole datatable just do this   DataGridView sourceGrid   this dataGridView1  DataGridView targetGrid   this dataGridView2  targetGrid DataSource   sourceGrid DataSource

User · Answer

Copy Specified Rows from  Table to another     here dttablenew is a new Table  and dttableOld is table Which having the data   dttableNew    dttableOld Clone       foreach  DataRow drtableOld in dttableOld Rows       if    put some Condition                dtTableNew ImportRow drtableOld

User · Answer

Try This      String matchString  ID0001   assuming we have to find rows having key ID0001     DataTable dtTarget   new DataTable        dtTarget   dtSource Clone        DataRow   rowsToCopy      rowsToCopy   dtSource Select  key      matchString             foreach  DataRow temp in rowsToCopy                dtTarget ImportRow temp

User · Answer

I ve created an easy way to do this issue  DataTable newTable   oldtable Clone         for  int i   0  i  lt  oldtable Rows Count  i          DataRow drNew   newTable NewRow           drNew ItemArray   oldtable Rows i  ItemArray         newTable Rows Add drNew

User · Answer

foreach  DataRow dr in dataTable1 Rows        if     some condition             dataTable2 Rows Add dr ItemArray       The above example assumes that dataTable1 and dataTable2 have the same number  type and order of columns

User · Answer

You can do it calling the DataTable Copy   method  for example     DataSet ds   new DataSet       System Data DataTable dt   new System Data DataTable       dt    BOSearchView DS Tables BusLib TPV TableName SearchView  Copy       ds Tables Add dt      UltGrdSaleExcel SetDataBinding ds  dt TableName  true

User · Answer

private void CopyDataTable DataTable table           Create an object variable for the copy       DataTable copyDataTable       copyDataTable   table Copy            Insert code to work with the copy

User · Answer

Supported in  4  3 5 SP1  you can now just call a method on the object   DataTable dataTable2   dataTable1 Copy

User · Answer

As a result of the other posts  this is the shortest I could get   DataTable destTable   sourceTable Clone    sourceTable AsEnumerable   Where row   gt     condition      ToList   ForEach row   gt  destTable ImportRow row

[c#] Copy rows from one Datatable to another DataTable?

Examples related to c#

Examples related to datatable