Vb.net Convert Integer DBNULL to 0 - error

vb.net integer dbnull
MMM picture MMM · Sep 17, 2012 · Viewed 16.8k times · Source

I'm having this method:

Private Function convertInteger(intInteger As Object) As Integer

    If IsDBNull(intInteger) Then
        convertInteger = 0
    Else
        convertInteger = cInt(intInteger)
    End If

End Function

But it returns this error:

operator '=' is not defined for type 'integer' and type 'dbnull'

Im trying to convert a DBnull value to 0..

But the problem is that the value im trying to convert is not always DBnull.. so how should i handle this?

Answer

codingbiz picture codingbiz · Sep 17, 2012

Try this

Private Function convertInteger(intInteger As Object) As Integer

    If intInteger = DBNull.Value Then
        Return 0
    End If

    Return intInteger

End Function

As suggested by [Tim Schmelter], look into Nullable types

Related questions

VB Check if int is empty

A really boring question, sorry, but I really don't know that yet ;) I've tried always string.empty, but with a decimal this produces an error. Is there any function? Unfortunately, for the simplest questions, there are no answers on google

Read More
Is there any difference between Integer and Int32 in VB.NET?

In VB.NET, is there any difference between Integer and Int32? If yes, please explain.

Read More
What is a NullReferenceException, and how do I fix it?

I have some code and when it executes, it throws a NullReferenceException, saying: Object reference not set to an instance of an object. What does this mean, and what can I do to fix this error?

Read More