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;
}