oracle中的事务怎么写？

[luoyu1314]

//SqlConnection con = dbaccess.DBOpen();
//SqlCommand cmd;
//SqlTransaction tran = con.BeginTransaction();
//cmd = con.CreateCommand();
//cmd.Connection = con;
//cmd.Transaction = tran;
OracleConnection con = dbaccess.DBOpen();
OracleCommand cmd;
OracleTransaction tran = con.BeginTransaction;
cmd = con.CreateCommand();
cmd.Connection = con;
cmd.Transaction = tran;

try
{

DataTable dt = new Lmwh_BLL().GetAllYiDong1(Convert.ToInt32(table.Rows[a]["i_pxid"].ToString()), Convert.ToInt32(table.Rows[(a - move_num)]["i_pxid"].ToString()), flid);

DataTable dt2 = new Lmwh_BLL().GetAllYiDong2(Convert.ToInt32(table.Rows[a]["i_lmbh"].ToString()), Convert.ToInt32(table.Rows[(a - move_num)]["i_pxid"].ToString()), flid);

tran.Commit();
this.ClientScript.RegisterStartupScript(this.GetType(), "error", "<script>alert('上移成功！')</script>");
}
catch
{
tran.Rollback();
this.ClientScript.RegisterStartupScript(this.GetType(), "error", "<script>alert('上移失败！')</script>");
}
dbaccess.DBClose(con);

我这里是用sql写的是对的，可是我依葫芦画瓢，写了oracle的，居然OracleTransaction tran = con.BeginTransaction;这里报错，说无法将方法组BeginTransaction转化为System.Data.OracleClient.OracleTransaction？oracle刚学，请大侠们帮忙看一下，告诉我错在哪里并且帮我写一下，谢谢了。。。

[luoyu1314]

请问各位大侠，有懂的麻烦帮帮我。。。

[dd__dd]

public bool ExecuteSqlTran(ArrayList SQLStringList)
        {
            bool b = false;
            try
            {
                Open();
                OracleCommand cmd = new OracleCommand();
                cmd.Connection = con;
                OracleTransaction tx = con.BeginTransaction();
                cmd.Transaction = tx;
                try
                {
                    for (int n = 0; n < SQLStringList.Count; n++)
                    {
                        string strsql = SQLStringList[n].ToString();
                        if (strsql.Trim().Length > 1)
                        {
                            cmd.CommandText = strsql;
                            cmd.ExecuteNonQuery();
                        }
                    }
                    tx.Commit();
                    b = true;
                }
                catch (System.Data.OracleClient.OracleException Etx)
                {
                    tx.Rollback();
                    //throw new Exception(Etx.Message);
                }
            }
            catch (System.Data.OracleClient.OracleException E)
            {
                //throw new Exception(E.Message);
            }
            finally
            {
                Close();
            }
            return b;
        }

Open()和Close()方法是自定义的，就是用来打开和关闭连接的