반응형
데이타 테이블 링큐를 활요한 Join 방법.
그럼 Left Join은?
DataTable dtA = new DataTable();
DataTable dtB = new DataTable();
DataTable dtResult = dtA.Clone ();
dtResult.Merge (dtB);
var rdt1 = from A in dtA.AsEnumerable ()
join B in dtB.AsEnumerable ()
on A.Field <string>("ID1") equals B.Field <string>("ID2")
select dtResult.LoadDataRow ( A.ItemArray.Concat ( B.ItemArray ).ToArray<object>(), false);
DataTable dtJ = rdt1.CopyToDataTable <DataRow>();
반응형