关于--此SqlParameterCollection 中未包含带有 ParameterName“XXXX”的 SqlParameter。
的问题的帖子我已经看了,而且添加了add,但是依然还是出现一样的问题,请各位大虾帮忙解决
错误信息:此 SqlParameterCollection 中未包含带有 ParameterName“@SortOrder”的 SqlParameter。
[IndexOutOfRangeException: 此 SqlParameterCollection 中未包含带有 ParameterName“@SortOrder”的 SqlParameter。]
System.Data.SqlClient.SqlParameterCollection.RangeCheck(String parameterName) +48
System.Data.SqlClient.SqlParameterCollection.get_Item(String parameterName) +10
xmlchina.DataAccess.ForumColumns.GetInsertCommand() in D:\xmlchina\XMLChina\xmlchina\DataAccess\ForumColumns.cs:163
xmlchina.DataAccess.ForumColumns.InsertForumColumn(ForumColumnData forumColumn) in D:\xmlchina\XMLChina\xmlchina\DataAccess\ForumColumns.cs:350
xmlchina.BusinessRules.ForumColumn.Insert(ForumColumnData forumColumn) in D:\xmlchina\XMLChina\xmlchina\BusinessRules\ForumColumn.cs:48
xmlchina.BusinessFacade.ForumColumnSystem.CreatForumColumn(String name, String description, Int32 groupID, ForumColumnData& forumColumnData) in D:\xmlchina\XMLChina\xmlchina\BusinessFacade\ForumColumnSystem.cs:61
xmlchina.Web.modules.forumlistmodule.AddForumColumnButton_Click(Object sender, EventArgs e) in D:\xmlchina\XMLChina\xmlchina\Web\modules\forumlistmodule.ascx.cs:109
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292
相应的文件的代码SqlParameterCollection sqlParams = insertCommand.Parameters;
sqlParams.Add(new SqlParameter(PKID_PARM, SqlDbType.Int));
sqlParams.Add(new SqlParameter(NAME_PARM, SqlDbType.NVarChar,50));
sqlParams.Add(new SqlParameter(DESCRIPTION_PARM, SqlDbType.NVarChar,500));
sqlParams.Add(new SqlParameter(GROUPID_PARM,SqlDbType.Int));
sqlParams.Add(new SqlParameter(SORTORDER_PARM,SqlDbType.Int));--此句为我自己添加,添加后依然报错sqlParams[PKID_PARM].SourceColumn = ForumColumnData.PKID_FIELD;
sqlParams[PKID_PARM].Direction = ParameterDirection.Output;
sqlParams[NAME_PARM].SourceColumn = ForumColumnData.NAME_FIELD;
sqlParams[DESCRIPTION_PARM].SourceColumn = ForumColumnData.DESCRIPTION_FIELD;
sqlParams[GROUPID_PARM].SourceColumn = ForumColumnData.GROUPID_FIELD;
sqlParams[SORTORDER_PARM].SourceColumn = ForumColumnData.SORTORDER_FIELD;之前有个定义为:private const String SORTORDER_PARM = "@SortOrder";
参考了一些网上的办法,但是还是同样的问题,小弟水平实在不行,所以请各位大虾帮忙解决这个问题
的问题的帖子我已经看了,而且添加了add,但是依然还是出现一样的问题,请各位大虾帮忙解决
错误信息:此 SqlParameterCollection 中未包含带有 ParameterName“@SortOrder”的 SqlParameter。
[IndexOutOfRangeException: 此 SqlParameterCollection 中未包含带有 ParameterName“@SortOrder”的 SqlParameter。]
System.Data.SqlClient.SqlParameterCollection.RangeCheck(String parameterName) +48
System.Data.SqlClient.SqlParameterCollection.get_Item(String parameterName) +10
xmlchina.DataAccess.ForumColumns.GetInsertCommand() in D:\xmlchina\XMLChina\xmlchina\DataAccess\ForumColumns.cs:163
xmlchina.DataAccess.ForumColumns.InsertForumColumn(ForumColumnData forumColumn) in D:\xmlchina\XMLChina\xmlchina\DataAccess\ForumColumns.cs:350
xmlchina.BusinessRules.ForumColumn.Insert(ForumColumnData forumColumn) in D:\xmlchina\XMLChina\xmlchina\BusinessRules\ForumColumn.cs:48
xmlchina.BusinessFacade.ForumColumnSystem.CreatForumColumn(String name, String description, Int32 groupID, ForumColumnData& forumColumnData) in D:\xmlchina\XMLChina\xmlchina\BusinessFacade\ForumColumnSystem.cs:61
xmlchina.Web.modules.forumlistmodule.AddForumColumnButton_Click(Object sender, EventArgs e) in D:\xmlchina\XMLChina\xmlchina\Web\modules\forumlistmodule.ascx.cs:109
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292
相应的文件的代码SqlParameterCollection sqlParams = insertCommand.Parameters;
sqlParams.Add(new SqlParameter(PKID_PARM, SqlDbType.Int));
sqlParams.Add(new SqlParameter(NAME_PARM, SqlDbType.NVarChar,50));
sqlParams.Add(new SqlParameter(DESCRIPTION_PARM, SqlDbType.NVarChar,500));
sqlParams.Add(new SqlParameter(GROUPID_PARM,SqlDbType.Int));
sqlParams.Add(new SqlParameter(SORTORDER_PARM,SqlDbType.Int));--此句为我自己添加,添加后依然报错sqlParams[PKID_PARM].SourceColumn = ForumColumnData.PKID_FIELD;
sqlParams[PKID_PARM].Direction = ParameterDirection.Output;
sqlParams[NAME_PARM].SourceColumn = ForumColumnData.NAME_FIELD;
sqlParams[DESCRIPTION_PARM].SourceColumn = ForumColumnData.DESCRIPTION_FIELD;
sqlParams[GROUPID_PARM].SourceColumn = ForumColumnData.GROUPID_FIELD;
sqlParams[SORTORDER_PARM].SourceColumn = ForumColumnData.SORTORDER_FIELD;之前有个定义为:private const String SORTORDER_PARM = "@SortOrder";
参考了一些网上的办法,但是还是同样的问题,小弟水平实在不行,所以请各位大虾帮忙解决这个问题
解决方案 »
- 登录无论如何都登录不上,请大家帮忙分析原因
- 关于sharepoint去除左边导航栏后,添加通知报错
- 问一个dropdownlist的问题?
- 用户注册加密问题?
- 求救!!!“ssss/r/nsssss(char(13)+char(10))ss<br>sssss/rsss“这么样让它换行写入文件啊?
- 有没有好的asp.net电子书推荐一下
- 转换函数的问题
- 邮件发送的问题(附原码),急,在线等?
- 关于Forms验证的问题???????
- 请问大家,用什么.net 的CMS系统啊?
- 在C#中用下拉框和时间控件的关联要怎么做,谢谢各位大哥!
- 发表文章系统 发表成功 蹦出来个对话匡 告诉发表成功 然后转到首页
有的话,建议你重启一下SQLServer以及ASPNET_WP.EXE进程实在不行,你试试sqlParams[4].SourceColumn = ForumColumnData.SORTORDER_FIELD;
sqlParams[4].SourceColumn = ForumColumnData.SORTORDER_FIELD;
看看是不是还是不行先