copy a single row from one datatable to other

c# asp.net ado.net datatable datarow
MaxRecursion picture MaxRecursion · Apr 26, 2012 · Viewed 54.1k times · Source

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

Nikhil Agrawal picture Nikhil Agrawal · Apr 26, 2012

Use

newtable.ImportRow(oldtable.Rows[i])

where i is the desired row number.

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

Related questions

How to change the DataTable Column Name?

I have one DataTable which has four columns such as StudentID CourseID SubjectCode Marks ------------ ---------- ------------- -------- 1 100 MT400 80 2 100 MT400 79 3 100 MT400 88 Here I am inserting this Datatable into the Sql server table by passing this datatable as an XML Table. …

Read More
IEnumerable to string

I have a DataTable that returns IDs ,1 ,2 ,3 ,4 ,5 ,100 ,101 I want to convert this to single string value, i.e: ,1,2,3,4,5,100,101 How can i rewrite the following to get a single string var _values = _tbl.AsEnumerable().Select(x => x);

Read More
Call a stored procedure with parameter in c#

I can do a delete, insert and update in my program and I try to do an insert by call a created stored procedure from my database. This a button insert I make work well. private void btnAdd_Click(object …

Read More