Completing the Oracle Database Connection task will require the use of the SqlDataSource control, which must first be connected to the desired database. The connection information must be saved in the Web.config file, and the saved information must be referenced in the SqlDataSource.
Instructions
Step 1
Open the page to connect to the Oracle database and use the design view.
Step 2
Move the SqlDataSource control from the Data tab in the Toolbox to the selected page using the drag-and-drop method and make sure it is displayed correctly. Call the context menu of the moved control by right-clicking if it cannot be displayed and select the Show Smart Tag command.
Step 3
Specify the "Configure Data Source" item in the "SqlDataSource Tasks" directory and click the "Create Connection" button in the configuration dialog box that opens.
Step 4
Select Oracle Database in the Data Source directory of the new Select Data Source dialog box and confirm your choice by clicking Continue.
Step 5
Enter the name of the selected Oracle server in the "Server name" line of the "Add connection" dialog box that opens and confirm the connection to the required database by entering the username and password in the appropriate fields.
Step 6
Click the Save My Password checkbox to enable authentication as part of the connection string and confirm the selected changes by clicking OK.
Step 7
Click the Next button in the newly opened Data Source Setup window with the changed information about the connection string and apply the checkbox to the Yes, keep this connection field.
Step 8
Confirm that the connection string data is saved in the Web.config file by clicking Next and use the Specify Custom Sql Statements or Stored Procedure command to manually create a query, or select the Specify Columns From Table or View option to launch the Query Wizard tool.
Step 9
Specify the desired table name in the catalog and define the returned columns in the list of the same name.
Step 10
Confirm your choice by clicking the Next button and use the Verify Request button.
Step 11
Click the "Finish" button to confirm the application of the selected changes.
