Please update my code

Question

C#, desktop application, visual studio 2015.

I have a dataGridView like this:

Type	Item	Price	Quantity
L	A	3	2
M	B	4	3
L	A	5	7
M	B	6	8
L	A	3	5
S	C	2	9
S	C	1	12

I need another dataGridView like this:

Sl. No.	Type	Item	TotalPrice	TotalQuantity
1	L	A	11	14
2	M	B	10	11
3	S	C	3	21

I am trying like this but failed:

private void button1_Click(object sender, EventArgs e)

{

dataGridView2.Visible = true;

List _product = new List();

int Count = 1;

foreach (DataGridViewRow row in dataGridView1APen.Rows)

{

if (row.Cells[0].Value != "" && row.Cells[0].Value != null)

{

if (_product.Where(x => x.SoinikNo.ToLower() == row.Cells[0].Value.ToString().ToLower()).Any())

{

string Utsob = (Convert.ToInt32(_product.Where(x => x.SoinikNo.ToLower() == row.Cells[0].Value.ToString().ToLower()).Select(x => x.Utsob).FirstOrDefault()) + Convert.ToInt32(row.Cells[13].Value.ToString())).ToString();

string Pension = (Convert.ToInt32(_product.Where(x => x.SoinikNo.ToLower() == row.Cells[0].Value.ToString().ToLower()).Select(x => x.Pension).FirstOrDefault()) + Convert.ToInt32(row.Cells[12].Value.ToString())).ToString();

_product.Where(x => x.SoinikNo.ToLower() == row.Cells[0].Value.ToString().ToLower()).ToList().ForEach(x => { x.Utsob = Utsob; x.Pension = Pension; });

}

else

{

_product.Add(new ProductList

{

Sno = Count,

SoinikNo = row.Cells[2].Value.ToString(),

APenName = row.Cells[3].Value.ToString(),

Pension = row.Cells[12].Value.ToString(),

Utsob = row.Cells[13].Value.ToString()

});

Count++;

}

dataGridView2.DataSource = _product;

}

Nilesh Shah · Accepted Answer

your problem seems simple, hence it should have a simple solution   why are you trying to process data once it has been displayed in grid?   instead of that, process data at the source only i.e. if you get the result from an SQL server SP then modify the SP or if you are using LINQ then modify LINQ statement   I see if you group by Type and sum price and quantity, you will get data in desired format.

Shovan Saha · Answer

Dear Nilesh Sir, I am new in code. Please write two line of code for me that I can understand. I am not using SQL server.