Getting the total amount

[Ann95]

I want to get the total sum of the amount column. How can I display the total sum to the textbox total? Any possible way to do it? Please help. Thanks!

[renzlo]

is the datagrid bound or unbound?

[Jx_Man]

Try :

        Dim temp As Long = 0
        For i = 0 To DataGridView1.Rows.Count - 1
            temp = temp + DataGridView1.Item(6, i).Value 'Column 6 is Amount
        Next
        Total.Text = temp

[Reverend Jim]

If the source for the DataGrid is a database you should be able to do it with a single query. If you provide more detail perhaps I can suggest something.

[Ann95]

the datagrid is bound

[Jx_Man]

the datagrid is bound

You can use SUM function to get total amount.
select sum(amount) as TotalAmount from TableName

[Abu Ehab]

    Label.Text = "Total Mount = " & ((From NetMount As DataGridViewRow In DataGridView1.Rows Where NetMoun.Cells(6).FormattedValue.ToString <> "" Select CInt(NetMoun.Cells(6).FormattedValue)).Sum)

[Ann95]

Thanks for the help everyone.