我需要将不相关的数据集合并到一个数据集中,当我这样做时它只从第一个表中获取数据? [英] i need to merge to unrelated datatables into one dataset when i am doing this its only taking data from 1st table ?
本文介绍了我需要将不相关的数据集合并到一个数据集中,当我这样做时它只从第一个表中获取数据?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我的问题是我有两个数据表我想将它们合并到一个数据集中,当我无法找到第二个数据表的元素时
con.Open()
Dim str As 字符串
str = 选择ProductCategoryKey,ProductCategoryAlternateKey,EnglishProductCategoryName来自[AdventureWorksDW]。[dbo]。[DimProductCategory]
Dim da As 新 SqlDataAdapter(str,con)
da.Fill(dt)
' GridView1.DataSource = dt
' Dim row As GridViewRow = GridView1.SelectedRow
' Dim desig As String = row.Cells(1).Text
Dim qry 作为 字符串
qry = 选择ProductSubcategoryKey,ProductSubcategoryAlternateKey,EnglishProductSubcategoryName,SpanishProductSubcategoryName,FrenchProductSubcategoryName,ProductCategoryKey FROM [AdventureWorksDW]。[dbo]。[DimProductSubcategory]
Dim dap 作为 新 SqlDataAdapter(qry,con)
Dim dtp As 新 DataTable
dap.Fill(dtp)
Dim ds As 新数据et()
ds.Tables.Add(dt)
ds.Tables.Add(dtp)
GridView1.DataSource = ds
GridView1.DataBind()
解决方案
dt.Merge(dtNew)
用于将两个数据表合并为一个数据表
my problem is i have two data tables i want to merge them in a dataset which when i am doing its not able to locate the elements of 2nd datatable
con.Open()
Dim str As String
str = "select ProductCategoryKey,ProductCategoryAlternateKey,EnglishProductCategoryName from [AdventureWorksDW].[dbo].[DimProductCategory]"
Dim da As New SqlDataAdapter(str, con)
da.Fill(dt)
'GridView1.DataSource = dt
'Dim row As GridViewRow = GridView1.SelectedRow
'Dim desig As String = row.Cells(1).Text
Dim qry As String
qry = "select ProductSubcategoryKey,ProductSubcategoryAlternateKey,EnglishProductSubcategoryName,SpanishProductSubcategoryName,FrenchProductSubcategoryName,ProductCategoryKey FROM [AdventureWorksDW].[dbo].[DimProductSubcategory] "
Dim dap As New SqlDataAdapter(qry, con)
Dim dtp As New DataTable
dap.Fill(dtp)
Dim ds As New DataSet()
ds.Tables.Add(dt)
ds.Tables.Add(dtp)
GridView1.DataSource = ds
GridView1.DataBind()
解决方案
dt.Merge(dtNew)
using to Merge two Datatable to one Datatable
这篇关于我需要将不相关的数据集合并到一个数据集中,当我这样做时它只从第一个表中获取数据?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文