Welcome to WebmasterWorld Guest from 50.19.190.144

Forum Moderators: ocean10000

Message Too Old, No Replies

what happened to "isNull()"?

how do I test for null in .NET

     
3:08 pm on May 17, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Sept 1, 2001
posts:4392
votes: 0


There used to be a VB function isNull().

But in .NET that's gone away and something called DBNull is in it's place, but it's not a comparative.

How do I check for a null value when fetching data? (outer joins and such)

3:16 pm on May 17, 2005 (gmt 0)

Junior Member

10+ Year Member

joined:July 14, 2003
posts:130
votes: 0


Try: IsDBNull(strToTest)

Is this what you meant?

4:41 pm on May 17, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Sept 1, 2001
posts:4392
votes: 0


that's what I was going for. does that work in .NET? (vb)
8:19 am on May 18, 2005 (gmt 0)

Junior Member

10+ Year Member

joined:July 14, 2003
posts:130
votes: 0


It works for me but I admit I haven't really researched it. Its definately different from an empty string though!
8:27 am on May 18, 2005 (gmt 0)

Junior Member

10+ Year Member

joined:Dec 18, 2003
posts:146
votes: 0


If you want to use it as a comparative it's DBNull.Value