62,074
社区成员
发帖
与我相关
我的任务
分享
var result = from p in dt1.AsEnumerable()
from q in dt2.AsEnumerable()
where p.Field<int>("id") == q.Field<int>("Aid")
&& q.Field<string>("subject") == "化学"
select new
{
id = p.Field<int>("id"),
name = p.Field<string>("name")
};
var result=from a in A
join b in B on a.id equals b.Aid
where b.subject==""
select a;