How To Join Two Table in DataGridView

[Navaskhanj]

Hi.. I am Using This Code For Join Table..

con.Open()
        Dim strSQL5 As String = "SELECT Fees_Transaction.Regno, Fees_Transaction.ST_Name, SUM(Fees_Transaction.Amount_Paid) as FTAmountPaid, SUM(FeesMaster.FeeAmount) As TotalFeeAmount FROM Fees_Transaction" & _
            " INNER JOIN FeesMaster ON Fees_Transaction.Regno=FeesMaster.Regno WHERE  Fees_Transaction.class='" & cboClass.Text & "'  AND Fees_Transaction.FeeType=FeesMaster.FeeType " & _
            "GROUP BY Fees_Transaction.Regno, Fees_Transaction.ST_Name"
 
 
        Dim DaAp5 As New SqlDataAdapter(strSQL5, con)
        Dim DSet5 As New DataTable
        DaAp5.Fill(DSet5)
        '========================================
        With Me.DGV1
            .Columns.Add("Regno", "RegNo")
            .Columns.Add("ST_Name", "Student Name")
            .Columns.Add("Amount_Paid", "Amount Paid")
            .Columns.Add("Remaining", "Remaining")
            .Columns.Add("TotalAmt", "Total Amount")
            .Columns.Add("FeeType", "Fee Type")
            .Columns.Add("Class", "Class")
            .Columns.Add("Section", "Section")
            .Columns(0).Width = 85
            .Columns(1).Width = 250
            .Columns(2).Width = 150
            .Columns(3).Width = 150
            .Columns(4).Width = 140
            .Columns(5).Width = 150
            .Columns(6).Width = 90
            .Columns(7).Width = 90
            ' .AllowUserToAddRows = False
            .EditMode = DataGridViewEditMode.EditProgrammatically
            .ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter
        End With
 
        For Each dr As DataRow In DSet5.Rows
            Me.DGV1.Rows.Add()
            With Me.DGV1.Rows(Me.DGV1.Rows.Count - 1)
                .Cells("Regno").Value = dr("Regno")
                .Cells("ST_Name").Value = dr("ST_Name")
                .Cells("Amount_Paid").Value = dr("FTAmountPaid")
                .Cells("TotalAmt").Value = dr("TotalFeeAmount")
                '  .Cells("FeeType").Value = "Total"
                '   .Cells("Class").Value = dr("Class")
                '   .Cells("Section").Value = dr("Section")
            End With
        Next
 
          con.Close()

But This Code is Woking.. Wht is my Problem.. I Use SUM both Table. Fees_Transcation SUM Function working For Two condition (regno and Feetype) and FeesMaster I Want Sum FeeAmount For Regno and Class wise but it's not sum that condition.. Please wht prb i did ..

[Rabbit]

Do you mean the code is not working? I have no idea what you are trying to say. Your english is unclear. Try posting sample data and results and reword what you're trying to do.