how to rows of values in asp.net

Question

hi friends ia have some rows ..student fee column i wan to calculate by using student id how much fee was payed to school so please write a query for result for addition of rows values.. like student id =1  his payed 3 time 10005003000..iwat to display total amount =4500 in asp.net so please help .. thank you ..

Manas Mohapatra · Answer

Table(tblStudentPayment): StudentID StudentFee ------------- -------------- 1 1000 2 2000 1 500 2 1000 1 3000 SELECT StudentID SUM(StudentFee) as TotalFee FROM tblStudentPayment GROUP BY StudentID;