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

Recommended Answers

All 19 Replies

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

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

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

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

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

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

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?

i mean total item in listview

Product Name
a
b
c
d

total item = 4

MsgBox(ListView1.Items.Count)

*_* AHAHA thx codeorder, It works :)

Thanks Sir codeorder, It works

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

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

>>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

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

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

is there any solution for that

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

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..... :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.