Update的错误在那啊!谁能告诉我!

[diablofriend]

我写了个Update的语句可是总报错,谁能告诉我错在哪里了啊!谢谢!
string tempGoodsName=this.txtGoodsName.Text.Trim();
string tempGoodsNum=this.txtGoodsNum.Text.Trim();
string tempGoodsDes=this.txtGoodDes.Text.Trim();
string tempGoodsPrice=this.txtGoodsPrice.Text.Trim();
string Sql="Update GoodsInfo set GoodsName="+tempGoodsName+",GoodsNum="+tempGoodsNum+",GoodsDes="+tempGoodsDes+",GoodsPrice="+tempGoodsPrice+" where GoodsID="+goodsID;
using(Goods good = new Goods())
{
good.UpdataGoods(Sql);
}

[最后一只恐龙]

字符串两边要加单引号

[diablofriend]

说的在具体些么

[feiyun0112]

字符串要用单引号
string Sql="Update GoodsInfo set GoodsName='"+tempGoodsName+"',GoodsNum='"+tempGoodsNum+"',GoodsDes='"+tempGoodsDes+"',GoodsPrice='"+tempGoodsPrice+"' where GoodsID="+goodsID;

[diablofriend]

字符串要用单引号
string Sql="Update GoodsInfo set GoodsName='"+tempGoodsName+"',GoodsNum='"+tempGoodsNum+"',GoodsDes='"+tempGoodsDes+"',GoodsPrice='"+tempGoodsPrice+"' where GoodsID="+goodsID

我这样写了,点更新就没有反应了!

[diablofriend]

好了,呵呵.我少些了一个IsPostBack,哈哈