在后台新建SQL标签,只要一点下一步,就报错,:
“/”应用程序中的服务器错误。
索引和长度必须引用该字符串内的位置。
参数名: length 说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。
异常详细信息: System.ArgumentOutOfRangeException: 索引和长度必须引用该字符串内的位置。
参数名: length
源错误:
执行当前 Web 请求期间生成了未处理的异常。可以使用下面的异常堆栈跟踪信息确定有关异常原因和发生位置的信息。 |
堆栈跟踪:
[ArgumentOutOfRangeException: 索引和长度必须引用该字符串内的位置。参数名: length] System.String.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy) +7497419 System.String.Substring(Int32 startIndex, Int32 length) +11 Kesion.NET.WebSite.Admin_Label_SQL.Foot1_Submit(Object sender, EventArgs e) +3403 Kesion.Controls.Foot.OnSubmit(EventArgs e) +151 Kesion.Controls.Foot.q1b0pcixH(Object , EventArgs ) +46 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110 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) +36 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565 |
我之前新建过这样一个标签,运行了几次后出的这个问题,之前前一直好好的,用了很久没问题:
SELECT TOP (100) PERCENT dbo.KS_FormRecord47.item0 AS Expr4, dbo.KS_FormRecord47.item1 AS Expr5, dbo.KS_FormRecord43.RecordID, dbo.KS_FormRecord43.AddDate,
dbo.KS_FormRecord43.item6, dbo.KS_FormRecord43.item0, dbo.KS_FormRecord43.item9, dbo.KS_FormRecord43.item5, dbo.KS_FormRecord43.item7, dbo.KS_FormRecord43.item11,
dbo.KS_FormRecord44.item0 AS Expr1, dbo.KS_FormRecord44.item1, dbo.KS_FormRecord44.item4, dbo.KS_FormRecord44.item6 AS Expr2, dbo.KS_FormRecord44.item7 AS Expr3,
dbo.KS_FormRecord44.item3, dbo.KS_FormRecord45.item0 AS Expr6, dbo.KS_FormRecord45.item1 AS Expr7, dbo.KS_FormRecord46.item0 AS Expr8
FROM dbo.KS_FormRecord43 INNER JOIN
dbo.KS_FormRecord44 ON dbo.KS_FormRecord43.RecordID = dbo.KS_FormRecord44.CopyNO INNER JOIN
dbo.KS_FormRecord47 ON dbo.KS_FormRecord43.RecordID = dbo.KS_FormRecord47.CopyNO INNER JOIN
dbo.KS_FormRecord45 ON dbo.KS_FormRecord43.RecordID = dbo.KS_FormRecord45.CopyNO INNER JOIN
dbo.KS_FormRecord46 ON dbo.KS_FormRecord43.RecordID = dbo.KS_FormRecord46.CopyNO
ORDER BY dbo.KS_FormRecord43.AddDate DESC
现在前台的之前这个标签的页面也有错了: “/”应用程序中的服务器错误。
值不能为空。
参数名: commandText 说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。
异常详细信息: System.ArgumentNullException: 值不能为空。
参数名: commandText
源错误:
执行当前 Web 请求期间生成了未处理的异常。可以使用下面的异常堆栈跟踪信息确定有关异常原因和发生位置的信息。 |
堆栈跟踪:
[ArgumentNullException: 值不能为空。参数名: commandText] Kesion.DataBase.DBHelper.t8Uj17BMP(DbCommand , DbConnection , DbTransaction , CommandType , String , DbParameter[] , Boolean& ) +233 Kesion.DataBase.DBHelper.ExecuteDataset(DbConnection connection, CommandType commandType, String commandText, DbParameter[] commandParameters) +82 Kesion.DataBase.DBHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, DbParameter[] commandParameters) +89 Kesion.DataBase.DBHelper.ExecuteDataset(CommandType commandType, String commandText) +26 Kesion.SqlDAL.DataFactory.GetDataTable(String sqlstr) +58 Kesion.BLL.DataFactory.GetDataTable(String sqlstr) +46 Kesion.BLL.LabelSource.ReturnDataTable(Int32 dbtype, String connstr, String sqlstr) +1367 Kesion.HtmlTags.HighLabel.ISQL.Run(String Param) +1333 Kesion.HtmlTags.ReplaceSQLLabels.GetSQLContent(String SqlLabel) +2905 Kesion.HtmlTags.ReplaceSQLLabels.ReplaceSQLLabel(String& FileStr) +221 Kesion.HtmlTags.ReplaceLabels.ReplaceFunAndSQLLabel(String& FileStr) +393 Kesion.HtmlTags.ReplaceLabels.ReplaceAllLabel(String& FileStr) +41 Kesion.HtmlTags.ReplaceIndex.CQWGjdKTbH() +207 Kesion.HtmlTags.ReplaceIndex.GetHomePage() +330 Kesion.NET.WebSite.Index.Page_Load(Object sender, EventArgs e) +3854 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) +99 System.Web.UI.Control.LoadRecursive() +50 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627 |