How to sum total amount in DataGridView

Question

1.00/5 (2 votes)

See more:

How to Sum total amount in DataGridView

Column1	Column2	Column3	Column n	 TOTAL
500	100	300	900
200	75	100	375
100	25	150	275
400	50	225	675
500	100	450	1050

Please tell me how to sum total.

Posted 19-Feb-13 8:10am

Navas Khanj

Updated 19-Feb-13 8:15am

André Kraak

v3

Add a Solution

Comments

Maciej Los 19-Feb-13 14:19pm

and the data comes from???

Navas Khanj 19-Feb-13 14:22pm

Table

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 · 2013-02-19T08:49:00

Solution 1

If you can get the data from table, use this:

SQL

SELECT Column1, Column2, Column3, ColumnN, (Column1 + Column2 + Column3 + ColumnN) AS TOTAL
FROM TableName

Do not forget to use COALESCE()[^] function. Why? Read it.

Posted 19-Feb-13 8:49am

Maciej Los

Comments

Sergey Alexandrovich Kryukov 19-Feb-13 18:40pm

It might not be the correct question, just because OP only answered "table", without any detail, so who knows what is that?
Nevertheless, I voted 5, because all of the above is not so important. What is important, is the idea to have some data layers and work with this data layer, without using a broken telephone of the UI.
Messing with UI messes up isolation between layers and makes project non-maintainable.
—SA

Maciej Los 20-Feb-13 12:33pm

Thank you, Sergey ;)

Sergey Alexandrovich Kryukov 19-Feb-13 18:42pm

In view of that, I decide to elaborate. Please see Solution 2.
—SA

Sergey Alexandrovich Kryukov · Answer 2 · 2013-02-19T12:41:00

Please see the Solution 1, taking into account my comment to it. You were moving in wrong direction.

I suggest you learn and analyze applicability of the following architectural patterns (http://en.wikipedia.org/wiki/Architectural_pattern_(computer_science)[^]):

MVVM — Model View View Model,
http://en.wikipedia.org/wiki/Model_View_ViewModel[^],

MVC — Model-View-Controller,
http://en.wikipedia.org/wiki/Model-view-controller[^]),

MVA — Model-View-Adapter,
http://en.wikipedia.org/wiki/Model–view–adapter[^],

MVP — Model-View-Presenter,
http://en.wikipedia.org/wiki/Model-view-presenter[^].

Pay attention for the motivation of those architectures. If you understand it, you would be able to create better design ideas.

—SA