9999 11:59:59 PM.

Prasunje...

SOLVED CLOSED ACTIVE ANSWERED
User: Prasunjeet
Posted: on Sep 29, 2015 05:07 AM
Forum: ASP.Net Web Forms
Answer: 1
Views: 24535

I have a table having some fields

and there is one field Date

i am using LINQ when i tried to insert rows in database it shows following error

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

and insertion code is

Notification noti = new Notification(); noti.Date = Convert.ToDateTime(txtdate.Text.Trim()).ToString("yyyy/MM/dd");

db.SubmitChanges();

earlier it works well but suddenly i got mentioned error.

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 9

Reply
ANSWER
User: dharmendr
Replied: on Oct 01, 2015 02:39 AM
Report

Hi ,

Change your code like below and check.

DateTime date = Convert.ToDateTime(txtDate.Text.Trim()).ToString("yyyy/MM/dd");
if (date == DateTime.MinValue)
{
    yourparameter.Value = System.DBNull.Value;
}
else
{
    yourparameter.Value = date;
}

Refer the below link.

http://stackoverflow.com/questions/468045/error-sqldatetime-overflow-must-be-between-1-1-1753-120000-am-and-12-31-999

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

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

Company

Explore

Follow us

Contact Us