Filling from inside a transaction?

  • Thread starter Thread starter Mike King
  • Start date Start date
M

Mike King

How can one fill a DataSet or DataTable from inside a transaction? I'm
receiving an exception when the following Fill method is executed.

DataTable dt = new DataTable();
OracleDataAdapter da = new OracleDataAdapter("SELECT * FROM dual", conn);
da.Fill(dt);

### EXCEPTION ###
Execute requires the Command object to have a Transaction object when the
Connection object assigned to the Command is in a pending local transaction.
The Transaction property of the Command has not been initialized.
 
Mike King said:
How can one fill a DataSet or DataTable from inside a transaction? I'm
receiving an exception when the following Fill method is executed.

DataTable dt = new DataTable();
OracleDataAdapter da = new OracleDataAdapter("SELECT * FROM dual", conn);
da.Fill(dt);

### EXCEPTION ###
Execute requires the Command object to have a Transaction object when the
Connection object assigned to the Command is in a pending local
transaction. The Transaction property of the Command has not been
initialized.
Click to expand...

I solved my problem by using a DataReader.

cmd = new OracleCommand();
cmd.CommandText = "select * from dual";
cmd.Connection = conn;
cmd.Transaction = trans;

IDataReader rdr = cmd.ExecuteReader();

while (rdr.Read())
{
//... do the magic
rdr.GetString(0);
}
 
Back
Top