Memory usage by controls

[Farhan Ullah]

In a VB app. what is the effect on memory by using bound (dbcombo,dbgrid, etc ) and unbound (combo, etc) controls.

We can open database by using Data control at design time Or we can define it at runtime.
Which is more efficient and less memory consumption.

i have a form having several combo box and text box and grid . and they are linked with different tables in similat database. what is the vesy methid to connect it to database.

[askus]

The effect is same after compilation but when u do it at desing time, the connection speed to the database is fast and its less memory consuming.

but when u connect to the database at runtime please set the forms memory to nothing which will
inturn set all the controls memory to nothing.

There is no difference of using a bound and an unbound controls bcos there is no difference on memory handling but the difference is there only on connection speed

Be careful when u r using a DBcombo control with data binding because there are known bugs and loss of data for which u can install service pack 3 to avoid the above error

For connecting to different tables using different controls, use the same data source for all the controls but in the datafield property of each control set the table name u wish to access. this is the efficient way at runtime by setting the datacontrol's recordsource property. if u want it in design time u will have to go in for different datacontrol for each and every control

please get back to solutionproviders@hotmail.com or solutionproviders@yahoo.com for further clarifications



The Ultimate Solution Providers

Authors

Sriman & Jayaraman

Email : solutionproviders@hotmail.com
solutionproviders@yahoo.com

Hand Phone : +(6) 016 2237147