How to do Loop to calculate the cell values in DataGridView?

Ako Musha

8y1.7k

Hello ..

How to multiply a value of a row of a column to all the values in another column and do the loop for all rows.Then, at the end, sum the values in each row?

Thanks so much for your help!!

Here is an example.

C 1	C2	C3
40	1	40
30	2	110
20	3	200
10		140
		80 30

Please note that I do not want to have or show these three columns (I, II, III) in my table. but I just put them in here to show the steps. Column 2 could have lots of rows...

Here is what I have done...

The loop works only for the 1st two rows in Column 3..!!? I can not figure it out! Thanks a lot for your help!

Dim i As Integer

For k As Integer = 0 To Data1.ColumnCount - 4

For j = 0 to Data1.Rows.Count - 2

Data1.Rows(j).Cells(2).Value = Data1.Rows(j).Cells(0).Value * Data1.Rows(j).Cells(1).Value

For i = 0 To EOF()

i = i + 1

Data1.Rows(j).Cells(3).Value = Data1.Rows(j).Cells(0).Value * Data1.Rows(k+i).Cells(1).Value + Data1.Rows(j).Cells(2).Value

Next i

Next j

Next k

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rupesh Kahane8y ago
Yes it's possible. You can take values from grid by using loop and do calculation / apply ur logic. Will try to give you a solution by using grid.
Ako Musha8y ago
Thanks! but can this solution be done using DataGridView instead of Array?
Rupesh Kahane8y ago
Try this works

I have taken values into an array & used only C# code. In for loop you can give a maximum number of count for max conditions instead of i < 4 & j < 4.
using System;

public class Program
{
    public static void Main()
    {
        int[] myArray = new int[] {40,30,20,10 };
        int[] myArray1 = new int[] {1,2,3,4 };

        for (int i = 0; i < 4; i++)
        {
            for (int j = 0; j < 4; j++)
            {
                Console.WriteLine(myArray[i] * myArray1[j]);
            }
            Console.WriteLine();
        }
        Console.ReadLine();
    }
}

// Let me know if u have any question. ALL THE BEST
Ako Musha8y ago
Thanks Rupesh for the comment. I had an image in my original posting, which was describing the steps.
Here is what I need to have :

Out put in C3

Row 1: = 1*40 = 40
Row 2: = 1*30+2*40 = 110
Row 3: = 1*20 + 2* 30+ 3*40 = 200
Row 4: = 1*10 + 2*20 +3*30 = = 140

..... and go on to the end..... Hope this explain a littile bir more. Thanks a lot for your time.
Rupesh Kahane8y ago
I have question.
Can you elaburate some litttle bit. This is bit confusion from your question.

Give some sample data table & expected output so will help you.

Does you need to do something like
40 * 1 = 40
40 * 2 = 80
40 * 3 = 120
30 * 1 = 30
30 * 2 = 60
Or
40 * 1 = 40
30 * 2 = 60 + 40 = 100
20 * 3 = 60 + 30 + 40 = 130