How to avoid using DataControl or Adodc?

[Michel Jr]

Hi,

I have heard some developers saying to avoid using bound controls (attached to a database) like DataControl, Grid and others.

How can I create a form to see many records at the same time and allowing me to make changes without using a Grid with Adodc?

Some ideas of how to replace these bounded controls?

Thanks in advance...

Michel Jr.


Some good Activex controls at my HP:
http://www.geocities.com/michel_junior_hp/index.html

[nolanvenhola]

data controls are great... I have a program with 25000+ lines of code which I wrote and it's all based on data bound controls.

why do think microsoft made them... for them not to be used?

[coolbiz]

Well, if you're not comfortable in using the DATA CONTROL, then just use regular control to display the information. You can still connect to a database connection manually by using ADO component library and filling up the controls by yourself.

If you do not really know on how to do so, post again to this thread or just search for ADO or DAO or ODBC in this forum, you'll get the answer that you need.

-Cool Bizs

[katlaw]

Yes, but the problem is that these controls keep open connections to the database. If you have multiple datagrids with ADODC's in your program, you can have multiple database connections open at the same time. This caused a big problem for my client, as a single user can use up all the connections to the database! We had to change our style to use TrueDBGrid (a third-party control), and no bound controls.

HTH!

katlaw

[Iouri]

I prefer not to use ADODC and bound control. In the beginning it is little bit easier to get data to the grid, but later you lose a lot of flexibility. I prefer to use MSFlexGrid and enter recordset there. From my point of view it is much more flexible approach to the task.

Iouri Boutchkine
iouri@hotsheet.com