mysql - 如何在一个gridview中查看两个表格？

Question

我有两个包含相同列的表。我想知道的是如何将数据库中的两个表查看到一个 datagridview 中？

这是我的代码

con = New MySqlConnection
con.ConnectionString = cons
ds = New Dataset
tables = ds.Tables

da = New MysqlDataAdapter("Select * from haspostingusername where User ='" & txtUser.Text & "'",con)
d1 = New MysqlDataAdapter("Select * from laspostingusername where User ='" & txtUser.Text & "'",con)
da.Fill(ds, "hapostingusername")
da1.Fill(ds, "lapostingusername")
Dim view As New DataView(tables(0))
DgvReport.DataSource = view

请帮帮我。谢谢!

Answer 1

尝试使用联合并一次性返回结果。所以不是

da = New MysqlDataAdapter("Select * from haspostingusername where User ='" & txtUser.Text & "'",con)
d1 = New MysqlDataAdapter("Select * from laspostingusername where User ='" & txtUser.Text & "'",con)

你可以试试

foobar = New MysqlDataAdapter("Select * from haspostingusername where User ='" & txtUser.Text & " UNION Select * from laspostingusername where User ='" & txtUser.Text & "'",con)

此外，如果 txtUser 是用户输入的，您应该将其包装在准备好的语句中以避免 SQL 注入(inject)。