Copy one datat table specific columns to anothere data table

Darshan Kshirasagar

Hello ,

I Have one DataTable with Columns as SlNo,FirstName,LastName,MobileNO and Salary,

i want to Copy only SlNo,FirstName,LastName and Salary to anothere table .....

Using Loops i want to add Data

4 Replies

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

Manas Mohapatra9y ago
Try like below:

DataTable copyDataTable;
copyDataTable = table.Copy();
copyDataTable.Columns.Remove("ColB");

or

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

Ramesh S9y ago

Please try like this...

DataTable newTable = oldTable.DefaultView.ToTable(false, "SINo", "FirstName", "LastName", "Salary");

Midhun Tp9y ago
Hi,

If you just need to copy specific columns of datatable to another then just use below code -

DataTable newTable;
newTable = dt.Copy();
newTable.Columns.Remove("MobileNO");
Darshan Kshirasagar9y ago
I Have try like this

DataTable newTable = new DataTable();
for (int i = 0; i < arrObj.Count(); i++)
{
string ColName = arrObj[i].ColName;
newTable = dt.DefaultView.ToTable(false, ColName);
}

but prob is in newTable previous data loasing