how to calculate all the numbers in a rows under a column

Question

How do i calculate all the numbers in rows under a column and display total in label on page

Micah David · Answer

i used formview grid to display the total while using procedure to fetch the data from database see below protected void Page_Load( object senderEventArgse) { if (!Page.IsPostBack) { if ( this .Page.User.Identity.IsAuthenticated) { string username= this .Page.User.Identity.Name; GetProfile(username); } } } public void GetProfile( string username) { SqlConnectioncon= new SqlConnection(ConfigurationManager.ConnectionStrings[ conn ].ConnectionString); SqlDataAdapteradp= new SqlDataAdapter( getLikes con); adp.SelectCommand.CommandType=CommandType.StoredProcedure; adp.SelectCommand.Parameters.AddWithValue( @UserName username); //adp.SelectCommand.Parameters.AddWithValue(@FriendUserNameusername); DataTabledt= new DataTable(); adp.Fill(dt); if (dt.Rows.Count>0) { Alertdisplay.DataSource=dt; Alertdisplay.DataBind(); } } } html markup asp:FormView ID = Alertdisplay runat = server > ItemTemplate > asp:Label ID = lblcount runat = server Text = ' ' CssClass =  Font-Bold = True /> ItemTemplate > asp:FormView > here is the procedure ALTER PROCEDURE [dbo].[getLikes]( @UserName varchar (200) ) AS BEGIN DECLARE @USERPost AS TABLE (ID INT FriendUserId int UserId int ) DECLARE @Likes AS TABLE (ID INT FriendUserId int UserId int ) SELECT u.UserNameu.FriendUserNameu.LikeCount FROM LikesuUSERPostsUser3v WHERE u.posttableID=s.Id AND u.UserName=@UserName ORDER BY u.Id DESC please how do i use this to empliment your example

Bhuvan Pandey · Answer

Try this code. Change these information as per your system server=PC156630 Initial Catalog=MyNewDB User ID=sa Password=password@123 Change table name and column name SqlConnectionconn= new SqlConnection( server=PC156630;InitialCatalog=MyNewDB;PersistSecurityInfo=True;UserID=sa;Password=password@123 ); conn.Open(); SqlCommandcommand= new SqlCommand( Selectsum(pqty)Totalfromproduct conn); int total=( int )command.ExecuteScalar(); conn.Close(); Label1.Text=total.ToString();

Vinay Singh · Answer

Hi check the code SqlConnectionconn= new SqlConnection( DataSource=;InitialCatalog=;PersistSecurityInfo=True;UserID=;Password= ); conn.Open(); SqlCommandcommand= new SqlCommand( Selectsum(column_Name)astotalfrom[table1]wherename=@zip conn); command.Parameters.AddWithValue( @zip  india ); //intresult=command.ExecuteNonQuery(); using (SqlDataReaderreader=command.ExecuteReader()) { if (reader.Read()) { label1.Text=reader[ total ].ToString(); } } conn.Close();