Copy a DataRow from one DataTable to another

[Shawn]

Hi. I have 2 DataTables, dataTable1 and dataTable2. dataTable1 contains a
DataRow that I need to insert at index 5 in dataTable2. Here is my code:

For Each dataRow1 In dataTable1.Rows
If dataRow1.Item("id") = "3353" Then
dataRow2 = dataRow1
End If
Next
dataTable2.Rows.InsertAt(dataRow2, 5)

The line above gives me this error: System.ArgumentException: This row
already belongs to another table.
What is the right way to do this?

Thanks,
Shawn

[Craig Deelsnyder]

Shawn wrote:

Hi. I have 2 DataTables, dataTable1 and dataTable2. dataTable1 contains a
DataRow that I need to insert at index 5 in dataTable2. Here is my code:

For Each dataRow1 In dataTable1.Rows
If dataRow1.Item("id") = "3353" Then
dataRow2 = dataRow1
End If
Next
dataTable2.Rows.InsertAt(dataRow2, 5)

The line above gives me this error: System.ArgumentException: This row
already belongs to another table.
What is the right way to do this?

Thanks,
Shawn

Try dataTable2.ImportRow method instead...

--
Craig Deelsnyder
Microsoft MVP - ASP/ASP.NET

[Shawn]

Yes, but what do I have to do to get the new DataRow into index 5 in the
DataTable?

Shawn
"Craig Deelsnyder" <cdeelsny@NO_SPAM_4_MEyahoo.com> wrote in message
news:#W**************@tk2msftngp13.phx.gbl...

Shawn wrote:

Hi. I have 2 DataTables, dataTable1 and dataTable2. dataTable1 contains a DataRow that I need to insert at index 5 in dataTable2. Here is my code:
For Each dataRow1 In dataTable1.Rows
If dataRow1.Item("id") = "3353" Then
dataRow2 = dataRow1
End If
Next
dataTable2.Rows.InsertAt(dataRow2, 5)

The line above gives me this error: System.ArgumentException: This row
already belongs to another table.
What is the right way to do this?

Thanks,
Shawn

Try dataTable2.ImportRow method instead...

--
Craig Deelsnyder
Microsoft MVP - ASP/ASP.NET

[Robbe Morris [C# MVP]]

Why bother? You can use the .Select method to return an array of DataRows
in any order you want. At the very least, you could add a dummy column to
your
table at runtime as a column to sort on and populate based on your business
logic.

--
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net/home/listings.aspx

"Shawn" <bo********@hotmail.com> wrote in message
news:e9**************@TK2MSFTNGP09.phx.gbl...

Yes, but what do I have to do to get the new DataRow into index 5 in the
DataTable?

Shawn
"Craig Deelsnyder" <cdeelsny@NO_SPAM_4_MEyahoo.com> wrote in message
news:#W**************@tk2msftngp13.phx.gbl...

Shawn wrote:

> Hi. I have 2 DataTables, dataTable1 and dataTable2. dataTable1 contains a > DataRow that I need to insert at index 5 in dataTable2. Here is my code: >
> For Each dataRow1 In dataTable1.Rows
> If dataRow1.Item("id") = "3353" Then
> dataRow2 = dataRow1
> End If
> Next
>
>
> dataTable2.Rows.InsertAt(dataRow2, 5)
>
> The line above gives me this error: System.ArgumentException: This row
> already belongs to another table.
> What is the right way to do this?
>
> Thanks,
> Shawn
>
>

Try dataTable2.ImportRow method instead...

--
Craig Deelsnyder
Microsoft MVP - ASP/ASP.NET