Home Library Learn Downloads Support Community
Sign in | United States - English | |
2 out of 5 rated this helpful - Rate this topic

DataTable.Clone Method

.NET Framework 4

Clones the structure of the DataTable, including all DataTable schemas and constraints.

Namespace:  System.Data
Assembly:  System.Data (in System.Data.dll)
C#
C++
F#
VB
Copy 
public virtual DataTable Clone()

Return Value

Type: System.Data.DataTable
A new DataTable with the same schema as the current DataTable.

If these classes have been derived, the clone will also be of the same derived classes.

Both the Copy and the Clone methods create a new DataTable with the same structure as the original DataTable. The new DataTable created by the Copy method has the same set of DataRows as the original table, but the new DataTable created by the Clone method does not contain any DataRows.

The following example creates a clone of a DataTable object's schema.

C#
VB
Copy 

private void GetClone(DataTable table){
    // Get a clone of the original DataTable.
    DataTable cloneTable;
    cloneTable = table.Clone();

    // Insert code to work with clone of the DataTable.
 }

.NET Framework

Supported in: 4, 3.5, 3.0, 2.0, 1.1, 1.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ
So clone doesn't really clone?
http://msdn.microsoft.com/en-us/library/system.icloneable.clone.aspx suggests that Clone can be implemented as a shallow copy or a deep copy.  It doesn't suggest that it can be implemented as a PARTIAL copy.  Which is what this does.  When I clone a table I'd like the rows to come with it.  I don't understand why MS has chosen not to do that :-/

Response: You're describing the Copy() method
History