LEFT JOIN DATATABLE USING LINQ not using Activity

Learn Academy Feedback
1

hello everyone,

anybody help me, i have 2 dataTable and i would like join this using linq (not using activity) but it wrong something.
here is table1
Capture
here is table2
22
and my query in sql is
" Select dt1.ID,dt1.Name,dt2.TenLop from dt1 left join dt2 on dt1.IDLop=dt2.ID"
i translate to linq here

Capt2ure
Capt2ure786×367 12.3 KB

but here is error
err

HELP ME PLEASE !
have a nice day !

2

anybody help me ???/

3

xong rồi =)

4

(From e In dt
Group Join d In dt1 On e(“IDLop”).ToString Equals d(“ID”).ToString Into empDept = Group From ed In empDept.DefaultIfEmpty()
Group Join k In dt_truong On e(“IDTruong”).ToString Equals k(“ID”).ToString Into empTR = Group From ek In empTR.DefaultIfEmpty()
Select dt_tong.LoadDataRow (New Object() {
e(“ID”).ToString,
e(1).ToString,
If(ed Is Nothing, “NULL”, ed(“TenLop”).ToString),
If(ek Is Nothing, “NULL”, ek(“TenTruong”).ToString)
},False
)).CopyToDataTable