Calculate Total Of Column In Listview VB.NET

[TIP.Synergy]

Hi to Everyone,

I want to get the total (column) amount using Listview w/o database VB.NET

Help me please...

Thanks..
_______________________________________________________________________________________________________

lstitems

Item Name | Unit Price | Quantity | Amount
------------------------------------------------------------
Sample1 | 100.00 | 1 | 100.00

Sample2 | 100.00 | 1 | 200.00

Sample3| 100.00 | 1 | 200.00
______________________________________

Label or Textbox ----> Total 500.00

[Teme64]

Here's the simplest way. This calculates the sum of the fourth column

Dim TotalSum As Double = 0
Dim TempNode As ListViewItem

For Each TempNode In ListView1.Items
  TotalSum += CDbl(TempNode.SubItems.Item(3).Text)
Next
MsgBox(TotalSum) ' Debug

and it assumes that each item is a valid number.

A bit safer solutions uses TryParse to check validity:

Dim TotalSum As Double = 0
Dim TempNode As ListViewItem
Dim TempDbl As Double

For Each TempNode In ListView1.Items
  If Double.TryParse(TempNode.SubItems.Item(3).Text, TempDbl) Then
    TotalSum += TempDbl
  End If
Next
MsgBox(TotalSum)

and again calculates the sum of the fourth column.

HTH

[TIP.Synergy]

I'll try your code and i think it will work... Thanks to you Teme64 GodBless

[TIP.Synergy]

I'll try your code and i think it will work... Thanks to you Teme64 GodBless

[TIP.Synergy]

THANK YOU... Teme64 IT WORKS... :) THUMBS UP!

[Teme64]

Hi! Nice to hear that you got answer to your problem. Could you please mark the thread as solved. Thank you!

[TIP.Synergy]

Hi sir, how about if going to display total quantity of items rowcount? On the top of screen there's 3 example should display Total Quantity = 3 Thx

[codeorder]

Have you tried ".SubItems.Item(2).Text"?

If Double.TryParse(TempNode.SubItems.Item(2).Text, TempDbl) Then

..Or maybe ".SubItems.Item(1).Text" to get the Unit Price Total of the "second" Column?

[TIP.Synergy]

i mean total item in listview

Product Name
a
b
c
d

total item = 4

[codeorder]

MsgBox(ListView1.Items.Count)

[TIP.Synergy]

*_* AHAHA thx codeorder, It works :)

[TIP.Synergy]

Thanks Sir codeorder, It works

[gd740]

hello, then how to achieve the option inserting the total of the sum into the mysql database?

[codeorder]

See if this thread.reply of mine helps. :)

[gd740]

can i add the sum total of the column in the footer of listview?

[codeorder]

>>can i add the sum total of the column in the footer of listview?
If "footer" is the "header" Or "ColumnHeader", then see if this helps.

With ListView1
            .Columns(0).Text = "ListView1" '// Column1
            .Columns(1).Text = ".Count" '// Column2
        End With

[Dili1234]

thank you.......................

[klooonhie]

what if i remove 1 item the total has not been change..?

is there any solution for that

[N.E.Y.O-01]

You guys here are so GENEROUSE.......... :)

[N.E.Y.O-01]

What if, "I would like to create a query statement that would give me the sum of the column(total_bill)?"
like this:

("Select SUM(total_bill)FROM tbl_estimates WHERE estimation_date = '"& Textbox1.Text & "'",2)

I would like to Displat it in my listview.

My, Query statement is absolutely right, but then there is still an error that doesnt have a suggestion.

Maybe you guys could help me..... :)