如何在DataGridView中连接两个表

Question

我正在使用这段代码FOr两个表连接和显示到DataGridView

Dim strSQL4 

strSQL4 = " Select Regno, Sname,Class, Section,SUM(FeeAmount) as FeeAmount FROM FeesMaster WHERE class='" & cboClass.Text & "'  GROUP By Regno,Sname,Class,Section"

strSQL5 = " Select Regno, ST_Name,Class, Section,SUM(Amount_Paid) as Amount_Paid FROM Fees_Transaction WHERE class='" & cboClass.Text & "'  GROUP By Regno,ST_Name,Class,Section"

Dim DaAp4 As New SqlDataAdapter(strSQL4, con)
Dim DSet4 As New DataTable
DaAp4.Fill(DSet4)
DataGridView2.DataSource = DSet4.DefaultView

Answer 1

在上面的代码中，您实际上并没有使用strSQL5做任何事情，那么您希望它如何出现在DGV上呢？

正如@xfx建议的那样，您应该调整strSQL4，以便它使用来自strSQL5的SQL作为连接。