Cannot insert NULL in DB where datatype is DateTime

[rhtbhegade]

Hi Experts, i want to insert NULL in DB where my datatype is DateTime, as its not Compulsary Field... But I could not do so.... m using MS SQL Server 2005 Please Help

Sharing Of Knowledge Provides Solution....

[Sagar H Mistry]

can you please send me your query and table script

[rhtbhegade]

Can u Please tell me how to send script of table.. m a fresher i have seen options in SQL such as script table as-> create drop select insert update delete which 1 to use to give u.

Sharing Of Knowledge Provides Solution....

[Lost User]

Hi All, check ur setting of a column i think in ur setting make Allow null = true; Thanks and regards, Amit Patel

[dan sh]

rhtbhegade wrote:

But I could not do so....

Why? Where exactly are you stuck?

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

[Abhishek Sur]

What about DbNull.Value ?

Abhishek Sur **Don't forget to click "Good Answer" if you like this Solution.

---

My Latest Articles-->** Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

[Ashfield]

The most obvious reason is your data table does not allow nulls in that column. Other than that there is no reason why you can't do it, as long as the rest of your code is correct - unfortunately I can't see your code from here to tell, and you have not even given us the error message that you trapped - you did trap it of course?

Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

[Sathiyaraj Ganesan]

Hi, Have a look at this post here

Sathiya

[Ashfield]

Think you meant to reply to the original post as thats exactly what I said, its perfectly possible to insert nulls to a datetime column if you do it properly :)

Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP