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

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

how to sum of a distinct column in gridview

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

how to sum of a distinct column in gridview

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us