关于微软sqlhelper使用的问题

fangqm 2011-03-05 11:12:47

这代码用来更新一个记录，用的是微软的SQLHELPER,可是发现传的参数大于5个后就没有更新成功过，为什么参数个数只能在5个以内，用泛型的paramlist.ToArray()方法，也是一样的结果，怎么回事，高手赐教
public bool UpdateUser(SqlConnection conn, Model.MD_user user)
{
try
{
string sp = "[fangqm].[Netbank_UpdateUser]";
//List<SqlParameter> paramlist = new List<SqlParameter>();
//paramlist.Add(new SqlParameter("@usercode", user.userCode));
//paramlist.Add(new SqlParameter("@userName", user.userName));
//paramlist.Add(new SqlParameter("@password", user.Password));
//paramlist.Add(new SqlParameter("@description", user.description));
//paramlist.Add(new SqlParameter("@actived", user.Actived));
//paramlist.Add(new SqlParameter("@workgroupID", user.workgroupID));
//paramlist.Add(new SqlParameter("@id", user.ID));
SqlParameter[] paramlist = { new SqlParameter("@usercode", user.userCode),
new SqlParameter("@userName", user.userName),
new SqlParameter("@password", user.Password),
new SqlParameter("@description", user.description),
new SqlParameter("@actived", user.Actived),
new SqlParameter("@workgroupID", user.workgroupID),
new SqlParameter("@id", user.ID)
};

SqlHelper.ExecuteNonQuery(conn, sp, paramlist);
return true;
}
catch (Exception)
{

return false;
}
}

...全文