connect to Oracle server by using csharp

[blackdog]

I have Oracle client in my system, like to use csharp to communicate
with Oracle server to
retrieve data.
I am very new in csharp, would anyone please give me an example codes
or web pointer.
thanks a lot.

[Adam Clauss]

http://www.google.com/search?q=C%23+oracle

http://www.oracle.com/technology/pub...ok_dotnet.html

--
Adam Clauss

"blackdog" <cl***@hotmail. comwrote in message
news:11******** ************@i4 2g2000cwa.googl egroups.com...

>I have Oracle client in my system, like to use csharp to communicate
with Oracle server to
retrieve data.
I am very new in csharp, would anyone please give me an example codes
or web pointer.
thanks a lot.

[Carl Daniel [VC++ MVP]]

blackdog wrote:

I have Oracle client in my system, like to use csharp to communicate
with Oracle server to
retrieve data.
I am very new in csharp, would anyone please give me an example codes
or web pointer.
thanks a lot.

using System.Data;
using System.Data.Ora cleClient;

class Program
{
pulic static void Main()
{
using (OracleConnecti on con = new OracleConnectio n("your connection
string here"))
{
OracleCommand cmd = con.CreateComma nd();
cmd.CommandText = "select something from some database";
using (OracleDataRead er rdr = cmd.ExecuteRead er())
{
if (rdr.Read())
// ... read some data
}
}
}
}

http://msdn2.microsoft.com/en-us/lib...cleclient.aspx

You have to use .NET 1.1 or 2.0 to use OracleClient, otherwise you can use
System.Data.Ole Db if you have to use .NET 1.0. You have to install the
Oracle client tools on the machine that will access the oracle server.

-cd