Must declare the scalar variable
標簽：
JavaScript
Server Error in '/Website1' Application.
Must declare the scalar variable "@Author".
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Must declare the scalar variable "@Author".
Source Error:
Line 29: private void Data_Binding()Line 30: {Line 31: this.GvCycleCountFile.DataSource = objCycleCountFile.GetCycleCountFileByAuthor(InsusBase.SystemId); Line 32: this.GvCycleCountFile.DataBind();Line 33: } |
Source File: d:\IntranetSites\ERP\System\SyteLine\PhysicalTag\CycleCountSheet.aspx.cs Line: 31
Stack Trace:
[SqlException (0x80131904): Must declare the scalar variable "@Author".] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2030802 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5009584 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275 System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33 System.Data.SqlClient.SqlDataReader.get_MetaData() +86 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +311 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +10 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +144 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +319 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +94 Insus.NET.Base.ExecuteProcedure(String procedureName, DataSet& dataSet, SqlParameter[] prams) +189[Exception: Must declare the scalar variable "@Author".] Insus.NET.Base.ExecuteProcedure(String procedureName, DataSet& dataSet, SqlParameter[] prams) +253 Insus.NET.BusinessBase.GetDataToDataSet(String procedureName, Parameter[] sqlParameter) +326 Insus.NET.CycleCountFile.GetCycleCountFileByAuthor(String author) +88 System_SyteLine_PhysicalTag_CycleCountSheet.Data_Binding() in d:\IntranetSites\ERP\System\SyteLine\PhysicalTag\CycleCountSheet.aspx.cs:31 System_SyteLine_PhysicalTag_CycleCountSheet.Page_Load(Object sender, EventArgs e) in d:\IntranetSites\ERP\System\SyteLine\PhysicalTag\CycleCountSheet.aspx.cs:23 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35 System.Web.UI.Control.OnLoad(EventArgs e) +91 System.Web.UI.Control.LoadRecursive() +74 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207 |
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
软件在开发端没有问题，发布到服务端没有问题，但交给客户有问题，出现如上错误。最终检查得出结果，开发与测试时都是使用管理员的权限去做测试，当然通过一切障碍。
可以看到下面这个存储过程，当用管理员去run时，它只跑IF节，从没有机会跑过ELSE部分的代码，现交给到客户了，用户使用其他权限去跑，问题出来了：
动态变量@Author无法被组合成的sql所识别。Insus.NET把它修改一下：
EXECUTE(@sql + ' WHERE [Author] = ' + @Author +' ORDER BY [CreateDate] DESC')
得出结论，软件开发，是用户使用之后，才会发现问题。
點擊查看更多內容
為 TA 點贊
評論
評論
共同學習，寫下你的評論
評論加載中...
作者其他優質文章
正在加載中
感謝您的支持，我會繼續努力的～
掃碼打賞，你說多少就多少
贊賞金額會直接到老師賬戶
支付方式
打開微信掃一掃，即可進行掃碼打賞哦