Merge DataTables in C#

Merge DataTables in C#

   8:55 PM       Marianz

---

        /// <summary>
        /// This will merge all data in an array datatable
        /// </summary>
        /// <param name="dt">Array DataTable.</param>
        /// <returns>Merge DataTable.</returns>
        public static DataTable MergeDataTable(DataTable[] dt)
        {
            DataTable dt2 = new DataTable();

            for (int i = 0; i < dt.Length; i++)
            {
                foreach (DataColumn column in dt[i].Columns)
                {
                    if (!dt2.Columns.Contains(column.ColumnName))
                    {
                        dt2.Columns.Add(column.ColumnName, column.DataType);
                    }
                }
                foreach (DataRow item in dt[i].Rows)
                {
                    if (!dt2.Rows.Equals(item))
                    {
                        dt2.ImportRow(item);
                    }
                }
            }
            return dt2;
        }