/// <summary> /// 更新表,带事务 /// </summary> /// <param name="dt">表</param> /// <param name="con">数据库连接</param> public void Update(DataTable dt, IDbConnection con, IDbTransaction ts) { OracleDataAdapter sda = new OracleDataAdapter(); OracleCommandBuilder scb = new OracleCommandBuilder(sda); try { sda.SelectCommand = new OracleCommand("SELECT * FROM " + dt.TableName, con as OracleConnection); sda.SelectCommand.Transaction = ts as OracleTransaction; scb.RefreshSchema(); sda.Update(dt); } catch (OracleException ex) { throw (ex); } }