linq2 c# Linq. DataTable Join 데이타 테이블 링큐를 활요한 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 ("ID1") equals B.Field ("ID2") select dtResult.LoadDataRow ( A.ItemArray.Concat ( B.ItemArray ).ToArray(), false); DataTable dtJ = rdt1.CopyToDataTable (); 2023. 11. 16. c# DataTable 최소값 최대값 구하기 string minValue = dt.AsEnumerable().Min(row => row["DTE"]).ToString(); string maxValue = dt.AsEnumerable().Max(row => row["DTE"]).ToString(); 2023. 11. 13. 이전 1 다음 반응형