c# - 系统.Data.SqlTypes.SqlTypeException : SqlDateTime overflow

Question

我正在用 c#.net 编写一个与 sql DB 一起工作的应用程序。我有 5 个字段 - 日期时间。当我处于 Debug模式时，我看到 DateTime 字段是正确的，但是当我运行应用程序时，我得到下一个异常 - {System.Data.SqlTypes.SqlTypeException: SqlDateTime 溢出。必须介于 1/1/1753 12:00:00 AM 和 12/31/9999 11:59:59 PM 之间。

代码-

         try
            {
                DateTime date = DateTime.MinValue;
                date = AllEventsSortedList[0].dateTime;
                foreach (Event m485 in _485List)
                {
                    CycleTbl nCycle = new CycleTbl();
                    nCycle._485_DateTime = m485.dateTime;
                    nCycle.OrderNumber = m485.OrderNumber;
                    nCycle.Source = m485.Source;
                    nCycle.Dest = m485.Destination;
                    foreach (Event m412 in _412List)
                    {
                        if ((m485.dateTime.Year == m412.dateTime.Year) && (m485.dateTime.Month == m412.dateTime.Month) && (m485.dateTime.Day == m412.dateTime.Day))
                            nCycle._412_DateTime = (DateTime)m412.dateTime;
                    }
                    foreach (Event m500 in _500List)
                    {
                        if ((m485.dateTime.Year == m500.dateTime.Year) && (m485.dateTime.Month == m500.dateTime.Month) && (m485.dateTime.Day == m500.dateTime.Day))
                            nCycle._500_DateTime = (DateTime)m500.dateTime;
                    }
                    foreach (Event m502 in _502list)
                    {
                        if ((m485.dateTime.Year == m502.dateTime.Year) && (m485.dateTime.Month == m502.dateTime.Month) && (m485.dateTime.Day == m502.dateTime.Day))
                        {
                            nCycle._502_DateTime = m502.dateTime;
                            nCycle.LGVNumber = (int)m502.LGVNumber;
                        }
                    }

                    nCycle._502_DateTime = (DateTime)date;
                    LgvDB.CycleTbls.InsertOnSubmit(nCycle);
                    LgvDB.SubmitChanges();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error in building the table." + Environment.NewLine + ex.Message);
            }

谁能告诉我可能是什么问题？谢谢。

Answer 1

.NET DateTime range :

The DateTime value type represents dates and times with values ranging from 12:00:00 midnight, January 1, 0001 Anno Domini (Common Era) through 11:59:59 P.M., December 31, 9999 A.D. (C.E.).

SQL Server datetime range :

January 1, 1753, through December 31, 9999

SQL Server 2008 引入了 datetime2符合 .NET DateTime 的更大范围的数据类型。