Hi, If you want to set a datetime field to null in sql server through C#, here's how:
http://www.c-sharpcorner.com/UploadFile/sd_patel/EnterNullValuesForDateTime11222005015742AM/EnterNullValuesForDateTime.aspx If you want to code it in sql, try the code posted by timmy here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=15417 You can also check this one out: http://blogs.msdn.com/b/jaskis/archive/2008/07/09/insert-null-value-into-datetime-column-in-sql-server-from-aspx-application.aspx Cheers! Benj On Aug 16, 8:35 pm, Gourav <[email protected]> wrote: > Hi All, > > Actually i have two field which are datetime format.In these one is > compalsury and another is optional...but in sql datetime cann't be > null...i had search on internet but i didn't get solutions how to > nullable a datetime field in > sql 208 & 2005 .... > if anybody know this solutions then pls help me.I'll wait for reply... > > Thanks > > -- > Warm Regards:- > Gourav Vishnoi > +91-9871157845 (M) > “Smile: A curve that can set a lot of things straight."
