如何加入两个表 [英] How To JOIN TWO TABLE

问题描述

大家好



如何加入两张桌子和节目给DGV ..



这里我使用PArt部分代码如何加入并显示给DGV ..请告诉我..更多关于连接表的想法有条件

Hi all

How To JOIN two Table and Show to DGV..

Here i Use Code for Part by PArt How to Join and show to DGV.. Please tell me.. and more idea for join table with condition

'strSQL4 = " Select SUM(FeeAmount) as FeeAmount FROM FeesMaster WHERE class='" & cboClass.Text & "' "
       '  Dim strSQL5 As String = " 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"

推荐答案

http://www.w3schools.com/sql/sql_join。 asp [ ^ ]

这篇关于如何加入两个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！