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 sender,EventArgse) { 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("@FriendUserName",username); 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.UserName,u.FriendUserName,u.LikeCount FROM Likesu,USERPosts,User3v 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();

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

Answers (3)