一个基于VB的 数据库方面的...弱...问题 各路大虾帮忙!!!!
源文件:
dim rd as oledbdatareader
dim lrd
dim conn as oledbconnection=nothing
dim connflag as boolean=false
dim connstr,sql as string
connstr= "provider=microsoft.jet.oledb.4.0;data source="&server.mappath("day.mdb")
conn= new oledbconnection(connstr)
conn.open()
'connflag=grantreadaccesstosysobjects()
sql= "select * from daya where datea=#"&cdate(request.querystring("date1"))&"#"
dim cmd as oledbcommand= new oledbcommand(sql,conn)
'cmd
'cmd.activeconnection.open()
lrd=cmd.executereader()
rd=lrd
'cmd.execute(rd)
错误信息:
“/MyWebDiary”应用程序中的服务器错误。
--------------------------------------------------------------------------------
从字符串“”到类型“Date”的强制转换无效。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。
异常详细信息: System.InvalidCastException: 从字符串“”到类型“Date”的强制转换无效。
源错误:
行 34: conn.open()
行 35: 'connflag=grantreadaccesstosysobjects()
行 36: sql= "select * from daya where datea=#"&cdate(request.querystring("date1"))&"#"
行 37: dim cmd as oledbcommand= new oledbcommand(sql,conn)
行 38: 'cmd
源文件: c:\inetpub\wwwroot\MyWebDiary\read.aspx 行: 36
堆栈跟踪:
[InvalidCastException: 从字符串“”到类型“Date”的强制转换无效。]
Microsoft.VisualBasic.CompilerServices.DateType.FromString(String Value, CultureInfo culture)
Microsoft.VisualBasic.CompilerServices.DateType.FromString(String Value)
ASP.read_aspx.__RenderForm1(HtmlTextWriter __output, Control parameterContainer) in c:\inetpub\wwwroot\MyWebDiary\read.aspx:36
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer)
System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer)
System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output)
System.Web.UI.Control.RenderControl(HtmlTextWriter writer)
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer)
System.Web.UI.Control.Render(HtmlTextWriter writer)
System.Web.UI.Control.RenderControl(HtmlTextWriter writer)
System.Web.UI.Page.ProcessRequestMain()
--------------------------------------------------------------------------------
版本信息: Microsoft .NET Framework 版本:1.1.4322.573; ASP.NET 版本:1.1.4322.573