Assign null value to date datatype

Question

2.00/5 (1 vote)

See more:

Dear Coders,

I am having trouble assigning a date datatype value to null. If i assign like

VB

Dim MyDate as Date

MyDate = DbNull.value

Its showing error like cannot convert the value. Please Help.

Posted 21-Nov-12 20:41pm

armarzook

Updated 21-Nov-12 21:09pm

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 22-Nov-12 2:49am

Of course you cannot. This is not a nullable type; and DbNull is a special type used to conduct a notion of null in relational databases, which is not the same thing as CLI null. This is a double incompatibility.

Better explain what exactly do you want to achieve. DbNull makes no sense if you don't use ADO.NET. Where do you use it?

--SA

armarzook 22-Nov-12 3:09am

Sorry. not data datatype.. Its Date Datatype.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2012-11-21T20:50:00

Solution 1

You can't assign DBNull.Value to anything in particular - it is a value that is passed between .NET and SQL to indicate a null value in a database table, not a value you can generally use in your application. Try Nothing instead. (But that probably won't do what you want either :laugh:)

Posted 21-Nov-12 20:50pm

OriginalGriff

Comments

armarzook 22-Nov-12 3:19am

Read the question now please...

OriginalGriff 22-Nov-12 3:23am

Still not changed - you still can't assign DBNull.Value to a Date datatype - it isn't a value it can accept.

*Abhishek Pant* · Answer 2 · 2012-11-21T20:57:00

Solution 2

Is this you looking for.. - Assigning null value to datetime object[^]

armarzook wrote:
MyDate = DbNull.value

here DbNull does not represent anything if you are not using ADO.Net..

Posted 21-Nov-12 20:57pm

Abhishek Pant

Updated 21-Nov-12 21:03pm

v2