grdList.DataSource = (from p in DepartmentManager.GetAll()
from q in DepartmentManager.GetAll()
where p.UpDepartmentId==q.DepartmentId
select new
{
Id = p.DepartmentId,
Name = p.DepartmentName,
Number = p.DepartmentNumber,
UpName = q.DepartmentName,
Type = p.DepartmentType,
status = p.Status
}).ToList();
grdList.DataBind();
一个嵌套查询