What is System.DBNull.Value used for?
Q: What is System.DBNull.Value used for?
A: System.DBNull.Value is the value of NULL retrieved from a DB. Before assigning a database field to a variable, you should always check to see if the value returned from the DB is NOT null. Otherwise, an exception could be thrown.
Example:
If Not drPkgRec("MeetDate") Is System.DBNull.Value Then
Dim strMeetingPlace = drPkgRec("MeetPlace")
End If
Note: The Keyword "Is" is used, not "=".
A: System.DBNull.Value is the value of NULL retrieved from a DB. Before assigning a database field to a variable, you should always check to see if the value returned from the DB is NOT null. Otherwise, an exception could be thrown.
Example:
If Not drPkgRec("MeetDate") Is System.DBNull.Value Then
Dim strMeetingPlace = drPkgRec("MeetPlace")
End If
Note: The Keyword "Is" is used, not "=".
Comments