- Start Visual Basic and create a new project.
- Use the Components option of the Project menu to add "Oracle Data Control" to the project.
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.
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.
6. When the project is run, the data identified by the RecordSource property is displayed using the Oracle Data Control.
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.
- 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 to 'ORADataControl'.
- After you have inserted an Oracle Data Control onto a form, add the following code to the Load procedure associated with the form.
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.