Loading

Copy rows from one Datatable to another DataTable?

Mayooran Navamany

How can I copy specific rows from DataTable to another Datable in c#? There will be more than one row.

2 Replies

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

Rafnas T P10y ago
dt_TableBefore //your datatable
DataView view = new DataView(dt_TableBefore); //convert to view
DataTable dt_TableAfter = view.ToTable(false, new string[] { "Column_Name1", "Column_Name2",....., "Column_NameN" }); //Select columns from dt_TableBefore which all you wanted to selct in new Data Table dt_TableAfter
Bikesh Srivastava10y ago
Hi,
You can use this to resolve your query,
foreach (DataRow dr in dataTable1.Rows) {
    if (/* some condition */)
        dataTable2.Rows.Add(dr.ItemArray);
}
If its resolve your query ,mark as answer ,otherwise reply me i've other solution .