Copy one datat table specific columns to anothere data table

Question

Hello  I Have one DataTable with Columns as SlNoFirstNameLastNameMobileNO and Salary i want to Copy only SlNoFirstNameLastName and Salary to anothere table ..... Using Loops i want to add Data

Manas Mohapatra · Answer

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 S · Answer

Please try like this... DataTable newTable = oldTable . DefaultView . ToTable ( false  SINo  FirstName  LastName  Salary );

Midhun T P · Answer

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 kshirasagar · Answer

I Have try like this DataTable newTable = new DataTable(); for (int i = 0; i { string ColName = arrObj[i].ColName; newTable = dt.DefaultView.ToTable(false ColName); } but prob is in newTable previous data loasing