我用oracle 实现一个事务处理的例子:OracleTransaction sqlTran=null;
                OracleCommand cmd = null;
                    try
                    {                        string sql1 = "insert into y_gdzh_ddzbrz(sj) values(to_date('" + sdzbrq + "','yyyy-mm-dd hh24:mi:ss' ));";
                        StringBuilder builder = new StringBuilder();
                        //builder.Append("begin ");
                        builder.Append(sql1);
                        builder.Append(" \r\n ");
               builder.Append("select max(zbrzbh) from y_gdzh_ddzbrz;");
                       // builder.Append(" end;");
                                               cmd = new OracleCommand();
                        cmd.Transaction = sqlTran;                        cmd.CommandText = builder.ToString();
                        string bh1 = myModel.excuteTran(sqlTran, builder.ToString(), cmd);
                        string sql2 = "insert into y_gdzh_ddzbrzxx(sj,ZBRZBH) values(to_date('" + sdzbrq + "','yyyy-mm-dd hh24:mi:ss'),'"+bh1+"')";
                        cmd.CommandText = sql2;
                        myModel.excuteTran(sqlTran, sql2,cmd);
                        sqlTran.Commit();
                      
                    }
也就是想同时执行两条sql语句,
可能是换行符“\n\r”的问题,一直报“字符错误!”,都弄了一天了,超级郁闷的!