How to sum of two rows values inside the datagridview c#

Question

4.00/5 (2 votes)

See more:

How to sum of two rows values inside the DataGridView, if the id of the both rows same and create one rows instead of two rows in the DataGrid?

Like the following example:

id           quantity       Bonus        price           total

01             25           10           123            4305

01             5             10          123            1845

I want to sum of the above two rows like this in the DataGrid.

id           quantity        Bonus         price          total

01              30            20             123          6150

if i take loop on it then duplicate value insert in the datagridview.

like my code

For example:

for(int i=0; i<datagridview.rows.count; i++)
{

if(datagridview.rows[i].cells[0].value==txtid.Text)
{
if(comboboxtype=="Stock")
{
//For Stock
///updation code,if value exist in the datagrid
}
else
{
//For Bonus
///updation code,if value exist in the datagrid
}

}
else
{
if(comboboxtype=="Stock")
{
//For Stock

/// ///Insertion code, if value does not exist in the datagrid
}
else
{
/// For Bonus
/// ///Insertion code, if value does not exist in the datagrid
}

}
}

Please,Anyone Can help me?

Posted 13-Sep-13 1:59am

Zain -Ul- Arifeen

Updated 13-Jul-20 12:22pm

v4

Add a Solution

Comments

Thanks7872 13-Sep-13 8:04am

Post the code in order to show the effort you have made to achieve this.

3 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)

CodeBlack · Answer 1 · 2013-09-13T02:55:00

I would suggest to use LINQ Query to assign datasource to the grid as mentioned below :

For Example My class name is stock then

STOCK Class:

C#

public class Stock
    {
        public int Id { get; set; }

        public int Quantity { get; set; }

        public int Bonus { get; set; }

        public int Price { get; set; }

        public int Total { get; set; }
    }

Then below linq query should be used to assign datasource :

C#

var stocks = stockList.Select(s => s.Id).Distinct().Select(stock => new Stock
                {
                    Id = stock,
                    Quantity = stockList.Where(s => s.Id == stock).Sum(s => s.Quantity),
                    Bonus = stockList.Where(s => s.Id == stock).Sum(s => s.Bonus),
                    Price = stockList.Where(s => s.Id == stock).Select(s => s.Price).FirstOrDefault(),
                    Total = stockList.Where(s => s.Id == stock).Sum(s => s.Total),
                }).ToList();

Note : Above query will sum all the properties except ID and price. and stockList is the list object of Stock which contains all the data for Stock.

gourav agrawal · Answer 2 · 2013-09-13T04:12:00

use linq query on your dataset with sum function and group by clause...

like .....

var rows = from a in query
group a by new {
h = a.c.BookingRefex,
b = a.c.ClientRefex,
c = a.b.PickupCity,
d = a.b.PickupPostalCode
} into g
select new {
BookingRefex = g.Key.h,
ClientRefex = g.Key.b,
SumQuantity = g.Sum(p => p.bg.Quantity),
Value = g.First().c.Value
}

Jassom · Answer 3 · 2020-07-13T12:22:00

I suggest you this solution:

before inserting a new line to the datagridview, check if the ID is already inserted to the datagridview, so if it inserted before -> do this:

C#

private void button1_Click(object sender, EventArgs e)
        {
            bool theItemIsExist = false;

            // this (for) loop is to check if the id is already exist .. if true sum new values to the old values
            for (int i = 0; i < dataGridView1.Rows.Count-1; i++)
            {
                if (dataGridView1.Rows[i].Cells[0].Value.ToString() == TXTID.Text)
                {
                    dataGridView1.Rows[i].Cells[1].Value = Convert.ToDecimal(dataGridView1.Rows[i].Cells[1].Value) + Convert.ToDecimal(TXTQuantity.Text);
                    dataGridView1.Rows[i].Cells[2].Value = Convert.ToDecimal(dataGridView1.Rows[i].Cells[2].Value) + Convert.ToDecimal(TXTBonus.Text);
                    dataGridView1.Rows[i].Cells[3].Value = Convert.ToDecimal(dataGridView1.Rows[i].Cells[3].Value) + Convert.ToDecimal(TXTPrice.Text);
                    dataGridView1.Rows[i].Cells[4].Value = Convert.ToDecimal(dataGridView1.Rows[i].Cells[4].Value) + Convert.ToDecimal(TXTTotal.Text);

                    theItemIsExist = true;
                    break;
                }
            }

            // after checking the list and there is no id exist .. then add new line with values
            if (!theItemIsExist)
            {
                dataGridView1.Rows.Add(TXTID.Text, TXTQuantity.Text, TXTBonus.Text, TXTPrice.Text, TXTTotal.Text);
            }
        }

I tested it , and it works

note: do some changes in this code to fit with yours (names of tools and so on)

How to sum of two rows values inside the datagridview c#

3 solutions

Solution 1

Solution 2

Solution 4

Add your solution here

Preview 0