C#循环中使用事务

        public void UpdateTake(DataAccess.EntityData ds)
        {
            SqlConnection sqlconn = new SqlConnection(Common.sqlstring);
            sqlconn.Open();
            SqlTransaction sqltrana = sqlconn.BeginTransaction();
            try
            {
                foreach (DataRow row in ds.Tables["stock_take_a"].Rows)
                {
                    row["actualmoney"] = Convert.ToDecimal(row["unitprice"]) * Convert.ToInt64(row["actualamount"]);
                    row["lossamount"] = Convert.ToInt64(row["actualamount"]) - Convert.ToInt64(row["nowamount"]);
                    row["lossmoney"] = Convert.ToDecimal(row["unitprice"]) * Convert.ToInt64(row["lossamount"]);
                    string Up = "update tb_stock_take set actualamount=@actualamount,actualmoney=@actualmoney,lossamount=@lossamount,lossmoney=@lossmoney,adjustmark=@adjustmark where Stockid=@Stockid and drugid=@drugid";
                    SqlCommand sqlcom = new SqlCommand(Up,sqlconn);
                    sqlcom.Parameters.AddWithValue("@actualamount", row["actualamount"]);
                    sqlcom.Parameters.AddWithValue("@actualmoney", row["actualmoney"]);
                    sqlcom.Parameters.AddWithValue("@lossamount", row["lossamount"]);
                    sqlcom.Parameters.AddWithValue("@lossmoney", row["lossmoney"]);
                    sqlcom.Parameters.AddWithValue("@Stockid", row["Stockid"]);
                    sqlcom.Parameters.AddWithValue("@drugid", row["drugid"]);
                    sqlcom.Parameters.AddWithValue("@adjustmark",1);
                    sqlcom.Transaction = sqltrana;
                    sqlcom.ExecuteNonQuery();
                }
                sqlconn.Close();
                sqlconn.Dispose();
                sqltrana.Commit();
            }
            catch(Exception ex)
            {
                sqltrana.Rollback();
                throw ex;
            }
        }

各位高手帮忙看看,这个事务报错:此 SqlTransaction 已完成;它再也无法使用。谢谢大家

 

补充问你一下大家:怎么实现dataGridView控件中的数据,满足某种条件的情况下该条数据的背景色改变?

转载于:https://www.cnblogs.com/loveyafei168/archive/2010/01/02/1637958.html

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值