how to rows of values in asp.net

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 ,1000,500,3000..iwat to display total amount =4500 in asp.net so please help ..

thank you ,..