Create datatable from other datatable

DataRow[] rowArray = Datatable1.select(“ID in (7,8,9,10)”);

foreach (DataRow row in rowArray) {

dataTable2.Rows.Add(row);

}

0

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.

0

John10y ago

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"];

}

0