Getting totals of gridcontrol column in a textedit devexpress

Question

0.00/5 (No votes)

See more:

Hi all,

I am trying the code to get values of totals in a devexpress textedit control from a Gridcontrol Column. It is showing the total but total value is not correct.

Problem is appearing here

(GridView1.Columns.View.GetFocusedRowCellValue("NET PRFIT", I))

Can anyone please help me for the solution? Thanks.

What I have tried:

VB

End Try
        Dim solprofit As Double = 0
        Dim retproft As Double = 0
        For I As Integer = 0 To GridView1.RowCount - 1
            Try

                solprofit = solprofit + CDbl(GridView1.Columns.View.GetFocusedRowCellValue("NET PRFIT", I))

            Catch ex As Exception

            End Try
Next
TxtOpCrTotal.Text = FormatNumber(solprofit)

Posted 5-Mar-17 7:36am

UCP_2005

Updated 5-Mar-17 7:49am

Add a Solution

1 solution

Add a Solution

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

Graeme_Grant · Answer 1 · 2017-03-05T07:49:00

Solution 1

These might be what you are looking for:

* Online Documentation - Developer Express Inc.[^]

* Q537682 - How to get a sum of a GridView column | DevExpress Support Center[^]

Posted 5-Mar-17 7:49am

Graeme_Grant

Comments

UCP_2005 5-Mar-17 14:22pm

Thanks Graeme.

I checked the links but I created the grid columns through code.

SqlStr = "SELECT TRANSCODE,transdate as [Invoice Date],qutono as [Invoice No],(select top 1 ledgername from StockInvoiceDetails where StockInvoiceDetails.transcode=StockInvoiceRowItems.transcode) AS [Customer Name], SUM(N1) AS [NET PRFIT] FROM StockInvoiceRowItems " & Wherestr & " AND VOUCHERNAME IN ('POS','SD','SR') "

Will it work if I create the columns manually in GridControl by giving the same Name and captions?
Thanks for your support.

Getting totals of gridcontrol column in a textedit devexpress

1 solution

Solution 1

Add your solution here

Preview 0

Getting totals of gridcontrol column in a textedit devexpress

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us