Strange error on DataRow: 'This row already belongs to another table' 2

[DotNetter]

When I run the following code:

	Friend Function FillUsersPropertiesFromDataset(ByVal ds As DataSet) As UserAccountManagerDLL.User()
		If ds.Tables.Count <> 1 Then Exit Function
		If ds.Tables(0).Columns.Contains("PropertyName") = False Then Exit Function
		If ds.Tables(0).Columns.Contains("PropertyValue") = False Then Exit Function

		Dim arrUsers(0) As UserAccountManagerDLL.User
		Dim oUser As UserAccountManagerDLL.User
		Dim oRow As DataRow
		Dim CurrentUserIdentifier As Integer = 0

		Dim dsTemp As New DataSet
		Dim dtTemp As New DataTable
		dsTemp.Tables.Add(dtTemp)

		For Each oRow In ds.Tables(0).Rows
			If CurrentUserIdentifier <> oRow("ClassInstanceIdentifier").ToString And CurrentUserIdentifier <> 0 Then
				CreateUserObjectAndInsertIntoUsersArray(ds, oRow, dsTemp, arrUsers)
			End If

			[b][COLOR=red]dsTemp.Tables(0).Rows.Add(oRow)[/color][/b]
			CurrentUserIdentifier = oRow("ClassInstanceIdentifier")
		Next
		CreateUserObjectAndInsertIntoUsersArray(ds, oRow, dsTemp, arrUsers)

		Return arrUsers

	End Function

I get the following error on the line in red text:

[tt]An unhandled exception of type 'System.ArgumentException' occurred in system.data.dll
Additional information: This row already belongs to another table.[/tt]

How, please, do I remedy this?

Thanks!
Dot

 

[ThatRickGuy]

You can't add a row to a data table if that row already belongs to a data table. Check out the rows.Import(datarow) method instead.

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[DotNetter]

Rick, thanks for the reply.

I can't find any [tt]Import[/tt] method at all...

Dot

 

[ThatRickGuy]

maybe it was datatable.importrow(datarow) something like that.

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[chrissie1]

dsTemp.Tables(0).importrow(oRow)


Christiaan Baes
Belgium

I just like this --> [Wiggle] [Wiggle]

 

[DotNetter]

Thanks so much Rick (and Chrissie, too!) !!!
Dot