Copy table schema

[JC Voon]

Hi:

What is the best way to copy the schema of one DataTable to another ?,
The DataTable.Clone will create a new DataTable

Currently i do it manually

destTable.Clear ()
destTable.Colum ns.Clear()
destTable.Const raints.Clear()

For Each dcSrc In srcTable.Column s
dcDest = destTable.Colum ns.Add()

dcDest.AllowDBN ull = dcSrc.AllowDBNu ll
dcDest.AutoIncr ementStep = dcSrc.AutoIncre mentStep
dcDest.AutoIncr ementSeed = dcSrc.AutoIncre mentSeed
dcDest.AutoIncr ementStep = dcSrc.AutoIncre mentStep
dcDest.Caption = dcSrc.Caption
dcDest.ColumnMa pping = dcSrc.ColumnMap ping
dcDest.ColumnNa me = dcSrc.ColumnNam e
dcDest.DataType = dcSrc.DataType
dcDest.DefaultV alue = dcSrc.DefaultVa lue
dcDest.Expressi on = dcSrc.Expressio n
dcDest.MaxLengt h = dcSrc.MaxLength
dcDest.Namespac e = dcSrc.Namespace
dcDest.Prefix = dcSrc.Prefix
dcDest.ReadOnly = dcSrc.ReadOnly
dcDest.Unique = dcSrc.Unique
Next

There must be an easy way to achieve this, any idea ?

JCVoon

[Ritesh Jain via DotNetMonster.com]

Hi,

Table.clone is the best way to copy the Schema of One table into another........ .......

actually ur quest. is not clear can u explin in detail.what exactly u wan a do?

--
Message posted via http://www.dotnetmonster.com

[JC Voon]

Ritesh Jain

Table.clone is the best way to copy the Schema of One table into another........ .......
actually ur quest. is not clear can u explin in detail.what exactly u wan a do?

Thanks for the info. Here is what i'm trying to do

public sub Caller()
' For some reason i've to create the dt before call MyFunction
dim dt as DataTable = new DataTable
...
MyFunction(dt)
...--------> after the call the dt remain empty (Columns count=0)
end sub
public sub MyFunction(dtDe st as DataTable)
dim dtSrc as DataTable
...
dtDest = dtSrc.Clone
...
end sub
In the debuger i can see the dtDest schema, but after return to the
caller the schema gone ! I don't know why
Any idea ?

Thanks
JCVoon