Create datatable from other datatable

Question

suppose i have 10 rows in one datatable now i have to make another datatable with last four column of previous datatable and than add 10 rows to current datatable .how to do this..

Munesh Sharma · Answer

DataRow[] rowArray = Datatable1.select(“ID in (78910)”); foreach (DataRow row in rowArray ) { dataTable2.Rows.Add( row ); }

Vishal Jadav · Answer

Hi You already have a datatable with 10 rows right. Now create another object of datatable ane use DataTable NewDtObj = new DataTable(); NewDtObj=OldDtObj; It will create a copy of old table. Now  if(NewDtObj.Columns.Count>4) for(int i=0;i { NewDtObj.Columns.RemoveAt(i); } Above loop will remove all columns except last 4. Hope it helps. Thank you.

Dipika · Answer

DataTable OLD_dt = new DataTable();//which is not null DataTable NEW_dt = new DataTable(); for(i=0; i { NEW_dt.Rows[i][Col_Name1] = OLD_dt.Rows[i][Last 4th column name]; NEW_dt.Rows[i][Col_Name2] = OLD_dt.Rows[i][Last 3rd column name]; NEW_dt.Rows[i][Col_Name3] = OLD_dt.Rows[i][2nd last column name]; NEW_dt.Rows[i][Col_Name4] = OLD_dt.Rows[i][last column name]; }