2676n:System.Data.OleDb.OleDbException: INSERT INTO 语句的语法错误。
来源:百度文库 编辑:神马品牌网 时间:2024/07/07 08:29:26
我做管理员登陆也的时候出现这个
System.Data.OleDb.OleDbException: INSERT INTO 语句的语法错误。
在 System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
在 System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
在 System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
在 System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
在 System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
在 DreamweaverCtrls.DataSet.DoInit()
以下是我的页面上面的代码
<%@ Page Language="VB" ContentType="text/html" %>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %>
<MM:Insert
runat="server"
CommandText='<%# "INSERT INTO User (AdminName, AdminPws) VALUES (?, ?)" %>'
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_webdata") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_webdata") %>'
Expression='<%# Request.Form("MM_insert") = "form1" %>'
CreateDataSet="false"
Debug="true"
>
<Parameters>
<Parameter Name="@AdminName" Value='<%# IIf((Request.Form("AdminName") <> Nothing), Request.Form("AdminName"), "") %>' Type="WChar" />
<Parameter Name="@AdminPws" Value='<%# IIf((Request.Form("AdminPws") <> Nothing), Request.Form("AdminPws"), "") %>' Type="WChar" />
</Parameters>
</MM:Insert>
<MM:DataSet
id="User"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_webdata") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_webdata") %>'
CommandText='<%# "SELECT * FROM [User] WHERE AdminName = ?" %>'
Debug="true"
>
<Parameters>
<Parameter Name="@AdminName" Value='<%# IIf((Request.Form("AdminName") <> Nothing), Request.Form("AdminName"), "") %>' Type="WChar" />
<Parameter Name="@AdminPws" Value='<%# IIf((Request.Form("AdminPws") <> Nothing), Request.Form("AdminPws"), "0") %>' Type="WChar" />
</Parameters>
</MM:DataSet>
<MM:PageBind runat="server" PostBackBind="true" />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Label1.visible="false"
if User.recordcount>0 then
session("User")=request.form("AdminName")
response.Redirect("index.aspx")
end if
End Sub
Sub sub_ling(Src As Object, E As EventArgs)
Label1.Visible="True"
End Sub
</script>
System.Data.OleDb.OleDbException: INSERT INTO 语句的语法错误。
在 System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
在 System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
在 System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
在 System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
在 System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
在 DreamweaverCtrls.DataSet.DoInit()
以下是我的页面上面的代码
<%@ Page Language="VB" ContentType="text/html" %>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %>
<MM:Insert
runat="server"
CommandText='<%# "INSERT INTO User (AdminName, AdminPws) VALUES (?, ?)" %>'
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_webdata") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_webdata") %>'
Expression='<%# Request.Form("MM_insert") = "form1" %>'
CreateDataSet="false"
Debug="true"
>
<Parameters>
<Parameter Name="@AdminName" Value='<%# IIf((Request.Form("AdminName") <> Nothing), Request.Form("AdminName"), "") %>' Type="WChar" />
<Parameter Name="@AdminPws" Value='<%# IIf((Request.Form("AdminPws") <> Nothing), Request.Form("AdminPws"), "") %>' Type="WChar" />
</Parameters>
</MM:Insert>
<MM:DataSet
id="User"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_webdata") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_webdata") %>'
CommandText='<%# "SELECT * FROM [User] WHERE AdminName = ?" %>'
Debug="true"
>
<Parameters>
<Parameter Name="@AdminName" Value='<%# IIf((Request.Form("AdminName") <> Nothing), Request.Form("AdminName"), "") %>' Type="WChar" />
<Parameter Name="@AdminPws" Value='<%# IIf((Request.Form("AdminPws") <> Nothing), Request.Form("AdminPws"), "0") %>' Type="WChar" />
</Parameters>
</MM:DataSet>
<MM:PageBind runat="server" PostBackBind="true" />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Label1.visible="false"
if User.recordcount>0 then
session("User")=request.form("AdminName")
response.Redirect("index.aspx")
end if
End Sub
Sub sub_ling(Src As Object, E As EventArgs)
Label1.Visible="True"
End Sub
</script>
大概看了下
似乎问题在这里
CommandText='<%# "INSERT INTO User (AdminName, AdminPws) VALUES (?, ?)" %>'
这里的?用的不对吧
难道不该是@AdminName 和@AdminPws 吗?
因为你的?后面无法识别的
导致参数没有替换
PS:我不是学这个的,所以只是建议
System.Data.OleDb.OleDbException
System.Data.OleDb.OleDbException: INSERT INTO 语句的语法错误。
什么情况下使用System.Data.OleDb接口和System.Data.SqlClient
未处理的“System.Data.OleDb.OleDbException”类型的异常出现在 system.data.dll 中。
编译器错误信息: BC30456: “add”不是“System.Data.OleDb.OleDbParameter”的成员。
System.Data.OleDb.OleDbException: IErrorInfo.GetDescription failed with E_FAIL(0x80004005).
OLE DB 提供程序(System.Data.OleDb)要求 Microsoft 数据访问组件(MDAC)
“System.Data.OleDb.OleDbCommand.recordsAffected”是“Private”,因此它在此上下文中无法访问
我的优盘打开出现 data peng data system data dreamaster data administpsyor 文件夹是怎么回事
conn.open="provider=microsoft.jet.oledb.4.0;data source=e:\linyouguo\linyouguo.mdb"