level 1
18960819151
楼主
错误在哪啊,求帮助
字符串 '1' 后的引号不完整。
'1' 附近有语法错误。说明: 执行当前 Web 请求期间,出现未经处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。
异常详细信息: System.Data.SqlClient.SqlException: 字符串 '1' 后的引号不完整。
'1' 附近有语法错误。
源错误:
行 98: OpenDataBase();行 99: cmd = new SqlCommand(SqlStr, con);行 100: cmd.ExecuteNonQuery();行 101: CloseDataBase();行 102: }
源文件: e:\一般\MY\毕设备份\App_Code\SqlHelper.cs 行: 100
堆栈跟踪:
[SqlException (0x80131904): 字符串 '1' 后的引号不完整。'1' 附近有语法错误。] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +1754082 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5295874 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +242 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1682 System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) +280 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) +405 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +160 SqlHelper.RunSql(String SqlStr) in e:\一般\MY\毕设备份\App_Code\SqlHelper.cs:100 AdminC_ModifyTeachter.Button1_Click(Object sender, EventArgs e) in e:\一般\MY\毕设备份\Teachter\ModifyTeachter.aspx.cs:46 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +9556538 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +103 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
+3
5 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1724
2016年12月23日 04点12分
1
字符串 '1' 后的引号不完整。
'1' 附近有语法错误。说明: 执行当前 Web 请求期间,出现未经处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。
异常详细信息: System.Data.SqlClient.SqlException: 字符串 '1' 后的引号不完整。
'1' 附近有语法错误。
源错误:
行 98: OpenDataBase();行 99: cmd = new SqlCommand(SqlStr, con);行 100: cmd.ExecuteNonQuery();行 101: CloseDataBase();行 102: }
源文件: e:\一般\MY\毕设备份\App_Code\SqlHelper.cs 行: 100
堆栈跟踪:
[SqlException (0x80131904): 字符串 '1' 后的引号不完整。'1' 附近有语法错误。] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +1754082 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5295874 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +242 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1682 System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) +280 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) +405 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +160 SqlHelper.RunSql(String SqlStr) in e:\一般\MY\毕设备份\App_Code\SqlHelper.cs:100 AdminC_ModifyTeachter.Button1_Click(Object sender, EventArgs e) in e:\一般\MY\毕设备份\Teachter\ModifyTeachter.aspx.cs:46 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +9556538 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +103 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
+3
5 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1724