Hello,
I would like to calculate cells in DataGridView ( VB Express)
My datagridview1 looks something like this.
--------------------------------------…
Row# col1 col2 col3 Col 4
--------------------------------------…
Row1 25 13 2
Row2 26 24 4
Row3 17 13 10
Row4 etc etc etc
Row5
etc
Now I want to be able to calculate each cells when I press button1 the datagridview1 should calculate automaticly.
the result will be in col 4
For example: Then the datagridview1 would look like this.
Row# col1 col2 col3 Col 4
--------------------------------------…
Row1 25 13 2 24 (25-13*2)
Row2 26 24 4 8 (26-24*8)
Row3 17 13 10 40 (17-13*10)
Row4 etc etc etc etc
Row5
etc
Pls, any ideas and codes would be very helpful.
" Notes"
I am very new to VB Express.
The table have fixed data
I have more than 1000 rows to be calculate
I am not using SQL
Thank you in advance