how get total of column

Question

1.00/5 (1 vote)

See more:

Table name collection
Sr. No.	Name	Amount
1	Mahima	45
2	Aman	56
3	Raj	78

i want to get total of Amount column at the top of .aspx's page output can you explain me how write coding in aspx.cs page can you help me for coding ???

Posted 9-Jun-15 7:40am

Mahima Singh

Updated 13-Jun-15 2:13am

Add a Solution

Comments

[no name] 9-Jun-15 14:29pm

What answer did you get the last time you asked?

Maciej Los 9-Jun-15 16:10pm

What have you tried? Where are you stuck?

Mostafa Asaduzzaman 9-Jun-15 17:37pm

Is it a simple table or gridview?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2015-06-09T10:16:00

Solution 1

Have a look here: GridView Examples for ASP.NET 2.0: Displaying Summary Data in the Footer[^]

More you can find via using Google!

Posted 9-Jun-15 10:16am

Maciej Los

Comments

Mahima Singh 10-Jun-15 11:50am

Dear I want to display total of column on Label. Kindly help for coding

Maciej Los 10-Jun-15 11:51am

See my comments to solution 2.

Mahima Singh 13-Jun-15 8:16am

it is not working dear.

Mostafa Asaduzzaman · Answer 2 · 2015-06-09T11:52:00

NOTE: If you are use System.Data.DataTable then you can use this solution

C#

decimal total = 0;
          for(int i=0;i            {
              total += Convert.ToDecimal(dt.Rows[i][2]);
          }
          txtTotal.Text = total.ToString();

In the aspx page define this:

ASP.NET

<p><asp:label text="Total Amount : " runat="server" xmlns:asp="#unknown"></asp:label><asp:textbox id="txtTotal" runat="server" enabled="false" xmlns:asp="#unknown"></asp:textbox></p>

Wrap the calculation in Page_Load or the other method to display data.

Hope this will help.