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

Micah David

10y812

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Micah David10y ago
i used formview grid to display the total while using procedure to fetch the data from database, see below
protectedvoidPage_Load(objectsender,EventArgse)
{
if(!Page.IsPostBack)
{
if(this.Page.User.Identity.IsAuthenticated)
{
stringusername=this.Page.User.Identity.Name;
GetProfile(username);
}
}
}
publicvoidGetProfile(stringusername)
{
SqlConnectioncon=newSqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);
SqlDataAdapteradp=newSqlDataAdapter("getLikes",con);
adp.SelectCommand.CommandType=CommandType.StoredProcedure;
adp.SelectCommand.Parameters.AddWithValue("@UserName",username);
//adp.SelectCommand.Parameters.AddWithValue("@FriendUserName",username);
DataTabledt=newDataTable();
adp.Fill(dt);
if(dt.Rows.Count>0)
{
Alertdisplay.DataSource=dt;
Alertdisplay.DataBind();
}
}
}
html markup
<asp:FormViewID="Alertdisplay"runat="server">
<ItemTemplate>
<asp:LabelID="lblcount"runat="server"Text='<%#DataBinder.Eval(Container.DataItem,"LikeCount")%>'CssClass=""Font-Bold="True"/>
ItemTemplate>
asp:FormView>
here is the procedure
ALTERPROCEDURE[dbo].[getLikes](
@UserNamevarchar(200)
)
AS
BEGIN
DECLARE@USERPostASTABLE(IDINT,FriendUserIdint,UserIdint)
DECLARE@LikesASTABLE(IDINT,FriendUserIdint,UserIdint)
SELECTu.UserName,u.FriendUserName,u.LikeCountFROMLikesu,USERPosts,User3vWHEREu.posttableID=s.IdANDu.UserName=@UserNameORDERBYu.IdDESC
please how do i use this to empliment your example
0
Bhuvan Pandey10y ago
Try this code. Change these information as per your system
1. server=PC156630
2. Initial Catalog=MyNewDB
3. User ID=sa
4. Password=password@123
Change table name and column name
SqlConnectionconn=newSqlConnection("server=PC156630;InitialCatalog=MyNewDB;PersistSecurityInfo=True;UserID=sa;Password=password@123");
conn.Open();
SqlCommandcommand=newSqlCommand("Selectsum(pqty)Totalfromproduct",conn);
inttotal=(int)command.ExecuteScalar();
conn.Close();
Label1.Text=total.ToString();
0
Vinay Singh10y ago
Hi
check the code
SqlConnectionconn=newSqlConnection("DataSource=;InitialCatalog=;PersistSecurityInfo=True;UserID=;Password=");
conn.Open();
SqlCommandcommand=newSqlCommand("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();
0