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 (7,8,9,10)”); 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"]; }

Create datatable from other datatable

Answers (3)