合并数据集 [英] Merge Dataset

问题描述

我想从两个表中填充网格的两个表具有不同的列/数据类型.
我有2个数据集.两者都具有不同的表结构(两个表中的列/数据类型均不同).
我尝试合并两个数据集，但是没有用.

感谢您的帮助.

I want to populate my grid from two tables with different columns/datatype in both tables.
I have 2 Datasets. Both have different table structure (columns/datatype are different in both tables).
I tried to merge both datasets, but it wasn''t working.

Any help is appreciated.

推荐答案

Rohit，

数据集本身包含1个或多个表.因此，我认为您想在数据集中联接表.

在这里，您要表示要联接数据集(一个或多个然后是一个表的组)，因此许多表之间将要联接.

您能告诉我们您的表格结构吗?

很好的答案 HERE [ ^ ]大脑模拟器，用于在没有数据库访问权限的情况下联接两个表，如果它们包含一些要联接的键.

希望对您有所帮助.

Rohit,

Dataset itself contain 1 or more tables. So I think you want to join tables in a dataset.

Here you''re stating that you want to join datasets(group of one or more then one table), So There will be join between many tables.

Can you please show us your table structure ?

There''s a good answer HERE[^] Brain simulator on joining two tables without database access if they contains some key to join with.

Hope it helps.

不确定，什么没用.您所需要做的就是创建第三个数据集，并首先在其中创建第一个数据集，然后在其中创建第二列.之后，循环遍历并添加数据.

或者，尝试使用DataSet.Merge 方法 [

Not sure, what did not work. All you need is to Create a third dataset and first create columns of first one into it and then second one into it. After which, loops through and add the data.

Alternatively, try DataSet.Merge method[^] if you can have close schema if not same.

One more suggestion, why not make a Join query and get data in a single shot in a table? Why two different queries and tables?

这篇关于合并数据集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！