var q = from p1 in db.tbl_dore join p2 in db.tbl_dore_teacher on p1.dore_id equals p2.fk_dore into list1 from l1 in list1.DefaultIfEmpty() join p3 in db.tbl_teacher on l1.fk_teacher equals p3.teacher_id into list2 from l2 in list2.DefaultIfEmpty() select new {p1.dore_id, p1.dore_code,p1.dore_startdate,l2.teacher_fullname} ; dgv_dore.DataSource = q.ToList();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)