如何在单个查询中从多个表中选择数据应返回单独的结果 [英] How do I select data from multiple table in single query should return separate result

问题描述

我正在使用访问数据库我想从两个表中选择数据作为单独的结果，

所以我正在尝试喜欢

Hi,

I am working with access database I want to select data from two tables as separate result,
So am trying like

Dim query As String = "Select * from Table1;Select * from Table2;"
Using con As New System.Data.OleDb.OleDbConnection(strAccessCon)
   Using accessadp As New System.Data.OleDb.OleDbDataAdapter(query, con)
                    
      Dim ds As New DataSet()
      accessadp.Fill(ds)      

   End Using
End Using

当我执行此代码时，它会给我oledb异常 -

在SQL语句结束后找到的字符。



任何帮助表示赞赏..

谢谢



我尝试了什么：



我用SQL尝试了这个，它使用SQL

when I execute this code it giving me oledb exception -
Characters found after end of SQL statement.

Any help appreciated..
Thank You

What I have tried:

I tried this with SQL,and its working with SQL

推荐答案

尝试两个填充命令：

Try two Fill commands:

Dim query As String = "Select * from Table1"
Using con As New System.Data.OleDb.OleDbConnection(strAccessCon)
   Using accessadp As New System.Data.OleDb.OleDbDataAdapter(query, con)
      Dim ds As New DataSet()
      accessadp.Fill(ds, "Table1 Data")
      ds.SelectComamnd.CommandText = "Select * from Table2"
      accessadp.Fill(ds, "Table2 Data")
   End Using
End Using

一个中的两个命令在Sql Server中工作，但在Access中不起作用。

Two commands in one works in Sql Server, but doesn't in Access.

试试这个 C＃包含多个表格的数据集 - OLEDB [ ^ ]

这篇关于如何在单个查询中从多个表中选择数据应返回单独的结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！