[C#] Join Multi DataTable TO One DataTable

[C#] Join Multi DataTable TO One DataTable

 

1. 두 개의 DataTable을 Join 해 옆으로 나열한 하나의 DataTable 반환

public static DataTable JoinTwoTables(DataTable dt1, DataTable dt2) { DataTable dtResult = new DataTable(); var dt1Columns = new List<string>(); foreach (DataColumn column in dt1.Columns) { dt1Columns.Add(column.ColumnName); dtResult.Columns.Add(column.ColumnName); } var dt2Columns = new List<string>(); foreach (DataColumn column in dt2.Columns) { if (!dt1Columns.Contains(column.ColumnName)) { dt2Columns.Add(column.ColumnName); dtResult.Columns.Add(column.ColumnName); } } for (int i = 0; i < dt1.Rows.Count; i++) { var row = dtResult.NewRow(); dt1Columns.ForEach(x =>{row[x] = dt1.Rows[i][x];}); dt2Columns.ForEach(x =>{row[x] = dt2.Rows[i][x];}); dtResult.Rows.Add(row); } return dtResult; }

 

 

2. 여러개의 DataTable을 Join 해 옆으로 나열한 하나의 DataTable 반환

private DataTable JoinMultiTables(DataTable[] lstDT) { System.Data.DataTable dtResult = new System.Data.DataTable(); foreach (System.Data.DataColumn dc in lstDT[0].Columns) dtResult.Columns.Add(dc.ColumnName); foreach (System.Data.DataTable dt in lstDT) foreach (System.Data.DataRow row in dt.Rows) { System.Data.DataRow row_new = dtResult.NewRow(); foreach (System.Data.DataColumn dc in lstDT[0].Columns) row_new[dc.ColumnName] = row[dc.ColumnName]; dtResult.Rows.Add(row_new); } return dtResult; }