Tertioptus
asked on
Where's my data??? (MS ACCESS, OLE DB, DataGrid)
1. I have a DataGrid.
2. I have a Form.
3. I have an Access DB.
4. I have a dataset.
The Form data is inserted into my DB in an isolated transaction.
After that transaction has completed, I reload my dataset which is binded to the DataGrid. I use a connection instance for me insert transaction, and another connection object for my "selects". Even though both connection objects are created from the same connection string (appended below), the data seems to not be updated with a follow up my completed transaction with a search on the newly inserted data.
Basically the data I'm submitting is not show up in my datagrid. It's like I have to wait a few seconds and search again to find it. Is Access really that slow. Why would it complete my insert and transaction if it's not done.
Provider=Microsoft.Jet.OLE
2. I have a Form.
3. I have an Access DB.
4. I have a dataset.
The Form data is inserted into my DB in an isolated transaction.
After that transaction has completed, I reload my dataset which is binded to the DataGrid. I use a connection instance for me insert transaction, and another connection object for my "selects". Even though both connection objects are created from the same connection string (appended below), the data seems to not be updated with a follow up my completed transaction with a search on the newly inserted data.
Basically the data I'm submitting is not show up in my datagrid. It's like I have to wait a few seconds and search again to find it. Is Access really that slow. Why would it complete my insert and transaction if it's not done.
Provider=Microsoft.Jet.OLE
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Oui, oui, Nuno
ASKER
Just needed to maintain one connection object. Thanks.
Are you explicitly commiting the transaction? that could be the problem.