handling dbnull data in vb.net

by

The only way that i know of is to test for it, you can do a combined if though to make it easy.

If NOT IsDbNull(myItem("sID")) AndAlso myItem("sID") = sId Then
   'Do success
ELSE
   'Failure
End If

I wrote in VB as that is what it looks like you need, even though you mixed languages.

Edit

Cleaned up to use IsDbNull to make it more readable

More Related Contents:

  1. Hangman VB Not Working
  2. VB: Unhandled exception [duplicate]
  3. First time execution was not stopped
  4. OleDbException was unhandled…….Syntax error in UPDATE statement
  5. How To Get Control Property by “String Name”?
  6. (OrElse and Or) and (AndAlso and And) – When to use?
  7. Difference between DirectCast() and CType() in VB.NET
  8. Write text files without Byte Order Mark (BOM)?
  9. When to use StringBuilder? [duplicate]
  10. How to use comparison methods between class object modules in VBA in a similar manner as VB.NET?
  11. System.Data.OracleClient requires Oracle client software version 8.1.7
  12. HTTP GET in VB.NET
  13. Option Strict on by default in VB.NET
  14. Passing parameter to query for Access database
  15. What is the use of a shared variable in VB.NET?
  16. Is VB really case insensitive?
  17. Associating file extensions with a program
  18. Nullable type with inline if cannot work together?
  19. How to add a project as a reference of another project
  20. Is there a possibility to address elements on a website which have no ID?
  21. How to escape double quotes in as a parameter to an NUnit TestCase?
  22. Execute a SQL Stored Procedure and process the results [closed]
  23. Why am I getting, “Object reference not set to an instance of an object.” but no line of code is implicated?
  24. How to make SendKeys act Synchronously in IBM Host Access Library
  25. Show checked rows into another DataGridView
  26. DataGridView Cascading/Dependent ComboBox Columns
  27. Detecting Enter keypress on VB.NET
  28. Nothing = String.Empty (Why are these equal?)
  29. VB Detect Idle time
  30. Help with Linq and Generics. Using GetValue inside a Query

Leave a Comment