?
Solved

tableadapter date column checking for null

Posted on 2007-12-03
1
Medium Priority
?
329 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 2000 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

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Question has a verified solution.

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

IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
The video provides a quick and easy steps to migrate MBOX file to well known Outlook PST and Office 365. Besides this, it also supports and migrates more than 20 email clients of MBOX which include AppleMail, Opera, Thunderbird and SeaMonkey effortl…
Watch the video to learn how one can deal with PST file corruption issue with an outstanding Kernel for Outlook PST Repair Tool easily. Using this tool, non-technical users can swiftly perform the repair process to restore their essential data witho…
Suggested Courses
Course of the Month5 days, 22 hours left to enroll

589 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