Of Course! Thanks :-)


>>Remove is not an option in Intellisense for VB. Is this a C# thing?
>
>Sorry John, I guess I should have posted code. It's a method of the DataTableCollection, not the DataTable itself. So, it would be:
>

>Dim SampleTable As DataTable
>SampleTable = dataSetA.SameTable.Copy()
>dataSetB.Tables.Remove("SameTable")
>datasetB.Tables.Add(SameTable)
>

>
>~~Bonnie
>
>
>>
>>
>>>>

>>>>Dim SampleTable As DataTable
>>>>SampleTable = dataSetA.SameTable.Copy()
>>>>dataSetB.SameTable.Dispose()
>>>>datasetB.Tables.Add(SameTable)
>>>>

>>>
>>>John, the Dispose won't work, but you can do it with a Remove().
>>>
>>>Einar, try using the Merge method. Something like this:
>>>
>>>

>>>datasetB.SameTable.Clear();
>>>datasetB.SameTable.Merge(datasetA.SameTable);
>>>

>>>
>>>~~Bonnie
>>>
>>>
>>>
>>>>
>>>>HTH
>>>>John
>>>>
>>>>>I have two different datasets: datasetA and datasetB
>>>>>
>>>>>Both datasets contain the same table SameTable.
>>>>>
>>>>>How do I copy/duplicate the table from datasetA to datasetB?
>>>>>
>>>>>This does not work: datasetB.SameTable = datasetA.SameTable
>>>>>
>>>>>Thanks,
>>>>>Einar