copy a single row from one datatable to other

Question

I have two datatables one has few rows other is empty. I am running a loop over first one to copy some of the rows to another table. I am getting error 'The row already belongs to another table'.

Is there any way to copy DataRows one by one to other DataTable.

thanks in advance

I'm sure that if you show the code you will get a very fast (and right) answer — Steve, Apr 26 '12 at 08:59
sorry Steve, I cant publish code due to some reason. btw got the answer, thanks all — MaxRecursion, Apr 26 '12 at 09:23

Nikhil Agrawal · Accepted Answer · 2017-06-27T11:15:44.493

29

Use

newtable.ImportRow(oldtable.Rows[i])

where i is the desired row number.

as explained in http://support.microsoft.com/kb/308909/en-us

edited Jun 27 '17 at 11:15

answered Apr 26 '12 at 09:06

Nikhil Agrawal

47,018
22
121
208

score 3 · Answer 2 · edited Aug 07 '17 at 11:36

3

copy the ItemArray, of course just works when the columns are the same

var dtCopyTo = new DataTable();
foreach(var rowCopyFrom in dtCopyFrom.Rows)
{
    var updatedDataRow = dtCopyTo.NewRow();
    updatedDataRow.ItemArray = rowCopyFrom.ItemArray;
    dtCopyTo.AddRow(updatedDataRow);
}

ps: code is typed without ide so check syntax pls

edited Aug 07 '17 at 11:36

Community

1
1

answered Apr 26 '12 at 08:59

blindmeis

22,175
7
55
74

copy a single row from one datatable to other

2 Answers2