Connect to Oracle Database using SQLDataSource in ASP.NET c#/vb.net

Connect to Oracle Database using SQLDataSource in ASP.NET c#

Step1) Download Oracle Data Provider for .NET OPD.NET

             for 32-bit  OPD.NET 32-bit

             for 64-bit OPD.NET 64-bit

           Download Oracle XE free version for Home User from Oracle

Step 2) Install Oracle and Oracle Data Provider tools for Visual Studio available in OPD.NET

Step 3)  Add GridView to aspx page

Step 4)  In The design mode click on New Data Source

Step 5) Choose Data Source Type as Database

Step 6)  Click on New Connection 

                 "Add Connection" Dialog box will come up.-> Click Change button

Step 7)   Select "Oracle Database"  Leave Default.  Click OK

Step 8)    Enter Oracle Credentials

                   Here Server Name: Localhost

                            User name: scott 

                            Password:tiger

Step 9)  Oracle Connection String

Step 10)  Save That Connection String in Web.config

Step 11) Select Oracle Database Table Here I choose "EMP"

                  Click Next->Next->Finish

Step 12)  Add Reference to  System.Data.OracleClient

Step 13) Goto  Web.config

Change from

<add name="ConnectionString"

connectionString="Provider=MSDAORA;Data Source=localhost;Password=tiger;User ID=scott"
      providerName="System.Data.OleDb" />

                       TO

    <add name="ConnectionString" connectionString="Data Source=XE;Password=tiger;User ID=scott"
      providerName="oracle.DataAccess.Client" />

Step 14)  Here is the SQLDataSource

        <asp:SqlDataSource ID="HR" runat="server"
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
            ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"
            SelectCommand="SELECT * FROM [EMP]"></asp:SqlDataSource>

Step 15) Specify SQLDataSource ID in GridView

        <asp:GridView ID="GridView1" runat="server"  Width="459px" DataSourceID="HR"></asp:GridView>

Step 16) Run the Page.

Query Oracle Database using SQLDataSource in ASP.NET

EMPNO	ENAME	JOB	MGR	HIREDATE	SAL	COMM	DEPTNO
7369	SMITH	CLERK	7902	12/17/1980 12:00:00 AM	800		20
7499	ALLEN	SALESMAN	7698	2/20/1981 12:00:00 AM	1600	300	30
7521	WARD	SALESMAN	7698	2/22/1981 12:00:00 AM	1250	500	30
7566	JONES	MANAGER	7839	4/2/1981 12:00:00 AM	2975		20
7654	MARTIN	SALESMAN	7698	9/28/1981 12:00:00 AM	1250	1400	30
7698	BLAKE	MANAGER	7839	5/1/1981 12:00:00 AM	2850		30
7782	CLARK	MANAGER	7839	6/9/1981 12:00:00 AM	2450		10
7788	SCOTT	ANALYST	7566	4/19/1987 12:00:00 AM	3000		20
7839	KING	PRESIDENT		11/17/1981 12:00:00 AM	5000		10
7844	TURNER	SALESMAN	7698	9/8/1981 12:00:00 AM	1500	0	30
7876	ADAMS	CLERK	7788	5/23/1987 12:00:00 AM	1100		20
7900	JAMES	CLERK	7698	12/3/1981 12:00:00 AM	950		30
7902	FORD	ANALYST	7566	12/3/1981 12:00:00 AM	3000		20
7934	MILLER	CLERK	7782	1/23/1982 12:00:00 AM	1300		10

Step 17) That's it, Happy coding...


Tags: Connect to Oracle Database in asp.net C#,Query Oracle Database in asp.net C#, Step by Step process to connect to Oracle database in asp.net , Connect to oracle database using SQLDataSource,
oracle data provider for .NET,oracle data provider for ADO.NET,ORACLE CONNECTION STRING IN WEB.CONFIG,ORACLE PROVIDER NAME IN CONNECTION STRING,Connect to Oracle Database in asp.net VB.NET ,Query Oracle Database in asp.net VB.NET , Step by Step process to connect to Oracle database in asp.net , Connect to oracle database using SQLDataSource,
oracle data provider for .NET,oracle data provider for ADO.NET,ORACLE CONNECTION STRING IN WEB.CONFIG,ORACLE PROVIDER NAME IN CONNECTION STRING