Copy rows from one Datatable to another DataTable?

Question

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

Rafnas T P · Answer

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

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 .