data table to another data table

Dinesh Santhalingam

I have a data table .I want to copy some column to another data table .

data table dt=new data table();//Having four columns
data table dtcopy=new data table();//I want to copy the datatable dt first and last column to this data table

This is my data table(dt) column

Col1

col2

col3

col4

My result is:(dtcopy)

Col1

col4

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

hey

System.Data.DataView view = new System.Data.DataView(yourOriginalTable);

System.Data.DataTable selected = view.ToTable("Selected", false, "col1", "col2", "col6", "col7", "col3");

Dinesh Santhalingam9y ago
In Your code the total data table is copied to another .But I want to copy two of the column alone to my new data table @
sudipta sanyal

TRY THIS

DataTable copyDataTable;

copyDataTable = table.Copy();