Question Datagridview Not populating

urielpats

New member
Joined
Jul 29, 2016
Messages
1
Programming Experience
Beginner
Hello, i have a method private void FillLevyRoll(), i put the method in a button on click event to fill a datagridview dgvLevyRoll my problem is when i run i am not getting an error and the dgv is remaining empty.Im lost confused tried but to no avail.The query works in SQL management studio

C#:
C#:
[COLOR=#101094]private[/COLOR][COLOR=#101094]void[/COLOR][COLOR=#2B91AF]FillLevyRoll[/COLOR][COLOR=#303336]()[/COLOR][COLOR=#303336]
    [/COLOR][COLOR=#303336]{[/COLOR][COLOR=#303336]
        [/COLOR][COLOR=#101094]try[/COLOR][COLOR=#303336]
        [/COLOR][COLOR=#303336]{[/COLOR][COLOR=#303336]
            [/COLOR][COLOR=#2B91AF]DataTable[/COLOR][COLOR=#303336] dataTableSource [/COLOR][COLOR=#303336]=[/COLOR][COLOR=#101094]new[/COLOR][COLOR=#2B91AF]DataTable[/COLOR][COLOR=#303336]();[/COLOR][COLOR=#303336]


            [/COLOR][COLOR=#2B91AF]SqlCommand[/COLOR][COLOR=#303336] command [/COLOR][COLOR=#303336]=[/COLOR][COLOR=#101094]new[/COLOR][COLOR=#2B91AF]SqlCommand[/COLOR][COLOR=#303336]([/COLOR][COLOR=#7D2727]"SELECT  Refrence"[/COLOR][COLOR=#303336]+[/COLOR][COLOR=#303336]
                [/COLOR][COLOR=#7D2727]", MAX(CASE WHEN AccNumber = '1010000' THEN amount END) AS Opening"[/COLOR][COLOR=#303336]+[/COLOR][COLOR=#303336]
                [/COLOR][COLOR=#7D2727]", MAX(CASE WHEN AccNumber = '1010000' THEN amount END) AS electricity"[/COLOR][COLOR=#303336]+[/COLOR][COLOR=#303336]
                [/COLOR][COLOR=#7D2727]", MAX(CASE WHEN AccNumber = '1045000' THEN amount END) AS water"[/COLOR][COLOR=#303336]+[/COLOR][COLOR=#303336]
                [/COLOR][COLOR=#7D2727]", MAX(CASE WHEN AccNumber = '1000000' THEN amount END) AS levy"[/COLOR][COLOR=#303336]+[/COLOR][COLOR=#303336]
                [/COLOR][COLOR=#7D2727]", MAX(CASE WHEN AccNumber = '2750000' THEN amount END) AS Interest"[/COLOR][COLOR=#303336]+[/COLOR][COLOR=#303336]
                [/COLOR][COLOR=#7D2727]", MAX(CASE WHEN AccNumber = '4000000' THEN amount END) AS Legal"[/COLOR][COLOR=#303336]+[/COLOR][COLOR=#303336]
                [/COLOR][COLOR=#7D2727]", MAX(CASE WHEN AccNumber = '4350003' THEN amount END) AS Other"[/COLOR][COLOR=#303336]+[/COLOR][COLOR=#303336]
                [/COLOR][COLOR=#7D2727]", MAX(CASE WHEN AccNumber = '8400000' THEN amount END) AS Payments"[/COLOR][COLOR=#303336]+[/COLOR][COLOR=#303336]
                [/COLOR][COLOR=#7D2727]", MAX(CASE WHEN AccNumber = '1000000' THEN amount END) AS Due"[/COLOR][COLOR=#303336]+[/COLOR][COLOR=#303336]
                [/COLOR][COLOR=#7D2727]" FROM dbo.vw_LedgerTransactions"[/COLOR][COLOR=#303336]+[/COLOR][COLOR=#303336]
                [/COLOR][COLOR=#7D2727]" GROUP BY Refrence "[/COLOR][COLOR=#303336],[/COLOR][COLOR=#303336] conn[/COLOR][COLOR=#303336]);[/COLOR][COLOR=#303336]

            [/COLOR][COLOR=#2B91AF]SqlDataAdapter[/COLOR][COLOR=#303336] adapter [/COLOR][COLOR=#303336]=[/COLOR][COLOR=#101094]new[/COLOR][COLOR=#2B91AF]SqlDataAdapter[/COLOR][COLOR=#303336]([/COLOR][COLOR=#303336]command[/COLOR][COLOR=#303336]);[/COLOR][COLOR=#303336]
            conn[/COLOR][COLOR=#303336].[/COLOR][COLOR=#2B91AF]Open[/COLOR][COLOR=#303336]();[/COLOR][COLOR=#303336]

            adapter[/COLOR][COLOR=#303336].[/COLOR][COLOR=#2B91AF]Fill[/COLOR][COLOR=#303336]([/COLOR][COLOR=#303336]dataTableSource[/COLOR][COLOR=#303336]);[/COLOR][COLOR=#303336]
            dgvLevyRoll[/COLOR][COLOR=#303336].[/COLOR][COLOR=#2B91AF]DataSource[/COLOR][COLOR=#303336]=[/COLOR][COLOR=#303336] dataTableSource[/COLOR][COLOR=#303336];[/COLOR][COLOR=#303336]

        [/COLOR][COLOR=#303336]}[/COLOR][COLOR=#303336]
        [/COLOR][COLOR=#101094]catch[/COLOR][COLOR=#303336]([/COLOR][COLOR=#2B91AF]Exception[/COLOR][COLOR=#303336] ex[/COLOR][COLOR=#303336])[/COLOR][COLOR=#303336]
        [/COLOR][COLOR=#303336]{[/COLOR][COLOR=#303336]
            [/COLOR][COLOR=#2B91AF]MessageBox[/COLOR][COLOR=#303336].[/COLOR][COLOR=#2B91AF]Show[/COLOR][COLOR=#303336]([/COLOR][COLOR=#7D2727]"Application Error. err:"[/COLOR][COLOR=#303336]+[/COLOR][COLOR=#303336] ex[/COLOR][COLOR=#303336].[/COLOR][COLOR=#2B91AF]ToString[/COLOR][COLOR=#303336]());[/COLOR][COLOR=#303336]
        [/COLOR][COLOR=#303336]}[/COLOR][COLOR=#303336]
        [/COLOR][COLOR=#101094]finally[/COLOR][COLOR=#303336]
        [/COLOR][COLOR=#303336]{[/COLOR][COLOR=#303336]
            conn[/COLOR][COLOR=#303336].[/COLOR][COLOR=#2B91AF]Close[/COLOR][COLOR=#303336]();[/COLOR][COLOR=#303336]
        [/COLOR][COLOR=#303336]}[/COLOR][COLOR=#303336]

    [/COLOR][COLOR=#303336]}[/COLOR]

 

jmcilhinney

C# Forum Moderator
Staff member
Joined
Apr 23, 2011
Messages
4,748
Location
Sydney, Australia
Programming Experience
10+
By the way, opening and closing the connection is pointless because Fill will do that for you, as will Update. You only need to open and close the connection explicitly when using a data adapter if you're performing more than one operation.
 
Top Bottom