[笔记]读取含日期格式的记录SQLite报错"该字符串未被识别为有效的 DateTime"的问题...

旧城等待， 2021-12-13 17:49 172阅读 0赞

发现Firefox的SQLite Manager插件的时间问题,手工添加的数据,程序读取的时候报无效的DateTime格式,如果用程序添加,则没有此问题.

SQLite Manager 版本0.3.17

System.Data.SQLite.dll版本:1.0.60.0

#### *该字符串未被识别为有效的 DateTime。* ####

**说明:** 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。  
**异常详细信息:** System.FormatException: 该字符串未被识别为有效的 DateTime。  
**源错误:**

行 24:             info.Nickname = reader["nickname"].ToString();
    行 25:             info.Realname = reader["realname"].ToString();
    
    行 27:             info.Regip = reader["regip"].ToString();
    行 28:             info.Regdate = Convert.ToDateTime(reader["regdate"]).ToString("yyyy-MM-dd");

`堆栈跟踪:`

[FormatException: 该字符串未被识别为有效的 DateTime。] System.DateTimeParse.ParseExactMultiple(String s, String[] formats, DateTimeFormatInfo dtfi, DateTimeStyles style) +2827362 System.DateTime.ParseExact(String s, String[] formats, IFormatProvider provider, DateTimeStyles style) +49 System.Data.SQLite.SQLiteConvert.ToDateTime(String dateText) +260 System.Data.SQLite.SQLiteConvert.ToDateTime(IntPtr ptr, Int32 len) +65 System.Data.SQLite.SQLite3.GetDateTime(SQLiteStatement stmt, Int32 index) +88 System.Data.SQLite.SQLite3.GetValue(SQLiteStatement stmt, Int32 index, SQLiteType typ) +528 System.Data.SQLite.SQLiteDataReader.GetValue(Int32 i) +178 System.Data.SQLite.SQLiteDataReader.get_Item(String name) +62 iTCA.Yuwen.Core.Users.DataReader2UserInfo(IDataReader reader) in F:\Doctments\Works\Mine\iTCAWeb\trunk\iTCA.Yuwen.Core\Users.cs:26 iTCA.Yuwen.Core.Users.GetUserInfo(String loginid, String password, Int32 logintpye) in F:\Doctments\Works\Mine\iTCAWeb\trunk\iTCA.Yuwen.Core\Users.cs:50 iTCA.Yuwen.Web.login.Page_Show() in F:\Doctments\Works\Mine\iTCAWeb\trunk\iTCA.Yuwen.Web\login.aspx.cs:17 iTCA.Yuwen.Web.BasePage..ctor() in F:\Doctments\Works\Mine\iTCAWeb\trunk\iTCA.Yuwen.Web\BasePage.cs:45 iTCA.Yuwen.Web.login..ctor() +43 ASP.login_aspx..ctor() in c:\Windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\955e2214\b4bcb2de\App_Web_vg4npwke.2.cs:0 __ASP.FastObjectFactory_app_web_vg4npwke.Create_ASP_login_aspx() in c:\Windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\955e2214\b4bcb2de\App_Web_vg4npwke.5.cs:0 System.Web.Compilation.BuildResultCompiledType.CreateInstance() +32 System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp, Boolean noAssert) +119 System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) +33 System.Web.UI.PageHandlerFactory.System.Web.IHttpHandlerFactory2.GetHandler(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) +40 System.Web.HttpApplication.MapHttpHandler(HttpContext context, String requestType, VirtualPath path, String pathTranslated, Boolean useAppConfig) +160 System.Web.MapHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +93 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +155

转载于:https://www.cnblogs.com/wysky/archive/2008/12/08/1350397.html