【已解决】Asp.net更新SQL Server 2005 NText报错！！

来源：互联网发布：linux系统监控软件编辑：程序博客网时间：2024/05/22 10:58

源代码：

/// <summary> /// 添加流程分类 /// </summary> /// <param name="fft"></param> /// <returns></returns> public int Add(Flow_Type ft) { string sql = "INSERT INTO [Flow_Type]([FlowSort],[FlowNo],[FlowName],[FormId],[FlowDoc],[FlowType],[ManageUser],[QueryUser],[AutoName],[AutoNum],[AutoLen],[AutoEdit],[QueryItem],[FlowDesc]) " + "VALUES (@FlowSort,@FlowNo,@FlowName,@FormId,@FlowDoc,@FlowType,@ManageUser,@QueryUser,@AutoName,@AutoNum,@AutoLen,@AutoEdit,@QueryItem,@FlowDesc)"; SqlParameter[] par = new SqlParameter[] { new SqlParameter("@FlowSort",SqlDbType.Int),//0 new SqlParameter("@FlowNo",SqlDbType.Int),//1 new SqlParameter("@FlowName",SqlDbType.NVarChar,200),//2 new SqlParameter("@FormId",SqlDbType.Int),//3 new SqlParameter("@FlowDoc",SqlDbType.Bit),//4 new SqlParameter("@FlowType",SqlDbType.Int),//5 new SqlParameter("@ManageUser",SqlDbType.NText),//6 new SqlParameter("@QueryUser",SqlDbType.NText),//7 new SqlParameter("@AutoName",SqlDbType.NText),//8 new SqlParameter("@AutoNum",SqlDbType.Int),//9 new SqlParameter("@AutoLen",SqlDbType.Int),//10 new SqlParameter("@AutoEdit",SqlDbType.Int),//11 new SqlParameter("@QueryItem",SqlDbType.NText),//12 new SqlParameter("@FlowDesc",SqlDbType.NText)//13 }; par[0].Value = ft.FlowSort; par[1].Value = ft.FlowNo; par[2].Value = ft.FlowName; par[3].Value = ft.FormId; par[4].Value = ft.FlowDoc; par[5].Value = ft.FlowType; par[6].Value = ft.ManageUser; par[7].Value = ft.QueryUser; par[8].Value = ft.AutoName; par[9].Value = ft.AutoNum; par[10].Value = ft.AutoLen; par[11].Value = ft.AutoEdit; par[12].Value = ft.QueryItem; par[13].Value = ft.FlowDesc; return SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql, par); }

当执行到

int val = cmd.ExecuteNonQuery();

总是抛出错误

“参数化查询 '(@FlowSort int,@FlowNo int,@FlowName nvarchar(200),@FormId int,@' 需要参数 @ManageUser，但未提供该参数。”

解决办法：把上面的SqlParameter赋值写成下面这样，问题解决

par[0].Value = ft.FlowSort; par[1].Value = ft.FlowNo; par[2].Value = ft.FlowName; par[3].Value = ft.FormId; par[4].Value = ft.FlowDoc; par[5].Value = ft.FlowType; par[6].Value = "'" + ft.ManageUser + "'"; par[7].Value = "'" + ft.QueryUser + "'"; par[8].Value = "'" + ft.AutoName + "'"; par[9].Value = ft.AutoNum; par[10].Value = ft.AutoLen; par[11].Value = ft.AutoEdit; par[12].Value = "'" + ft.QueryItem + "'"; par[13].Value = "'" + ft.FlowDesc + "'";

感谢：编程中国（www.bcc.net）C#论坛的版主【天使不哭】http://bbs.bccn.net/thread-36050-1-1.html