ADO.NET Forcing updates in the Datasource

[georg]

Hello All,

 

I'm making event driven calls to the db (Access 2000) from my windows form to collect a Transaction id (that I have created)

 

These Transaction ids must be unique.

 

I get a Transaction id from the database using a Datareader, and then write the next Unique Id in the sequence back to the same table with an Update query (using ExecuteNonQuery)

 

When I try to get the Transaction Id that I just wrote to the table, sometimes it appears as if the Update hasn't had time to come into effect (when I repeat the event quickly).

 

Is there anything like "Database Refresh" like I had in DAO?

 

Thanks,

 

georg

[georg]

My old friend the serializeable class has come to the rescue. Problem solved.

 

Thanks for looking.

 

georg