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

Answer 1

Use

newtable.ImportRow(oldtable.Rows[i]) 

where i is the desired row number.

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

Answer 2

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