我基于EMP列连接了2个数据表,并使用了copytodatatable,但是当我将新的datatable加载到datagridview中时,它只显示了查询中连接的列(Salarydt),这是为什么?
var collection = from p in dt.AsEnumerable()
join q in salaryDT.AsEnumerable() on p.Field<int>("Emp") equals q.Field<int>("Emp1") into UP
from t in UP
select t;
DataTable resultdt = new DataTable();
dt = collection.CopyToDataTable();
https://stackoverflow.com/questions/56463998
复制相似问题