Thanks All, @Benj I am using Sql Server 2008. @processor ya i tried using dbnull also but it didn't work.
On Fri, Feb 4, 2011 at 4:26 PM, Benj Nunez <[email protected]> wrote: > May I ask what database are you using? > > Is it Mysql? Sql Server? DB2? MS Access? > > > Regards, > > > Benj > > > > On Feb 4, 1:34 am, Gourav <[email protected]> wrote: > > Hi All, > > I am creating a panel in which User hav to enter His Professional > > Working Experience > > There is Date of Joinning is Mandatory but date of Resignation is > > optional..So here i am facing problem to send NULL value in Database.. > > In database my Datatype is DATETIME > > I already used many type but i didn't get solution.: > > > > i). DateTime dt = new DateTime(); > > dt = null; > > ii) string stringTest = null; > > DateTime dateTimeTest = null; > > iii) SqlDateTime sqldatenull ; > > SqlDateTime sqldatenull ; > > cmd.Parameters ["@Date"].Value =sqldatenull ; > > iv) System.DBNull.Value > > v) > > . > > . > > . > > > > No one is handle to this situation..SO pls tell me how to handle this > > problem.I'll wait for ur reply and Thanks in advanced for your > > fantabulous answers... > -- Warm Regards :- Gourav Vishnoi +91-9871157845 ( M )
