CMHamrick
asked on
Refresh a datagrid that is bound to a Designer - DataEnvironment
Help!!!!!!!!!!
I have a DataGrid that is set up in this manner:
Datasource: DataFEBCO_Systems
Datamember: Current_Bids
I created the DataEnvironment using: Add - More AxtiveX Designers - DataEnvironment
Then I created the DEConnection: dataFEBCO_Database with a DECommand, Current_Bids
So the tree to the data looks like this:
DataFEBCO_Systems (DataEnvironment)
dataFEBCO_Database(DEConne ction)
Current_Bids(DECommand)
Question: How do I refresh the DataEnvironment, DEConnection, or DECommand - so that when I refresh the DataGrid, it will display the changes made to the database?
Need this ASAP!! - Thanks in advance :)
I have a DataGrid that is set up in this manner:
Datasource: DataFEBCO_Systems
Datamember: Current_Bids
I created the DataEnvironment using: Add - More AxtiveX Designers - DataEnvironment
Then I created the DEConnection: dataFEBCO_Database with a DECommand, Current_Bids
So the tree to the data looks like this:
DataFEBCO_Systems (DataEnvironment)
dataFEBCO_Database(DEConne
Current_Bids(DECommand)
Question: How do I refresh the DataEnvironment, DEConnection, or DECommand - so that when I refresh the DataGrid, it will display the changes made to the database?
Need this ASAP!! - Thanks in advance :)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
... and one more reason not to use DE. :)
Leon
Leon
Even if I'm not a fan of the DE, you would have the same problem using ADO objects!
You always need to refresh your ADO object before refreshing your GUI object!
You always need to refresh your ADO object before refreshing your GUI object!
https://www.experts-exchange.com/questions/20766815/Reasons-not-to-use-Data-Enviroment-control-in-VB6.html
Leon