如何添加2个不同结构的数据集 [英] How to add 2 dataset of different structure

问题描述

你好，

我有1个数据集(ds，"agents")，其字段为:"Agent_Emp_Id"，"Agent_Id".["Agent_Id"作为主键]

另一个数据集(ds1，"Emp")，具有以下字段:"Employee_Id"，"Emp_Name"，"Emp_Type".["Employee_Id"作为主键]

此"Employee_Id"是第二个表中的主键，并用作第一个表中的外键(Agent_Emp_Id)..

我想将这两者结合在一起，并需要一个具有以下结构的数据集:"Agent_Id"，"Employee_Id"，"Emp_Name"，"Emp_Type" ..


数据集.merge()..不起作用...

Hello,

I''m having 1 dataset(ds,"agents"), having fields as: "Agent_Emp_Id","Agent_Id".["Agent_Id" as Primary Key]

Another dataset(ds1,"Emp"), having fields as: "Employee_Id","Emp_Name","Emp_Type".["Employee_Id" as Primary Key]

This "Employee_Id" is Primary key in 2nd table and works as foreign key(Agent_Emp_Id) in 1st table..

I want to join these two and need a dataset with structure like this "Agent_Id","Employee_Id","Emp_Name","Emp_Type"..


dataset.merge()..not working...

推荐答案

试试这个链接

[^ ]

您还可以通过sqlserver中的联接查询并在DATASET中返回该结果来实现此目的

从tbl1.column1 = tbl2.column1上的tbl1内部联接tbl2中选择tbl1.column1，tbl1.column2，tbl2.column1

try this link

[^]

you can also achieve this by join query in sqlserver and return that result in DATASET

select tbl1.column1,tbl1.column2,tbl2.column1 from tbl1 inner join tbl2 on tbl1.column1=tbl2.column1

这篇关于如何添加2个不同结构的数据集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！