The Oracle Data Control, used with Visual Basic 6, makes creating a dynaset
easier, because it does not require you to create the underlying objects.
You must set the Connect, DatabaseName, and RecordSource properties.
The Oracle Data Control when refreshed, automatically creates a client (if needed), session,
database, and dynaset.
This section shows two ways to set the properties of the Oracle Data Control to create a dynaset:
· by using the Visual Basic Properties window
· by programming the properties
Setting Oracle Data Control Properties with the Properties Window
Start Visual Basic and create a new project.
Use the Components option of the Project menu to add "Oracle Data Control"
to the project.
Text description of the illustration projcomp.gif
The Oracle Data Control will be added to your Visual Basic tool palette and will look like this:
Text description of the illustration oradc.gif
3. To add the Oracle Data Control to a project, simply drag and drop the control
onto a form. Resize and position the control.
4. Change the name of the control to ORADataControl. Set up the Connect, DatabaseName, and RecordSource properties as follows to
access the Oracle database.
Text description of the illustration
5. When the Oracle Data Control is set up, you can drag and drop a Visual Basic
control onto the same form and access the data in the control. Simply set the
Data properties to access the data field and source that you want. This figure
shows a TextBox control which sets up display of the employee numbers.
Text description of the
6. When the project is run, the data identified by the RecordSource property is
displayed using the Oracle Data Control.
Text description of the illustration runform.gif
You can also use the Microsoft FlexGrid Control to display all the data in the
table. You need to add the grid control with the Components option of the
Setting Oracle Data Control Properties Programmatically
The following code fragment demonstrates how to programmatically set the
properties of the Oracle Data Control required to create a dynaset. These are the same properties that you can set
with the Properties window of Visual Basic.
Create a new project and then use the Components option of the Project menu to
add "Oracle Data Control" to the project.
Drag and drop an Oracle Data Control on a form. Change the name of the control
After you have inserted an Oracle Data Control onto a form, add the following
code to the Load procedure associated with the form.
'Set the username and password.
ORADataControl.Connect = "scott/tiger"
'Set the database name.
ORADataControl.DatabaseName = "ExampleDb"
'Set the record source.
ORADataControl.RecordSource = "select * from emp"
'Refresh the data control.
You now have a valid client, session, database, and dynaset which can be
referenced as follows.
4. You can access the data in the RecordSource using Visual Basic controls, such
as a TextBox as shown in the previous example.