Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6527
  • Last Modified:

VB.NET IsNull?

in vb6 there was IsNull()... is there a replacement in vb.net?

   - Marc
0
MarcGraff
Asked:
MarcGraff
1 Solution
 
appariCommented:
there is no direct function as in VB 6.

but there are few otherways of checking for null. like check whether the variable is nothing or using dbNull. here is an example which i use in my .net projects, code is from http://www.freevbcode.com/ShowCode.Asp?ID=5810

    Enum enumObjectType
        StrType = 0
        IntType = 1
        DblType = 2
    End Enum

Public Function CheckDBNull(ByVal obj As Object, _
    Optional ByVal ObjectType As enumObjectType = enumObjectType.StrType) As Object
        Dim objReturn As Object
        objReturn = obj
        If ObjectType = enumObjectType.StrType And IsDBNull(obj) Then
            objReturn = ""
        ElseIf ObjectType = enumObjectType.IntType And IsDBNull(obj) Then
            objReturn = 0
        ElseIf ObjectType = enumObjectType.DblType And IsDBNull(obj) Then
            objReturn = 0.0
        End If
        Return objReturn
 End Function

you can change above function to suit your needs.
0
 
MarcGraffAuthor Commented:
Wow! Works great! Thanks!

   - Marc
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now