Caculate grand total and display in label in ASP.Net

You will get by using SUM() function.

SELECT SUM(column 1) AS Total From tableName

Then show the result to label.

micah says:

SELECT SUM(LikeCount) AS Total From Likes u  WHERE u.UserName=@UserName  

 Chenge with the below.

 SELECT SUM(LikeCount) AS LikeCount From Likes u  WHERE u.UserName = @UserName