Caculate grand total and display in label in ASP.Net

Question

How do i caculate all the numbers under a column and display it in lablefor examplecolumn 1 1111display totallable  4

dharmendr · Accepted Answer

You will get by using SUM functionSELECT SUMcolumn 1 AS Total From tableNameThen show the result to label

dharmendr · Answer

micah saysSELECT SUMLikeCount AS Total From Likes u  WHERE uUserNameUserName   Chenge with the below SELECT SUMLikeCount AS LikeCount From Likes u  WHERE uUserName  UserName

Caculate grand total and display in label in ASP.Net

Company

Explore

Follow us

Contact Us