copy data table with specific column

Question

I am working on a website, in which on button click i have two table, In first datatable i have a record from 1 to 31 , in second datatable i have record only 23 and 24.

Now i have to copy of value second datatable 23 and 24 in first data table.

I am mergiing the table now it is printing 33 record

please check and help.

Date	In Time	Out Time
01/12/2019
02/12/2019
03/12/2019
04/12/2019
05/12/2019
06/12/2019
07/12/2019
08/12/2019
09/12/2019
10/12/2019
11/12/2019
12/12/2019
13/12/2019
14/12/2019
15/12/2019
16/12/2019
17/12/2019
18/12/2019
19/12/2019
20/12/2019
21/12/2019
22/12/2019
23/12/2019
24/12/2019
25/12/2019
26/12/2019
27/12/2019
28/12/2019
29/12/2019
30/12/2019
31/12/2019
23/12/2019
24/12/2019

Amit Mohanty · Answer

Hey check the below code, this may help you. DataTable dataTable1 = new DataTable(); dataTable1.Columns.Add( "id" , typeof ( int )); dataTable1.Columns.Add( "date" , typeof ( string )); dataTable1.Columns.Add( "intime" , typeof ( string )); dataTable1.Columns.Add( "outtime" , typeof ( string )); dataTable1.Rows.Add(1, "2019-01-01" , "" , "" ); dataTable1.Rows.Add(2, "2019-01-02" , "" , "" ); dataTable1.Rows.Add(3, "2019-01-03" , "" , "" ); dataTable1.Rows.Add(4, "2019-01-04" , "" , "" ); dataTable1.Rows.Add(5, "2019-01-05" , "" , "" ); DataTable dataTable2 = new DataTable(); dataTable2.Columns.Add( "id" , typeof ( int )); dataTable2.Columns.Add( "date" , typeof ( string )); dataTable2.Columns.Add( "intime" , typeof ( string )); dataTable2.Columns.Add( "outtime" , typeof ( string )); dataTable2.Rows.Add(1, "2019-01-01" , "09:00 AM" , "09:30 AM" ); dataTable2.Rows.Add(2, "2019-01-02" , "09:00 AM" , "09:30 AM" ); foreach (DataRow dataRow2 in dataTable2.Rows) { DataRow dataRow1 = dataTable1.AsEnumerable().Where(x => x[ "date" ] == dataRow2[ "date" ]).FirstOrDefault(); int rowId = ( int )dataRow1[ "Id" ]; dataTable1.Rows[rowId][ "intime" ] = dataRow2[ "intime" ]; dataTable1.Rows[rowId][ "outtime" ] = dataRow2[ "outtime" ]; } dataTable1.AcceptChanges();

Rushi Mehta · Answer

Please check the below link. I think this will help you https://www.c-sharpcorner.com/forums/copy-specific-column-data-from-one-datatable-to-another2

Apurva Singh · Answer

in this i want to copy of intime of 23 and 24 of send datable in firt datatable of date 23 and 24

Salman Beg · Answer

Check this link, https://stackoverflow.com/questions/164144/compare-two-datatables-to-determine-rows-in-one-but-not-the-other

copy data table with specific column

Answers (4)