sqldatetime overflow exception

you can validate either in your aspx or in sql as shown you earlier.

Regards,
Iftikar

can you provide your sample code

Hi,
The SQL Datetime range is 1/1/1753 12:00:00 AM to 12/31/9999 11:59:59 PM
You can validate datetime before inserting into db as like below

DECLARE @Date VarChar(20)='01/01/1753 12:00:00'

If Not IsDate(@Date) = 1

print 'Invalid date'

ELSE

print 'Valid'

Regards,
Iftikar

I WANT TO DISPLAY FROM DATE AND TO DATE IN TEXTBOX BY USING DATETIME.BUT EXCEPTION OCCURED SQLDATETIME OVERFLOW EXCEPTION

plz provide more details with code so we can able to solve your problem