Execution of a problem of connection to Oracle base will demand use of the SqlDataSource control which should be previously connected to the necessary base. Information of connection should be saved in the Web.config file, and the link to the saved information is specified in SqlDataSource.
Instruction
1. Open the page which is subject to connection to Oracle base and use designing representation.
2. Move the SqlDataSource control from the Data tab which is on the panel of elements on the selected page by method of drag and drop and make sure of correctness of its display. Open a context menu of the moved control by click of the right mouse button at impossibility of display and specify the Show the Smart Tag command.
3. Specify the Setup of Data Source point in the Problems of SqlDataSource directory and execute clicking of the Create Connection button in the opened dialog box of setup.
4. Specify the Database of Oracle point in the Data source directory of the new dialog box "Choice of Data Source" and confirm the choice with clicking of the Continue button.
5. Enter a name of the selected server of Oracle to the line "Server name" of the opened Add Connection dialog box and confirm connection to the necessary database with introduction of the login and a user password in the respective fields.
6. Apply a checkbox in the field "Save my password" for inclusion of function of authentication as the making line of connection and confirm application of the selected changes with clicking of the OK button.
7. Execute clicking of Next in again opened Setup of Data Source window with the changed information on a line of connection and apply a checkbox in the field "Yes, to save this connection".
8. Confirm saving data of a line of connection in the Web.config file with clicking of Next and use the Specify the User Instructions of Sql or a Stored Procedure command for query design manually or select the option "Specify Columns from the Table or Representation" for start of the tool of the master of requests.
9. Enter the desirable name of the table in the directory and define the returned columns in the list of the same name.
10. Confirm the choice with clicking of Next and use the Request Check button.
11. Click "Is ready" for confirmation of application of the selected changes.