ASP.NET

ASP.NET RSS

SqlDateTime Overflow Error

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

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

18 Days Ago

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,187

Reputation: sknake has much to be proud of

Solved Threads: 571

sknake

Offline

.NET Enthusiast

17 Days Ago

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));
    }