Ad:

ASP.NET Discussion Thread
Unsolved
Views: 1402

Nov 6th, 2009

SqlDateTime Overflow Error

Expand Post »

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...

Similar Threads

Run time stack overflow error help in C++
OnCalcField modifying its own DataSet - Error in Pascal and Delphi
Overflow error in Assembly
floating point : overflow error in C
Stack Overflow Error in C++

Abhishek_Boga

Reputation Points: 9

Solved Threads: 0

Newbie Poster

Offline

20 posts
since Feb 2009

Permalink

Nov 7th, 2009

Re: SqlDateTime Overflow Error

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:

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

sknake

Featured Poster

Reputation Points: 1749

Solved Threads: 735

Senior Poster

Offline

3,948 posts
since Feb 2009

Permalink

Nov 9th, 2009

Re: SqlDateTime Overflow Error

Its working.... Thanxx sknake..

Abhishek_Boga

Reputation Points: 9

Solved Threads: 0

Newbie Poster

Offline

20 posts
since Feb 2009

Permalink

Nov 10th, 2009

Re: SqlDateTime Overflow Error

You're welcome

Please mark this thread as solved if you have found a solution to your issue and good luck!

sknake

Featured Poster

Reputation Points: 1749

Solved Threads: 735

Senior Poster

Offline

3,948 posts
since Feb 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: programmaticly alter the command text of a sqldatasource???anyone?

Next Thread in ASP.NET Forum Timeline: how to enlarge the image

DaniWeb Message

Cancel Changes

User Name
Password