| 发表于：2007-01-31 13:38:23 楼主 |
问题描述：
c#调用更新数据库记录的存储过程，但数据库记录却不更新
cs更新代码如下：
string scurrencyname = textbox1.text.tostring（).trim（).replace（ " ' ", " ").replace（ "= ", " ");
........
........
sqlconnection mysqlconnection = new sqlconnection（system.configuration.configurationmanager.appsettings[ "connectionsqlserver "]);
sqlcommand mysqlcommand = new sqlcommand（ "yp_adminproduct_update ", mysqlconnection);
mysqlcommand.commandtype = commandtype.storedprocedure;
mysqlcommand.parameters.addwithvalue（ "@productid ", productid);
mysqlcommand.parameters.addwithvalue（ "@probigsortid ", iprobigsortid);
mysqlcommand.parameters.addwithvalue（ "@prosmallsortid ", iprosmallsortid);
mysqlcommand.parameters.addwithvalue（ "@provinceid ", iprovinceid);
mysqlcommand.parameters.addwithvalue（ "@drugstoreid ", idrugstoreid);
mysqlcommand.parameters.addwithvalue（ "@currencyname ", scurrencyname);
mysqlcommand.parameters.addwithvalue（ "@preparation ", spreparation);
mysqlcommand.parameters.addwithvalue（ "@businessman ", sbusinessman);
mysqlcommand.parameters.addwithvalue（ "@proimage ", sproimage);
mysqlcommand.parameters.addwithvalue（ "@proinfo ", sproinfo);
mysqlcommand.parameters.addwithvalue（ "@medicare ", imedicare);
mysqlcommand.parameters.addwithvalue（ "@usecardplace ", susecardplace);
mysqlcommand.parameters.addwithvalue（ "@warnumber ", swarnumber);
mysqlcommand.parameters.addwithvalue（ "@vieprice ", ivieprice);
try
{
mysqlconnection.open（);
mysqlcommand.ＥＸＥＣutenonquery（);
mysqlconnection.close（);
response.write（@ " <script language=javascript> {window.alert（ '商品修改成功，本次操作有效！ ');javascript:location.href= 'admin_productadd.aspx ';} </script> ");
}
catch （exception ex)
{
response.write（ "数据库错误，错误原因： " + ex.message);
response.end（);
}
finally
{
mysqlconnection.close（);
}
存储过程如下：
create procedure yp_adminproduct_update
（@productid varchar（1000),
@probigsortid varchar（1000),
@prosmallsortid varchar（1000),
@provinceid varchar（1000),
@drugstoreid varchar（1000),
@currencyname varchar（1000),
@preparation varchar（1000),
@businessman varchar（1000),
@proimage varchar（1000),
@proinfo text,
@medicare varchar（1000),
@usecardplace varchar（1000),
@warnumber varchar（1000),
@vieprice varchar（1000))
as
set nocount on
update yp_products
set
iprobigsortid=@probigsortid,
iprosmallsortid=@prosmallsortid,
iprovinceid=@provinceid,
idrugstoreid=@drugstoreid,
scurrencyname=@currencyname,
spreparation=@preparation,
sbusinessman=@businessman,
sproimage=@proimage,
sproinfo=@proinfo,
imedicare=@medicare,
susecardplace=@usecardplace,
swarnumber=@warnumber,
ivieprice=@vieprice
where
iproducts_id = @productid
set nocount off
|
|
|
|
|
