adding datarows to tables and datatables to datasets

[psb]

I thought this was weird?? is this a bug in framework 1.0??? (1.0 is the
version I am running against)

---------------------------
dim dtAll as new datatable
dim dtTmp as datatable
dtTmp = LoadDataTable("select top 100 from table...")
for i=0 to dtTmp.rows.count -1
''''ERROR ON THIS LINE'''
dtAll.Rows.Add(dtTmp.rows(i))
next
-------------------------------
ERROR: Datarow already belongs to another datatable

I get the same error with adding datatables to datasets althought it says
"this table belongs to another dataset"
---------------------------------------
dim MyDataSet as New Dataset
dim dtTmp as datatable
dtTmp = LoadDataTable("select top 100 from table...")
MyDataSet.Tables.Add(dtTmp)
--------------------------------------------

Thanks,
~psb

[Cliff Harris]

This is not an error. A DataRow may only belong to one DataTable at a time.
The same with a DataTable. A DataTable may only belong to one DataSet at a
time.

-Cliff

"psb" <pb******@msn.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

I thought this was weird?? is this a bug in framework 1.0??? (1.0 is the
version I am running against)

---------------------------
dim dtAll as new datatable
dim dtTmp as datatable
dtTmp = LoadDataTable("select top 100 from table...")
for i=0 to dtTmp.rows.count -1
''''ERROR ON THIS LINE'''
dtAll.Rows.Add(dtTmp.rows(i))
next
-------------------------------
ERROR: Datarow already belongs to another datatable

I get the same error with adding datatables to datasets althought it says
"this table belongs to another dataset"
---------------------------------------
dim MyDataSet as New Dataset
dim dtTmp as datatable
dtTmp = LoadDataTable("select top 100 from table...")
MyDataSet.Tables.Add(dtTmp)
--------------------------------------------

Thanks,
~psb