你还没给参数赋值呢
如:
string mstr1 = "update wfs_activity_fee set expenseid=@expenseid where id=@id";
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter( PARM_expenseid, SqlDbType.Int, 4 ),
new SqlParameter( PARM_id, SqlDbType.Int, 4 )
};
parms[0].Value = expenseid;
parms[1].Value = id;
SqlHelper.ExecuteNonQuery( SqlHelper.CONN_STRING_NON_DTC, CommandType.Text, mstr1, parms );
如:
string mstr1 = "update wfs_activity_fee set expenseid=@expenseid where id=@id";
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter( PARM_expenseid, SqlDbType.Int, 4 ),
new SqlParameter( PARM_id, SqlDbType.Int, 4 )
};
parms[0].Value = expenseid;
parms[1].Value = id;
SqlHelper.ExecuteNonQuery( SqlHelper.CONN_STRING_NON_DTC, CommandType.Text, mstr1, parms );
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货