Solved

tableadapter date column checking for null

Posted on 2007-12-03
1
318 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

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…
ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

756 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