OracleConnection.Open()
Dim tx As OracleClient.OracleTransaction = OracleConnection.BeginTransaction( _
  IsolationLevel.ReadCommitted)
Adapter1.SelectCommand.Transaction = Tx
 
Adapter1.Fill ..........
 
tx.Commit
Catch ex As Exception
            tx.Rollback()
Finally
            OracleConnection.Close()
        End Try

Micke