ASP.NET

SqlDateTime Overflow Error

Please support our ASP.NET advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Feb 2009

Posts: 15

Reputation: Abhishek_Boga is an unknown quantity at this point

Solved Threads: 0

Abhishek_Boga Abhishek_Boga is offline

Offline

Newbie Poster

SqlDateTime Overflow Error

Nov 6th, 2009

Hii...

I'm having 2 .aspx page
1) Detected Vulnerabilities Report
2) Missing Patches Summary Report

When I'm clicking on Detected Vulnerabilities Report it is executing fine and after when Im clicking on Missing Patches Summary Report it is also executing fine. For both of this report Im passing 2 parameters, (startdate and enddate) and between this range the report data will display...

After When I'm restarting my application again and now when Im clicking on Missing Patches Summary Report it is showing an error message as 'SqlDatetime overflow. Must be between 01/01/1753 12:00:00 am and 12/31/9999 11:59:59 pm.

I've created a TableAdapters for Missing Patches Summary report and Im calling this adapter in .cs class of this report...

Need help on this....

Thanx...

•

Join Date: Feb 2009

Posts: 3,464

Reputation: sknake has much to be proud of

Solved Threads: 629

sknake

Offline

.NET Enthusiast

Nov 7th, 2009

You need to post the queries that are causing this error. Also you need to check any DateTime values you send to the SQL Server:

 Help with Code Tags 
 c# Syntax (Toggle Plain Text) 
    public static bool SqlTypeInRange(DateTime value)
    {
      return ((value <= System.Data.SqlTypes.SqlDateTime.MaxValue.Value) && (value >= System.Data.SqlTypes.SqlDateTime.MinValue.Value));
    }
    public static bool SqlTypeInRange(DateTime value)
    {
      return ((value <= System.Data.SqlTypes.SqlDateTime.MaxValue.Value) && (value >= System.Data.SqlTypes.SqlDateTime.MinValue.Value));
    }