How to compute 2 cells in vb.net

Question

0.00/5 (No votes)

See more:

Hi, Im searching for a solution but i can't find any answer, Please Help me...

i have 2 cells that i want to compute and display the total.. the below code is actually fine and compute only single row, my problem is i need to compute every row automatically when i press the button2...

VB

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click

     For i As Integer = 0 To DataGridView2.RowCount - 1
         Dim xQty As Double = CDbl(DataGridView2.Rows(i).Cells(8).Value)
         Dim xPrc As Double = CDbl(DataGridView2.Rows(i).Cells(9).Value)
         DataGridView2.Rows(i).Cells(10).Value = xQty * xPrc
     Next

 End Sub

for example:

Product--------Price--------Quantity--------Total Amount
Apple----------10.00-----------2---------------20
Banana---------20.00-----------3---------------20
Orange---------10.00------------5---------------30

the first row, apple automatically change the total amount when i change the price and click the button..
but the second and third row nothing happened. i need to compute every row in just one click... thanks in advanced

Posted 20-Oct-14 16:20pm

TheHellGirl

Updated 20-Oct-14 21:34pm

Richard MacCutchan

v3

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 20-Oct-14 22:52pm

There is a loop. Isn't it working?

[no name] 21-Oct-14 0:25am

You are using web or windows ?

TheHellGirl 29-Oct-14 1:11am

Im using windows

Richard MacCutchan 21-Oct-14 3:36am

Use your debugger to step through the code and see why the loop is not repeating.

Sinisa Hajnal 21-Oct-14 4:25am

Why not use cellvalidated, cellvaluechanged or any other cell event to calculate the total value directly on change?

TheHellGirl 29-Oct-14 1:12am

i try other events, but nothing happen..

i try cellenter, its working but you need to click the datagridview to compute the column

Sinisa Hajnal 29-Oct-14 4:53am

cellEnter handles entering of the cell (as the name implies), that's why you need to enter (click) the cell to see the calculation. Use one of the above mentioned (validating for checking values), validated for changing the value of the calculated cell. You might need to call Refresh or Update on the grid for it to become visible...

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

Sinisa Hajnal · Accepted Answer · 2014-10-20T22:27:00

Solution 1

See if Computed Columns[^]

or Cell events [^]

help you.

If you really need on button update, try calling Datagridview2.Refresh and/or Invalidate after the loop finishes.

Posted 20-Oct-14 22:27pm

Sinisa Hajnal

Comments

TheHellGirl 29-Oct-14 1:49am

Thanks for the Help :)

bojammis · Accepted Answer · 2014-10-24T06:51:00

Solution 2

Howdy All,
Try this after the for loop:

Dim cm As CurrencyManager = DirectCast(datqaGridView2.BindingContext(dataGridView2.DataSource), _ CurrencyManager)
cm.Refresh()

regs,

ron O.

Posted 24-Oct-14 6:51am

bojammis

Comments

TheHellGirl 29-Oct-14 1:50am

Thanks for the Help :)