JonnyPoet
Jul 17th, 2006, 04:57 PM
Hi All !
I'm just doing an activeX similar to a datgrid. The User should be able to connect with a databse using DataSource Property of my control. As well ADODC and DE objects should be connected. I'm ready with connectiong to ADODC which has no major problem to read out the data of a database table which is connected via the ADODC I'm setting to my DataSource. What I do is I show all fields of this table in the userdefined PropertyPage in a listbox. There the user can have a free decision, which gridcolumn is bound to which tablefield. No problem with ADODC objects.
With dataenviroment I can have a working connection at runtime but NOT at designtime. The recordset seems to be there, but cannot be opend at designtime, at runtime code to read tabledata works, but its to late. The user needs to be able to have access to all fields in designtime too.
As the disigner has a connection to database also at designtime obviously ( otherwise it would not be possible to design the Tables, query's in the designer using graphically methods, I think ). So the question is how to connect and open a Dataenviroment in designtime.? Anyone knows ?
Jonny Poet
I'm just doing an activeX similar to a datgrid. The User should be able to connect with a databse using DataSource Property of my control. As well ADODC and DE objects should be connected. I'm ready with connectiong to ADODC which has no major problem to read out the data of a database table which is connected via the ADODC I'm setting to my DataSource. What I do is I show all fields of this table in the userdefined PropertyPage in a listbox. There the user can have a free decision, which gridcolumn is bound to which tablefield. No problem with ADODC objects.
With dataenviroment I can have a working connection at runtime but NOT at designtime. The recordset seems to be there, but cannot be opend at designtime, at runtime code to read tabledata works, but its to late. The user needs to be able to have access to all fields in designtime too.
As the disigner has a connection to database also at designtime obviously ( otherwise it would not be possible to design the Tables, query's in the designer using graphically methods, I think ). So the question is how to connect and open a Dataenviroment in designtime.? Anyone knows ?
Jonny Poet