how to get Listview Item Name Wise Qty Total in vb.net or visual Basic 2012

Question

1.00/5 (1 vote)

See more:

How to Get in Listview Item Name Wise Qty Total

i Have an Listview Like

SrNo |Item Name Batch No Qty
1 A1 Fsd 10
2 A2 V 10
3 A3 D 10
4 A4 R 10
5 A1 T 10
6 A4 V 10
7 A2 C 10
8 A3 E 10
9 A1 Vc 10
10 A2 G 10
11 A3 H 10
12 A4 D 10
13 A4 N 10

How To Get
Item Name TotalQty
A1 30
A2 30
A3 30
A4 40

How To Above Type Total in vb.net

Posted 17-Apr-14 1:45am

Kailashkumar Raghvani

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

thatraja · Answer 1 · 2014-04-17T02:37:00

Using a simple SELECT query, you could achieve that. I'm not going to give exact query but you could change based on your table structures.

--------------------
ItemID ItemName Qty
--------------------
     1 Item1     10
     2 Item2     10
     3 Item3     10
     4 Item4     10
     1 Item1     20
     2 Item2     20
     3 Item3     20
     4 Item4     20
     1 Item1     30
     2 Item2     30
     3 Item3     30
     4 Item4     30
--------------------

Sample query to get SUM of all items is below

SQL

SELECT ItemName, SUM(Qty) FROM TableName GROUP BY ItemName

Result is here

--------------------
ItemName Qty
--------------------
Item1     60
Item2     60
Item3     60
Item4     60
--------------------

Bind this values to your Listview. Now customize this for your requirement.

And you need to spend more time on learnings.