How to make a copy of a datatable?

  • Thread starter Thread starter cj
  • Start date Start date
C

cj

If I have a dataset with a datatable and I want to make a copy of this
in a different datatable. I've tried:
MyDt = MyDs.Tables("testTable")
Problem is when I later in code issue:
MyDt.clear()
it clears MyDs.Tables("testTable") also.

How can this be accomplished?
 
cj said:
If I have a dataset with a datatable and I want to make a copy of this
in a different datatable. I've tried:
MyDt = MyDs.Tables("testTable")
Problem is when I later in code issue:
MyDt.clear()
it clears MyDs.Tables("testTable") also.

How can this be accomplished?
Click to expand...

MyDt = MyDs.Tables("testTable").Copy


Tom
 
Tomb,

Looking at your (message about online help)

In fact is the datatable.copy a little confusing one. It is as far as I know
the only collection which has an inbuild deep copy method, so people could
expect that it standard not there.

:-)

Cor
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

clearing dataset or datatable 10
datagridview 2
C# Query : Failed to populate DataTable 8
how to work with null data in vb.net 2005 5
Copy DataGridView to DataTable (Disconnected) 4
selectedrow in datatable 1
How do I loop through rows in a DataTable? 3
Is DataSet ReadOnly? 3

Back
Top