empty fields in datagridview

Question

1.00/5 (1 vote)

See more:

There is 6 rows and 3 columns in my datagridview. I tried to check empty fields with this code:

VB

For r As Integer = 0 To 5 Step 1
           For c As Integer = 1 To 3 Step 1
               If mydgv(c, r).Value.ToString = "" Or mydgv(c, r).Value.ToString = "0" Then

                   MsgBox("Field can not be zero or empty")
               Else
                   'do something
               End If
           Next c
       Next r

but I get an error:
Object reference not set to an instance of an object.
What is wrong?
Thanks in advance.
Zlatkodo

Posted 9-Sep-13 18:15pm

zlatkodo

Updated 9-Sep-13 18:51pm

Menon Santosh

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 10-Sep-13 0:40am

I have no gut to answer to this. Who told you that mydgv(c, r) or mydgv(c, r).Value is not null? Why not checking for null — it would certainly indicate that the cell is null (cell, not "field")? Why doing ToString?!!!
I hope that would be enough to solve it...
—SA

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)

Menon Santosh · Answer 1 · 2013-09-09T18:59:00

or you can use this code

VB

For r As Integer = 0 To 5 Step 1
           For c As Integer = 1 To 3 Step 1
               If Convert.ToString(mydgv(c, r).Value) = "" Or Convert.ToString(mydgv(c, r).Value) = "0" Then

                   MsgBox("Field can not be zero or empty")
               Else
                   'do something
               End If
           Next c
       Next r

zlatkodo · Answer 2 · 2013-09-09T20:06:00

- I get a multiple messages ( as many as is number of empty cells + zero cells).
- Even with Exit For I get a multiple messages (as many as is the row number)
- In some cases code "do something" even with some cells value = 0 or empty.
Is there any other way to validate cell content?
Thanks in advance.

For r As Integer = 0 To 5 Step 1
          For c As Integer = 1 To 3 Step 1
              If Convert.ToString(a(c, r).Value) = "" Or Convert.ToString(a(c, r).Value) = "0" Then
 
                  MsgBox("Field can not be zero or empty")
                  ' Exit For
              Else
                  'do something
                
              End If
          Next c
      Next r

empty fields in datagridview

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0