Copy specific Column data from one datatable to another

Following code add two DataTable Based on Common column: 

 

public static  MergeAll( IList tables, String primaryKey)

{

foreach(DataTable t in tables)

if(!t.Columns.Contains(primaryKeyColumn))

throw new ArgumentException("All tables must have the specified primarykey column " + primaryKeyColumn, "primaryKeyColumn");

if(tables.Count == 1)

return tables[0];

DataTable table = new DataTable("TblUnion");

table.BeginLoadData(); 

foreach (DataTable t in tables)

{

table.Merge(t); 

}

table.EndLoadData();

if (primaryKeyColumn != null)

{

var pkGroups = table.AsEnumerable()

.GroupBy(r => r[primaryKeyColumn]);

var dupGroups = pkGroups.Where(g => g.Count() > 1);

foreach (var grpDup in dupGroups)

{

DataRow firstRow = grpDup.First();

foreach (DataColumn c in table.Columns)

{

if (firstRow.IsNull(c))

{

DataRow firstNotNullRow = grpDup.Skip(1).FirstOrDefault(r => !r.IsNull(c));

if (firstNotNullRow != null)

firstRow[c] = firstNotNullRow[c];

}

}

var rowsToRemove = grpDup.Skip(1);

foreach(DataRow rowToRemove in rowsToRemove)

table.Rows.Remove(rowToRemove);

}

}

return table;

}

 

Reference :

https://msdn.microsoft.com/en-us/library/system.data.datatable.merge.aspx 

 http://www.c-sharpcorner.com/UploadFile/0c1bb2/merging-multiple-datatables-into-single-datatable-using-asp/

 

 

Hi,

 

Try this : http://www.compilemode.com/2015/05/merging-multiple-datatables-into-single-data-table-in-Asp-Net.html