This Row Already Belongs To Another Table.

Hey,

I have a function that executes a query and fill the result in a dataset then return the row as following :

Public Function get_item_row(ByVal query, ByVal ordernum, ByVal theitemid, ByVal center) As DataRow

Dim conn As New SqlConnection(System.Configuration.ConfigurationManager.AppSettings("conn"))

Dim adbooks As New SqlDataAdapter

Dim Str As String

Dim result As New DataSet

Dim MyDataRow As DataRow

adbooks.SelectCommand = New SqlCommand

adbooks.SelectCommand.Connection = conn

Str = "select * from " & query & " where ordernum=" & ordernum & " and theitemid=" & theitemid & " and center='" & center & "'"

adbooks.SelectCommand.CommandText = Str

adbooks.Fill(result)

If (result.Tables(0).Rows.Count > 0) Then

MyDataRow = result.Tables(0).Rows(0)

Else

MyDataRow = Nothing

End If

Return MyDataRow

End Function

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

then i am calling that function as following:

Dim MyRow As DataRow

MyRow = b_list.get_item_row(query, theorder_b, theitemid_b, center)

then i am adding that row to a datatable:

Dim updateTable As New DataTable

updateTable.Rows.Add(MyRow)

and then i am gettin the error!

plz help

thx

Hiba