Dim strSQL27 As String = "SELECT STUFF((SELECT DISTINCT ',['+ FeesType +']' FROM FeeMaster WHERE Class='" & cboClass.Text & "' For XMl Path('')), 1, 1, '')" Dim DaAp27 As New SqlDataAdapter(strSQL27, con) Dim Dset27 As New DataTable DaAp27.Fill(Dset27) strSQL11 = "SELECT * FROM (SELECT Regno, ST_Name, Class, Section, [FeeType], [Amount_Paid] FROM Fees_Transaction) stdAdmission" & _ " PIVOT (Sum(Amount_Paid) for FeeType in (" + Dset27.Rows(0).Item("Column1") + "))as PVTFT where Class='" & cboClass.Text & "'" Dim DaAp11 As New SqlDataAdapter(strSQL11, con) Dim DSet11 As New DataTable DaAp11.Fill(DSet11) DGV1.DataSource = DSet11 ' How can i Get Amount PAid Particular Column For Each dr As DataRow In DSet11.Rows Me.DataGridView2.Rows.Add() With Me.DataGridView2.Rows(Me.DataGridView2.Rows.Count - 1) For i As Integer = 4 To DataGridView2.ColumnCount - 1 .Cells(i).Value = dr("Amount_Paid") Next End With Next
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)