C# Winform - OracleDataAdapter不立即保存记录

OracleDataAdapter adapter = new OracleDataAdapter("SELECT * FROM YourTable", connectionString);
DataSet dataSet = new DataSet();
adapter.Fill(dataSet, "YourTable");

// 修改数据
DataRow row = dataSet.Tables["YourTable"].Rows[0];
row["ColumnName"] = newValue;

// 保存更改
adapter.Update(dataSet, "YourTable");

OracleConnection connection = new OracleConnection(connectionString);
connection.Open();

OracleTransaction transaction = connection.BeginTransaction();
OracleDataAdapter adapter = new OracleDataAdapter("SELECT * FROM YourTable", connection);
adapter.SelectCommand.Transaction = transaction;

DataSet dataSet = new DataSet();
adapter.Fill(dataSet, "YourTable");

// 修改数据
DataRow row = dataSet.Tables["YourTable"].Rows[0];
row["ColumnName"] = newValue;

// 保存更改
adapter.Update(dataSet, "YourTable");

transaction.Commit();
connection.Close();