Can you share your Query / SP? On Fri, Feb 4, 2011 at 4:17 PM, Gourav vishnoi <[email protected]>wrote:
> 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 ) >
