sql 2005 errordatatype error

Question

SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

Iftikar Hussain · Answer

Hi Please validate the input date range before inserting into sql. Regards Iftikar

MANEESH AN · Answer

DEBITCREDITNARRATIONVOUCHERNUMBER AND ALSO DATE ARE PARAMETERS PASSING THROUGH SQL2005.ITS DISPLAYED ON GRID WHEN I GIVE THESE UNDER WHERECONDITION STRWHERCONDITION IN DATABASE.BUT I REPLCED WHERECONDITION AS DRPDATE DATETIME.I DDINT GET ANY ON GRID.I GOT ERROR AS SQLDATETIME OVERFLOW.CAN U GIVE CODE INCLUDING ABOVE THESE...C#3 TIER PROJECT

Sharad Gupta · Answer

Hi MANEESH What you put the datetime out of this range January 1 1753 through December 31 9999.

sql 2005 error,datatype error