Hi All.
I'm using VB.NET ADO - OLEDB connection to an Access database. I'm having a
problem with Inserting data and viewing the results immediately afterwards.
I have a routine that opens a database Connection, sets a Command and runs
an ExecuteNonQuery to Insert a row into a table.
I then run another routine which sets up a Connection and DataAdapter which
fills a DataSet with the modified data above.
The problem is the Adapter appears to retrieve the data before the NonQuery
has inserted the row. What I need is a way to force the write of the
NonQuery before I close it's connection.
In VB6 I would have turned to the BeginTransaction and EndTransaction, but
this doesn't appear to be the same in Net.
Any ideas?
Cheers,
Tull.