You are here:

Active X Programming/Visual Basic ADO & TextBoxes

Advertisement


Question
Hi,

I am learning VB from a book and it explains how to use the controls and set the properties they posses. However the book does not explain for example the "ADO", how the "ADO" works. Is there any where I can get information about all the properties of an "ADO"?

For example in VB and you are typing the name of a "ADO" and you type the period (.), a drop down list appears with a list of properties & Icons, is there a way I can print out all these properties so that I can understand how the ADO works?

In my project I have a TextBox connected to an "ADO". After setting the DataSource to my "ADO" I then was setting the DataField to one of the fields that appeared in the dropdown list in the Properties Window. I noticed in the drop down list were names of all the fields in my table plus three more and they are as follows:

1) s_Generation
2) s_GUID
3) sLineage

They are not part of my table but appear with all my other "ADO" connections. Can you explain what they are and how they work or if they can be used for anything.


Thanking You,


Dexter deSouza  

Answer
Hi Dexter,
Please visit the following links for more information
1. http://www.microsoft.com/data/ado/default.htm
2. http://www.microsoft.com/data/techmat.htm#ado

You can also find some good downloads for ADO at the following link
http://www.microsoft.com/data/download.htm

MSDN, or any book for that matter will discuss the entire list of properties.
As for the prinouts - you can go the Object Browser from the toolbar and view/print all the properties.

regards
abhi

Active X Programming

All Answers


Ask Experts

Volunteer


Abhijeet Landge

Expertise

I can answer questions about System Analysis, Database Design, mapping live systems into models. I can answer questions related to Visual Basic 6.0, databases and ActiveX programming Generating reports using Crystal Reports 7.0, passing parameters from VB Applications is another area where I can be of help. I cannot answer questions pertaining to COM / DCOM.

Experience

Developing Client Server Application in Visual Basic 6.0 and generating complex reports to the satisafaction of the end user using Crystal Reports 7

Education/Credentials
B. E. Computers
[Bachelor or Computer Engineering]

Awards and Honors
Won an Honor Mention in the ICPSC Contest organized by Wisconsin University

©2012 About.com, a part of The New York Times Company. All rights reserved.