how to sum of a distinct column in gridview

Question

0.00/5 (No votes)

See more:

hi
I have a combobox which have three different types of item. when I click on the add button then first item add in gridview then second and so on.. Now I want to sum of different types column and show output in three different textboxes.

like

scooter motorcycle cycle
10 22 11
22 33 22

I am using this code but not shows distinct value.

C#

TotalGrossGd = Convert.ToDouble(objDT.Compute("SUM(txtWeight)", ""));
TotalGrossSl = Convert.ToDouble(objDT.Compute("SUM(txtWeight)", ""));
TotalGrossAmount = Convert.ToDouble(objDT.Compute("SUM(txtTotalL)", ""));

txtGrossGd.Text = TotalGrossGd.ToString();
txtGrossSl.Text = TotalGrossSl.ToString();
txtTotalAmount.Text = TotalGrossAmount.ToString();

Posted 11-Nov-13 15:15pm

indiancodinglove

Add a Solution

Comments

Marla Sukesh 11-Nov-13 22:18pm

Its difficut to understand exactly what you are doing and what you want

indiancodinglove 11-Nov-13 23:38pm

I have a datagridview and some textboxes. when I am click on the add button then all values show in datagridview now I want to sum of scooter in a textbox and motorcycle sum of in other textbox and total amount of purchase in other textbox which is only view at that time when the program running if I am deleting sum row in gridview then sum of scooter,motorcycle,amount will be delete at the running time

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)

Abhinav S · Answer 1 · 2013-11-11T16:58:00

Solution 1

The ideal scenario would be to do this in the query and display it in the grid.

Posted 11-Nov-13 16:58pm

Abhinav S

agent_kruger · Answer 2 · 2013-11-12T00:36:00

Solution 2

if you want to sum a particular record and setting datasource then you can use the "compute" function of datatable or if not setting through data source "loop" through the datagridview and add the value in a variable.

Posted 12-Nov-13 0:36am

agent_kruger