what are ADO controls?

[dilahaziz]

Hi.
I just learn about VB and there are something that I still not clear. As I know, ADO controls are used for connection VB to databases such as Access and SQL. However, what are actually the ADO controls? Where can I get the ADO controls? and what is the fullname of ADO?
Thanks.

 

[sunaj]

Hi,
ADO (ActiveX Data Objects) are used to access databases from VB.
Basically you can use ADO in 2 ways; through controls or through code.

To use ADO Controls you need to add the ADO controls to your project (right click the components pane) and add the controls you which to use. You can also try to let the application wizard make a project for you that includes data access and see how the controls are binded to the database)

To use ADO through code, add a reference (project menu) to Microsoft ActiveX Data Objects, and you can now use the ADO Objects. You can also your the (data) wizard to make a project that uses ADO code, to see how it is done.

If you don't allready have ADO on your PC, it can be downloaded (MDAC) from

http://www.microsoft.com/data/download.htm

Happy ADO coding


Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'

 

[dilahaziz]

Hi,
Thanks for the information. Now I have a clear view about this ADO things.
Thanks a lot.