vb.net - read null value from database

Question

I have a database where in column there is no value (so it's null), but I can't handle this in vb.net. I tried with this code:

            reader.Read()
            If String.IsNullOrEmpty(reader.GetString(0)) Then
                Return
            Else
                tilbulfolderTextBox.Text = reader.GetString(0)
            End If

and also with:

If reader.Read() = False Then

and with:

If IsDBNull(reader.Read()) Then

But apparently it doesn't work because I get exception on the statement after the Else that I can't get Null values with this method. I guess you will figure out what I require from the program by reading the code itself.

Steve · Accepted Answer · 2019-03-29T13:29:27.510

The IsDBNull method of the DbDataReader base object is defined to handle this situation.
Of course you can't try to read something if the reader.Read() returns with false (meaning no more rows are available)

    If reader.Read() Then
        If reader.IsDBNull(0) Then
            Return
        Else
            tilbulfolderTextBox.Text = reader.GetString(0)
        End If
   End If

Also, I don't see more of your code, but keep in mind that returning in this way could be very wrong if you don't close the connection and dispose the objects involved in this operation

And, yes, as others have pointed out, there is also a function called IsDBNull from the Microsoft.VisualBasic assembly, but, I prefer to use the methods provided by the classes defined in the .NET framework and not the ones provided for compatibility with previous versions of VB

score 3 · Answer 2 · answered Apr 23 '13 at 10:37

You should use IsDbNull function to comapre it with null:

        reader.Read()
        If IsDbNull(reader(0)) OrElse String.IsNullOrEmpty(reader.GetString(0)) Then
            Return
        Else
            tilbulfolderTextBox.Text = reader.GetString(0)
        End If

score 2 · Answer 3 · edited May 23 '17 at 11:46

2

.Net has a different type for handling SQL NULLs: DbNull.

Check this post about how to handle it: handling dbnull data in vb.net

In your case, you need the IsDbNull function, check this MSDN Documentation about it.

If IsDbNull(data) Then
    return
Else
    tilbulfolderTextBox.Text = data
End If

edited May 23 '17 at 11:46

Community

1
1

answered Apr 23 '13 at 10:34

SysDragon

9,692
15
60
89

score 2 · Answer 4 · answered Apr 23 '13 at 10:35

2

use IsDBNull function to ensure that the value from DataReader is null or not. Then proceed the code flow.

answered Apr 23 '13 at 10:35

Rajaprabhu Aravindasamy

66,513
17
101
130

score 2 · Answer 5 · answered Apr 23 '13 at 10:36

Sounds like your IF may not be working properly

Try using IsDBNull instead.

IsDBNull is a boolean variable and can be used like the following;

reader.Read()

If Not IsDbNull(reader.GetString(0)) Then
    tilbulfolderTextBox.Text = reader.GetString(0)
Else
    return
End If

score 2 · Answer 6 · answered Apr 23 '13 at 10:37

2

try this

reader.Read()
        If IsDbNull(reader.GetString(0)) Then
            Return
        Else
            tilbulfolderTextBox.Text = reader.GetString(0)
        End If

answered Apr 23 '13 at 10:37

Mandeep Singh

2,016
7
19
32

vb.net - read null value from database

6 Answers6

Linked