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.

this is how i did it

ALTER PROCEDURE [dbo].[getLikes](
	
	@UserName varchar(200)
	
)
AS
BEGIN


DECLARE @Likes AS TABLE(ID INT, FriendUserId int,UserId int, LikeCount int)

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






	

END

got error

Server Error in '/' Application.
DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'LikeCount'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'LikeCount'.

Source Error:


Line 15:                                         <ItemTemplate>
Line 16:                                           
Line 17:                                              <asp:Label ID="lblname" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"LikeCount") %>'   CssClass="" Font-Bold="True"  />  
Line 18:                                          
Line 19:                                         </ItemTemplate>

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