c#写事物

SqlConnection myConn = new SqlConnection(DAL.SQLHelper.CONN_STRING);
                myConn.Open();
                SqlTransaction myTrans = myConn.BeginTransaction();
                SqlCommand myCommand = new SqlCommand();
                myCommand.Connection = myConn;
                myCommand.Transaction = myTrans;//开始事务
                try
                {
                    for (int i = 0; i < orders.Length; i++)
                    {
                        myCommand.Parameters.Add(new SqlParameter("@orderids139", SqlDbType.VarChar, 100)).Value = orders[i];
                        myCommand.CommandText = "update lc_order set order_status=1 where orderids139=@orderids139";
                        upi = myCommand.ExecuteNonQuery();
                        myCommand.Parameters.Clear();
                    }
                    myTrans.Commit();//提交事务
                }
                catch (Exception e)
                {
                    myTrans.Rollback();//回滚事务
                }
                finally
                {
                    myCommand.Dispose();
                    myConn.Close();
                    myConn.Dispose();

                }