执行sql update use c#

今天犯了个大错

 

    public static void ChangeGoodsCounts(int GoodsID, int changCounts)
        {
           
            int lastCount;
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "select GoodsCounts from GoodsInf where GoodsID=" + GoodsID;
                    int counts=Convert.ToInt32(cmd.ExecuteScalar());
                    lastCount = counts + changCounts;
                   
                    cmd.CommandText = "update GoodsInf set GoodsCounts=‘"+lastCount+"‘ where GoodsID=" + GoodsID;
                    cmd.ExecuteNonQuery();

                }

            }
        }

http://www.tup.tsinghua.edu.cn/Resource/tsyz/030095-01.txt

执行sql update use c#,古老的榕树,5-wow.com

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。