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)499K
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 230
1 PIEBALDconsult 150
2 DamithSL 125
3 BillWoodruff 108
4 Garth J Lancaster 90
0 OriginalGriff 5,790
1 DamithSL 4,601
2 Maciej Los 4,012
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,195


Advertise | Privacy | Mobile
Web03 | 2.8.141220.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