data table to another data table

Question

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

Midhun T P · Answer

Hi Try below code - DataView view = new DataView(dt); DataTable dtcopy = view.ToTable(Selected false Col1 col4);

Dinesh Santhalingam · Answer

Thanks all for your response ....

Amit Singh · Answer

hey System . Data . DataView view = new System . Data . DataView ( yourOriginalTable ); System . Data . DataTable selected = view . ToTable ( Selected  false  col1  col2  col6  col7  col3 );

Dinesh Santhalingam · Answer

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

sudipta sanyal · Answer

TRY THIS DataTable copyDataTable; copyDataTable = table.Copy();