Add a list of values in single variable

Question

In my database table I have a registrationdate field, Minutes field,projectId. In that RegistrationDate varies for same projectId. I need to get the all Minutes(double) values into a single variable(Total number of mintues) for particular projectId.(through code behind C#)

Nilesh Shah · Answer

You can get a list of all minutes belonging to projectId and have a sum on them to get total. Advise to always post table structure while asking questions related to any table.