Need help...asp.net count sql..

mat daus

im very new to asp.net.
i develop a website for e-commerce..now i developing a page to display the statistic of the product that bought by costumer..
here is my database structure..
Table Product-ProductID,ProductName,Description
Table Transaction-TransactionID,User,ProductID,Quantity

-in table Transaction, i store the product that bought by user with user name and quantity.
-table product, store the information about product

-this is my data, assume Bag ProductID=1 and Pencil ProductID=1 in table transaction..
-for table transaction:
TransactionID | User | ProductID | Quantity
1 | ali | 1 | 2
1 | abu | 2 | 3
1 | qwe | 1 | 5

i want make a statistic about the product that bought by users..
im using this Select query= "SELECT Product.ProductName, COUNT(Transaction.ProductID) AS ProductCount FROM Product INNER JOIN Transaction ON Product.ProductID = Transaction.ProductID GROUP BY Product.ProductName"

when using this query the result is,
ProductName | ProductCount
Bag | 2
Pencil | 1

i just want my result shown like i stated below..but i dont know how to do it..
ProductName | ProductCount
Bag | 7
Pencil | 3

please help me....

Mycroft Holmes

Instead of COUNT() try using SUM(Quantity) BTW don't put ALL your question in code brackets, just the actual code snippets

Never underestimate the power of human stupidity RAH

mat daus

i will try..im very new to this site.so i dont know how to use forum yet.

mat daus

Thanks ..it works :thumbsup:..

Mycroft Holmes

You're doing fine, sensible question and layout is not critical, glad to be of service!

Never underestimate the power of human stupidity RAH