How to merge two datatables in ASP.NET

 

Another post, just because of the continuous query in forums. Past one week I saw 3 candidate asking the same question so I thought I will share this code.

 

private static DataTable MergeDT(DataTable Dt1, DataTable Dt2)
{
  if (Dt1 != null && Dt1.Rows.Count > 0)
  {
    DataRow dr;
 
    for (int i = 0; i < Dt2.Columns.Count; i++)
    {
      Dt1.Columns.Add(new DataColumn(Dt2.Columns[i].ColumnName));
 
      if (Dt2.Rows.Count > 0)
        for (int j = 0; j < Dt2.Rows.Count; j++)
        {
          dr = Dt1.Rows[j];
          dr[Dt1.Columns.Count - 1] = Dt2.Rows[j][i];
          dr = null;
        }
    }
  }
 
  return Dt1;
}

1 Comment

Comments have been disabled for this content.