Solved

tableadapter date column checking for null

Posted on 2007-12-03
1
307 Views
Last Modified: 2008-02-01
When I try to retrieve if a date value is nothing, it errors saying the value is DBNull.

                If Not member(0).M_Creation_Date = Nothing Then _
                    creationDate = member(0).M_Creation_Date

if I do this:
If Not member(0).M_Creation_Date Is DBNull.Value Then

It says Is requires operands that have reference types. what do I put there to check if a date is null? thanks.

0
Comment
Question by:Starr Duskk
1 Comment
 
LVL 2

Accepted Solution

by:
Starr Duskk earned 500 total points
ID: 20399778
I found the answer:

If Not member(0).IsM_Creation_DateNull Then

There's a little drop down list of "is" checks for "null"
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lots of people ask this question on how to extend the “MembershipProvider” to make use of custom authentication like using existing database or make use of some other way of authentication. Many blogs show you how to extend the membership provider c…
Sometimes in DotNetNuke module development you want to swap controls within the same module definition.  In doing this DNN (somewhat annoyingly) swaps the Skin and Container definitions to the default admin selections.  To get around this you need t…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question