Click here to Skip to main content
15,881,709 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: to run asp.net 4.0 web application on VS 2005 Pin
Dennis E White17-Nov-11 20:02
professionalDennis E White17-Nov-11 20:02 
Questionbuilt in login control with sqlserver Pin
MalarGayu17-Nov-11 16:22
MalarGayu17-Nov-11 16:22 
AnswerRe: built in login control with sqlserver Pin
Not Active17-Nov-11 17:21
mentorNot Active17-Nov-11 17:21 
QuestionDataGrid Control Pin
Lavitiz17-Nov-11 12:00
Lavitiz17-Nov-11 12:00 
AnswerRe: DataGrid Control Pin
Not Active17-Nov-11 12:08
mentorNot Active17-Nov-11 12:08 
GeneralRe: DataGrid Control Pin
Lavitiz17-Nov-11 12:18
Lavitiz17-Nov-11 12:18 
Questionproblem update data in web control Pin
rachel_m17-Nov-11 4:41
rachel_m17-Nov-11 4:41 
QuestionNeed help...asp.net count sql.. Pin
mat daus16-Nov-11 21:26
mat daus16-Nov-11 21:26 
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=2 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....

AnswerRe: Need help...asp.net count sql.. Pin
Pete O'Hanlon17-Nov-11 0:36
mvePete O'Hanlon17-Nov-11 0:36 
AnswerRe: Need help...asp.net count sql.. Pin
Dennis E White17-Nov-11 10:32
professionalDennis E White17-Nov-11 10:32 
Questionnavigation between secure pages Pin
MalarGayu16-Nov-11 15:09
MalarGayu16-Nov-11 15:09 
AnswerRe: navigation between secure pages Pin
Not Active16-Nov-11 15:20
mentorNot Active16-Nov-11 15:20 
GeneralRe: navigation between secure pages Pin
MalarGayu16-Nov-11 16:15
MalarGayu16-Nov-11 16:15 
GeneralRe: navigation between secure pages Pin
Not Active16-Nov-11 16:37
mentorNot Active16-Nov-11 16:37 
GeneralRe: navigation between secure pages Pin
MalarGayu16-Nov-11 16:45
MalarGayu16-Nov-11 16:45 
GeneralRe: navigation between secure pages Pin
Not Active16-Nov-11 16:49
mentorNot Active16-Nov-11 16:49 
GeneralRe: navigation between secure pages Pin
MalarGayu16-Nov-11 17:07
MalarGayu16-Nov-11 17:07 
GeneralRe: navigation between secure pages Pin
Not Active16-Nov-11 17:25
mentorNot Active16-Nov-11 17:25 
GeneralRe: navigation between secure pages Pin
MalarGayu16-Nov-11 17:45
MalarGayu16-Nov-11 17:45 
GeneralRe: navigation between secure pages Pin
s_magus16-Nov-11 19:23
s_magus16-Nov-11 19:23 
QuestionOptions for creating simple PDF in ASP.NET Pin
RvrBndBrewer16-Nov-11 5:01
RvrBndBrewer16-Nov-11 5:01 
SuggestionRe: Options for creating simple PDF in ASP.NET Pin
Rojan Gh.16-Nov-11 15:03
professionalRojan Gh.16-Nov-11 15:03 
AnswerRe: Options for creating simple PDF in ASP.NET Pin
Andy_L_J17-Nov-11 0:11
Andy_L_J17-Nov-11 0:11 
Questionasp.net MVC3 unobtrusive validation causes IE8 to crash Pin
Madhu Kampurath15-Nov-11 20:26
Madhu Kampurath15-Nov-11 20:26 
Question2010 asp.net options Pin
rachel_m15-Nov-11 9:54
rachel_m15-Nov-11 9:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.