一个表单就是链接数据库又加上了插入数据的服务器行为然后错误了调试信息是显示这样的
System.Data.SqlClient.SqlException: 关键字 'order' 附近有语法错误。
在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
在 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
在 DreamweaverCtrls.DataSet.DoInit()
插入记录的代码是这个
<MM:Insert
runat="server"
CommandText='<%# "INSERT INTO dbo.order (name, tel, ""add"", mail) VALUES (@name, @tel, @add, @mail)" %>'
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_sql") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_sql") %>'
Expression='<%# Request.Form("MM_insert") = "form1" %>'
CreateDataSet="false"
SuccessURL='<%# "chenggong.html" %>'
FailureURL='<%# "shibai.html" %>'
Debug="true"
><Parameters>
<Parameter Name="@name" Value='<%# IIf((Request.Form("name") <> Nothing), Request.Form("name"), "") %>' Type="NVarChar" />
<Parameter Name="@tel" Value='<%# IIf((Request.Form("tel") <> Nothing), Request.Form("tel"), "") %>' Type="Char" />
<Parameter Name="@add" Value='<%# IIf((Request.Form("add") <> Nothing), Request.Form("add"), "") %>' Type="NVarChar" />
<Parameter Name="@mail" Value='<%# IIf((Request.Form("mail") <> Nothing), Request.Form("mail"), "") %>' Type="NVarChar" />
</Parameters>
</MM:Insert>
System.Data.SqlClient.SqlException: 关键字 'order' 附近有语法错误。
在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
在 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
在 DreamweaverCtrls.DataSet.DoInit()
插入记录的代码是这个
<MM:Insert
runat="server"
CommandText='<%# "INSERT INTO dbo.order (name, tel, ""add"", mail) VALUES (@name, @tel, @add, @mail)" %>'
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_sql") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_sql") %>'
Expression='<%# Request.Form("MM_insert") = "form1" %>'
CreateDataSet="false"
SuccessURL='<%# "chenggong.html" %>'
FailureURL='<%# "shibai.html" %>'
Debug="true"
><Parameters>
<Parameter Name="@name" Value='<%# IIf((Request.Form("name") <> Nothing), Request.Form("name"), "") %>' Type="NVarChar" />
<Parameter Name="@tel" Value='<%# IIf((Request.Form("tel") <> Nothing), Request.Form("tel"), "") %>' Type="Char" />
<Parameter Name="@add" Value='<%# IIf((Request.Form("add") <> Nothing), Request.Form("add"), "") %>' Type="NVarChar" />
<Parameter Name="@mail" Value='<%# IIf((Request.Form("mail") <> Nothing), Request.Form("mail"), "") %>' Type="NVarChar" />
</Parameters>
</MM:Insert>
