Solved

tableadapter date column checking for null

Posted on 2007-12-03
1
289 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:BobCSD
1 Comment
 
LVL 1

Accepted Solution

by:
BobCSD 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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

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…
This article discusses the ASP.NET AJAX ModalPopupExtender control. In this article we will show how to use the ModalPopupExtender control, how to display/show/call the ASP.NET AJAX ModalPopupExtender control from javascript, how to show/display/cal…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

708 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now