ADO.NET Forcing updates in the Datasource

[georg]

Hello All,

Im 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 hasnt 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