How to copy specific rows in new datatable from old datatable.

Question

plz help i want to copy some specific rows record from old datatable and add in new datatable as it is. Thanks in advance........

DA D · Answer

Thanks for rply... i want to copy data in new datatable dynamically with rows and col. just like as selected specific row copy from old datatable & paste in to new datatable. thanks to u again....

Gohil Jayendrasinh · Answer

Hi DataTable dt = new DataTable(); //Create Datatable with column you need. var info = (from a in dtOld.AsEnumerable() select new { // select columen you need } ) if (info != null) { if (info.Count() > 0) { dt = info.CopyToDataTable(); } }

Vulpes · Answer

Check out the DataTable.ImportRow method and the article linked to below: http://msdn.microsoft.com/en-us/library/system.data.datatable.importrow.aspx http://www.c-sharpcorner.com/UploadFile/mahesh/ImportRow07092006195427PM/ImportRow.aspx