Oracle® Objects for OLE Developer's Guide 10g Release 1 (10.1) Part Number B10118-01 |
|
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
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 dcprops.gif
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 illustration boxprops.gif
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 Project menu.
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.
...
'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.
ORADataControl.Refresh
...
You now have a valid client, session, database, and dynaset which can be referenced as follows.
object reference
client oradatacontrol.database.session.client
session oracontrol.database.session
database oradatacontrol.database
dynaset oradatacontrol.recordset
4. You can access the data in the RecordSource using Visual Basic controls, such as a TextBox as shown in the previous example.