DataTable belongs to another DataSet

bmains · August 14th, 2003, 12:33 PM

Hello,

I'm trying to pass a DataTable back from a function, and would like to incorporate it into another DataSet. This is my function:

Code:

Function GetData(...) as DataTable
    ...

    objAdapter.Fill(objDataSet, "Data")
    return objDataSet.Tables("Data")
End Function

I want to insert the table into a new dataset back in the caller (because I got to call 4 GetData() methods in different classes). I am having problems, because I can't use the notation

Code:

objDataSet.Tables.Add(objTable)

because it says the table belongs to another dataset. So I changed it to do

Code:

objDataSet.Tables.Add(objTable.Clone())

, but the Clone() method only clones the structure, so I lose the data, and you can't clone each row separately...

Any ideas?

Thanks,

Brian Mains

bani · September 20th, 2003, 10:51 AM

Use Copy. It copies both the schema and the data.

dwhite · December 20th, 2005, 12:24 AM

Sorry for the resurrection, but found a far better solution, this doesn't have the overhead that a copy does. Copy would be a nightmare if this general function was used reasonably often.

Code:

Function GetData(...) as DataTable
    ...

    objAdapter.Fill(objDataSet, "Data")

    Dim tmpTable As DataTable
    ' Remembering that the assignment operator doesn't copy the whole object, just a reference to the object.
    tmpTable = objDataSet.Tables("Data")

    tmpTable.DataSet.Tables.Remove(tmpTable.TableName)
    ' or: objDataSet.Tables.Remove(tmpTable.TableName)

    return tmpTable
End Function

The beauty of the first way is that you don't even need to know which DataSet the table belongs to.