Sir , I want to do multiply in datagridview cells but its showing some error

Question

0.00/5 (No votes)

See more:

Dear Sir,

I want to do multiplication in cell change event of cell(2) and Cell(3) and want to show in cell(4) i got this error when i run this program.."Value Cannot be Null"

this is the table

|Sno| ProductName  |Quantity|PerPrice |  Total         |
======================================================
|1  | Coke 200ml   |20      |20       |Here is Error   |

this is the code..

Private Sub DataGridView1_CellEnter(ByVal sender As Object, ByVal e As                  System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellEnter

 If DataGridView1.CurrentCell.ColumnIndex = 4 Then
            Dim n As Integer = DataGridView1.RowCount - 1

DataGridView1.Rows(n).Cells(4).Value = (Double.Parse(DataGridView1.Rows(n).Cells(2).Value) * Double.Parse(DataGridView1.Rows(n).Cells(3).Value)).ToString


        End If
    End Sub

Posted 13-Apr-14 22:24pm

Naveen Roy

Updated 13-Apr-14 22:36pm

v4

Add a Solution

Comments

Richard MacCutchan 14-Apr-14 4:26am

Don't try and do complex operations in a single line. Break your statement into its constituent parts and check the results at each stage. If either of your text boxes contain illegal characters then Double.Parse will fail. Use the TryParse method and check that it succeeds.

2 solutions

Solution 1

Chk this :

VB

Private Sub DataGridView1_CellEnter(ByVal sender As Object, ByVal e As                  System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellEnter
 
 If DataGridView1.CurrentCell.ColumnIndex = 4 Then
            Dim n As Integer = DataGridView1.RowCount - 1
dim  first_value as String
dim  Second_value as String
If Not IsDBNull(DataGridView1.Rows(n).Cells(2).Value) AndAlso DataGridView1.Rows(n).Cells(2).Value.ToString.Length <> 0 Then
 first_value =DataGridView1.Rows(n).Cells(2).Value
else
first_value ="0"
end

If Not IsDBNull(DataGridView1.Rows(n).Cells(3).Value) AndAlso DataGridView1.Rows(n).Cells(2).Value.ToString.Length <> 0 Then
 Second_value =DataGridView1.Rows(n).Cells(3).Value
else
Second_value ="0"
end


DataGridView1.Rows(n).Cells(4).Value = (Double.Parse(First_value ) * Double.Parse(Second_value )).ToString
  End If
    End Sub

Posted 13-Apr-14 22:35pm

syed shanu

Comments

Naveen Roy 17-Apr-14 4:38am

thanks for help sir...

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)

Aarti Meswania · Accepted Answer · 2014-04-13T22:37:00

Solution 2

VB

Private Sub DataGridView1_CellEnter(...) Handles DataGridView1.CellEnter
    If DataGridView1.CurrentCell.ColumnIndex = 4 Then
        Dim n As Integer = DataGridView1.RowCount - 1
        Dim Qty As Double = 0
        Double.TryParse(DataGridView1.Rows(n).Cells(2).Value, out Qty)
        Dim PerPrice As Double = 0
        Double.TryParse(DataGridView1.Rows(n).Cells(3).Value, out PerPrice)
        DataGridView1.Rows(n).Cells(4).Value = ( Qty * PerPrice).ToString()
    End If
End Sub

you can use CurrentCellDirtyStateChanged Event for count total when editing qty/per-price cells
visit link...
http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.currentcelldirtystatechanged(v=vs.110).aspx[^]
Happy coding!
:)

Posted 13-Apr-14 22:37pm

Aarti Meswania

Updated 13-Apr-14 22:41pm

v2

Comments

Naveen Roy 15-Apr-14 4:49am

Thanks for suggestion but when i using above code after provide values its ans showing 0 in the below cell even in the next row its again showing 0 when i using tab in the below cell without giving any numbers.
just like this

|Sno| ProductName |Quantity|PerPrice | Total |
======================================================
|1 | Coke 200ml |20 |20 | |
| | | | | 0 |
| | | | | 0 |

Aarti Meswania 15-Apr-14 4:55am

take a look to your code block

Dim n As Integer = DataGridView1.RowCount - 1

it is causing issue what you are doing everytime calculating "total" for grid's last line
DataGridView1.RowCount - 1

you should use CurrentCellDirtyStateChanged event and e.rowindex/columnindex property to get currrent row/col
follow link I suggested in my answer

Naveen Roy 17-Apr-14 3:10am

thank you, your above code is working.just changed some code and now is working fine thanks a lot..

Aarti Meswania 17-Apr-14 4:30am

Most welcome!
Glad to help you! :)