Null Binary Field

Hot Topic

register ocx files
Loading Data Using ProgressBar as Indicator
Connecting Application to Internet
How to apply keydown handle to all controls in a form or a container?
How to center controls
how do i do autoclicks and get a pixle color?
Gonna make me sound stupid
Print directly to the printer
Selected text not showing in a combobox
Dll Hell

Visual Basic

View Access Report/Form properties from VB.Net
Creating a subclass
Securing Application
Turn off green coloring after filling out a snippet?
Socket Encoding and Decoding using Ascii Encoding
Encrypting a file using Windows Explorer cryptography
Adding Timestamp to RichTextBox
math function
Console textbox
How to reuse My.Resource strings in multiple applications

Null Binary Field

I have a photo field (image) in MSDE. Some records have photos, others have null. If it is null, I want to exit sub.

If IsNothing(dtTry.Rows(lstPhotos.SelectedIndex)("photo")) Then Exit Sub

But the problem is that the above VB 2003 code always returns False even for records with photo being null . How can I modify it to return True for records with null photo




Answer this question

Null Binary Field

  • xxpor

    Great! Works like charm.

  • MachAngle

    AtinLango wrote:

    I have a photo field (image) in MSDE. Some records have photos, others have null. If it is null, I want to exit sub.

    If IsNothing(dtTry.Rows(lstPhotos.SelectedIndex)("photo")) Then Exit Sub

    But the problem is that the above VB 2003 code always returns False even for records with photo being null . How can I modify it to return True for records with null photo

    Have you tried IsDBNull

    --------------------------------------------------------------------------------------

    If IsDBNull(dtTry.Rows(lstPhotos.SelectedIndex)("photo")) Then Exit Sub

    DBnull is not the same as Nothing and is also not the same as zero-length string ("")
  • Null Binary Field
Answer this question