The Property Example

The Property Example is a simple application that utilizes the Properties collection and the Property object to report in a user-friendly manner the dynamic characteristics that are exposed by a data provider for any of the given ADO objects that support the Properties collection. Figure B-1 shows the Property Example main dialog box when the program is executing.

The Property Example
Figure B-1. The Property Example

To begin, create a new Visual Basic project, select the Standard EXE project type, name the default form frmPropertyExample, and change its Caption property to “Property Example”. Next, add two labels, a List View control, and five command buttons. For each of these controls, set the values of the properties shown in Table B-2.

Table B-2. The Property Example Control Settings

Control

Property

Value

Label

Caption

Properties for:

Label

Name

lblObject

List View

Name

lvwProperties
 

View

3 - lvwReport

Command Button

Name

cmdConnection
 

Caption

Co&nnection

Command Button

Name

cmdRecordset
 

Caption

&Recordset

Command Button

Name

cmdCommand
 

Caption

Co&mmand

Command Button

Name

cmdField
 

Caption

&Field

Command Button

Name

cmdClose
 

Caption

&Close

Next, you need to add the four column headers through the Custom property in the property dialog box in the Visual Basic IDE for the List View. The four columns that you need to create are:

  • Name

  • Value ...

Get ADO: ActiveX Data Objects now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.