Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB.NET
strSQL11 = "SELECT * FROM ( SELECT  stdAdmission.Regno, stdAdmission.Sname, stdAdmission.Class , Fees_Transaction.FeeType," & _
                "Fees_Transaction.Amount_Paid FROM Fees_Transaction INNER JOIN stdAdmission ON Fees_Transaction.Regno=stdAdmission.Regno) as FT " & _
                " PIVOT (Sum (Amount_Paid) FOR FeeType in (" + Dset17.Rows(0).Item("VFeeType") + ")) AS PVT where Class='" & cboClass.Text & "'"
            Dim DaAp11 As New SqlDataAdapter(strSQL11, con)
            Dim DSet11 As New DataTable
            DaAp11.Fill(DSet11)
            For Each dr As DataRow In DSet11.Rows
                Me.DataGridView2.Rows.Add()
                With Me.DataGridView2.Rows(Me.DataGridView2.Rows.Count - 1)
                    .Cells("Regno").Value = dr("Regno")
                    .Cells("Sname").Value = dr("Sname")
                    .Cells("Class").Value = dr("Class")
' HERE HOW CAN I Add AMOUNT_PAID Data .. 
                End With
            Next
        End If
Posted 17-Feb-13 6:55am
Edited 17-Feb-13 7:05am
(no name)498.5K
v2
Comments
Sergey Alexandrovich Kryukov at 17-Feb-13 13:03pm
   
And..?
—SA
Navas Khanj at 17-Feb-13 13:11pm
   
Wht And..?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 562
1 Sergey Alexandrovich Kryukov 484
2 Maciej Los 325
3 DamithSL 233
4 Mathew Soji 195
0 OriginalGriff 7,168
1 Sergey Alexandrovich Kryukov 6,377
2 DamithSL 5,461
3 Manas Bhardwaj 4,876
4 Maciej Los 4,450


Advertise | Privacy | Mobile
Web02 | 2.8.1411023.1 | Last Updated 17 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100