oracle connection

[fawaz80]

Hi,
Can anyone tell me how can I connect orace database through ASP.NET and C#. I mean I am using c# code in asp.net and want to connect to oracle.

Please help what libraries should I use and how?
Fawaz

[prasad_agv]

<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.OleDb" %>

<script runat="server">

OleDbConnection cn=new OleDbConnection("
PROVIDER=MSDAORA.1;user id=scott;password=tiger;
data source=oracle");
cn.Open();
OleDbDataReader dr=new OleDbDataReader("
select * from emp", cn);

</script>

********
In connection string

User ID : Ur oracle data base user id.
Password : Ur oracle data base Password.
data source : this should be set in server system's oranames.ini file.

[prasad_agv]

<%@ Page Language="C#" %>
<%@ Import NameSpace="System.Data" %>
<%@ Import NameSpace="System.OleDb" %>

<script runat="server">

OleDbConnection cn=new OleDbConnection("PROVIDER=
MSDAORA.1;user id=scott;password=tiger;data source=
oracle");
cn.Open();

OleDbDataReader dr=new OleDbDataReader("
select * from emp", cn);

</script>

In connection string

User ID : Ur oracle data base user id.
Password : Ur oracle data base Password.
data source : this should be set in server system's oranames.ini file.

[prasad_agv]

<%@ Page Language="C#" %>
<%@ Import NameSpace="System.Data" %>
<%@ Import NameSpace="System.OleDb" %>

<script runat="server">

OleDbConnection cn=new OleDbConnection("PROVIDER=
MSDAORA.1;user id=scott;password=tiger;data source=
oracle");
cn.Open();

OleDbDataReader dr=new OleDbDataReader("
select * from emp", cn);

</script>

In connection string

User ID : Ur oracle data base user id.
Password : Ur oracle data base Password.
data source : this should be set in server system's oranames.ini file.

[prasad_agv]

<%@ Page Language="C#" %>
<%@ Import NameSpace="System.Data" %>
<%@ Import NameSpace="System.OleDb" %>
<script runat="server">
OleDbConnection cn=new OleDbConnection("PROVIDER=
MSDAORA.1;user id=scott;password=tiger;data source=
oracle");
cn.Open();
OleDbDataReader dr=new OleDbDataReader("
select * from emp", cn);
</script>

In connection string

User ID : Ur oracle data base user id.
Password : Ur oracle data base Password.
data source : this should be set in server system's oranames.ini file.

[prasad_agv]

namespace:
System
System.Data
System.OleDb

OleDbConnection cn=new OleDbConnection("
PROVIDER=MSDAORA.1;user id=scott;password=
tiger;data source=oracle");

[flylow]

hi,

if you want to use a more direct way to access oracle, have a look at http://www.crlab.com/products.html

they provide access via the oci...