You will have to do this for every property that you have set to anything different than the default value. Properties set to default value get the same value and properties not set will not be of any importance offcourse.

The second question if I understand you correctly will turn this question into something totally different though. A datacolumn in a datatable does as a column in SQL NOT contain any data itself.

What we have discussed so far is how to copy the column as a column object.

A database tabla and also a .NET datatable stores data in rows, NOT column, so if it is the data you want to copy we are talking about different matters.

/Nisse