How To Build an ASP.NET Web Site Application With Oracle

1. Bring up Visual Studio 2008
2. Navigate to the File menu and select "New Web Site"
   
   
   
   
   
   
3. On the “New Web Site” page please select “ASP.NET Web Site”. Make sure you name it C:\MyFirstWebSite”. Set the language to “Visual C#”. Then click “OK”.
   
   
   
   
4. When you see the “Default.aspx” page in your new ASP.NET web site please click the Design tab
   
   
   
   A blank canvas will appear:
   
   
   
   
5. Do you see the “Toolbox” tab on the top left hand side of the screen? Move the mouse over it to bring up the Toolbox like this:
   
   
   

   ---

   Oracle Tips & Tricks to 
   SKYROCKET Your Career!

   If you're not already a subscriber to Oracle Secrets Revealed, you're  missing out on a myriad of tips and techniques to help you work better, faster and smarter.  Subscribe now and ignite your career.
   

   ---

6. Make sure you expand Data and look for the GridView control. Then drag it to the canvas so that it will appear like this:
   
   
   
   
7. Now you will create a data source. In case you do not see the GridView Tasks view please click the ">" to bring it into view like the previous screenshot. Please select <New data source…>
   
   
   
   
8. Choose Database as the Data source type, enter HR as the ID and click “OK”.
   
   
   
   
9. Click on “New Connection”
   
   
   
   
10. This causes the Change Data Source Dialog box appear as in the screen shot below
    
    
    Click the “Change…” button to ensure that the Oracle Database is selected as the data source for your ASP.NET site and the Data provider is set to the “Oracle Data Provider for .NET”. Click the check box beside “Always use this selection”. Now click "OK"
    
    



11. On the connection details tab of the “Add Connection” dialog box set the Data Source Name to “XE”. Enter “HR” for the user name and the password. The screen should look like this:
    
    
    
    
12. Now click the “Test Connection” button. You should see this dialog appear:
    
    Click the “OK” button.Note: If you get this error message it means that the ODAC client cannot resolve the data source name you specified for your ASP.NET app. Stop the database server. Ensure that you carry out step 4 of the prerequisites and start the database server again.
    
    
13. Click “Next” 
    
    



14. Click “Next”  to save the connection string for your ASP.NET web site
    
    
15. Now you need to configure a select statement. Select the DEPARTMENTS table from the Names drop down list and click the checkbox beside “*”. Then click the “Next” button.
    
    
    
    
16. The “Test Query” dialog box appears with the select statement that you created in the previous step. 
    
    
    
    
17. Click the “Test Query” button and you will see the results appear
    
    
    
    Click the “Finish” button.
    
    
18. When you see the Data Grid View appear please click the “Enable Paging” check box in the Grid View Tasks panel.
    
    
    
    
19. Now you will build your ASP.NET web site and run it. First you must build the web site. Navigate to Build->Build Web Site.
    
    
    
    
20. If the build was successful you should see this screen
    
    
21. Now test the web site by running it. Navigate to “Debug->Start Debugging”
    
    
    
    
22. When this dialog box appears, click “OK” to change the web.config file to allow debugging
    
    
23. You will see a web brower appear with the results of your query.
    
    
24. Congratulations! You just created and ran your first ASP.NET web site application.