How can copy a row from one DataTable to another DataTable?

[angus234]

Hi all,

 

Assume that both DataTable are the same schema, I want to copy a row from one DataTable to another DataTable by

 

m_dtItem.Rows.Add(m_dtOrgItem.Rows(0))

 

However, it said that

 

Exception Details: System.ArgumentException: This row already belongs to another table.

 

So, How can copy a row from one DataTable to another DataTable?

 

Thank you.

[kejpa]

Hi,

Haven't tried it (and I know giving non-tested tips is a death penalty crime...) but what if you create a new row, put the row to be copied into that row and then add it to the destination table?

 

dim NewRow as DataRow=m_dtItem.NewRow
NewRow=m_dtOrgItem.Rows(0)
m_dtItem.Rows.Add(NewRow)

 

HTH

Kejpa

[Nerseus]

Look at the ImportRow method of the DataTable.

 

-ner