110,534
社区成员
发帖
与我相关
我的任务
分享
DataTable dtN = new DataTable();
DataSet ds = new DataSet();
IEnumerable<DataRow> result =
from c in dt2.AsEnumerable()
join p in dt1.AsEnumerable()
on new { ID = dt2.Columns[3], NAME = dt2.Columns[4], ACCOUNT = dt2.Columns[5], DATE = dt2.Columns[6], AMOUNT = dt2.Columns[7] }
equals new { ID = dt1.Columns[5], NAME = dt1.Columns[6], ACCOUNT = dt1.Columns[7], DATE = dt1.Columns[8], AMOUNT = dt1.Columns[9] }
into rightjoin
from p in rightjoin.DefaultIfEmpty()
select c;
dtN = result.CopyToDataTable<DataRow>();