将多个DataTable连接到一个DataTable [英] Joining Multiple DataTable to One DataTable

问题描述

I have 3 datatable dt,dt1,dt2....I am performing a join operations..

var query = from p in dt.AsEnumerable()
                  join a in dt1.AsEnumerable()
                  on p.Field<int>("LId") equals a.Field<int>("LId")
                  join t in dt2.AsEnumerable()
                  on a.Field<int>("LId") equals t.Field<int>("LId")
                  select new
                  {
                      EmpId = p.Field<int>("EmpId"),

                      EmpName = p.Field<string>("EmpName"),
                      LocationName = a.Field<string>("LocationName")
                  };
when i run this query i am getting error as Column 'LId' does not belong to table Table3.

推荐答案

这错误表示您的第三个数据表（dt2）没有名为LId的列。仔细检查列并修改连接。

- Amit

This error means that your third datatable(dt2) does not have a column named "LId". Double check the columns and modify the join.

--Amit

请查看链接一次：这里 [ ^ ]

这篇关于将多个DataTable连接到一个DataTable的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！