connectivity to database

Question

How can i connect to my oracle database using my ado .net application? I mean how can i get the connection string to give in the appconfig file?

Dhirendra Misra · Answer

Hello Sijo, First off you need to download and install ODP from this site http://www.oracle.com/technetwork/topics/dotnet/index-085163.html After installation add a reference of the assembly Oracle.DataAccess.dll. using Oracle.DataAccess.Client; // ODP.NET Oracle managed provider using Oracle.DataAccess.Types; Class Test { string oradb = "Data Source=ORCL;User Id=hr;Password=hr;"; OracleConnection conn = new OracleConnection(oradb); // C# conn.Open(); OracleCommand cmd = new OracleCommand(); cmd.Connection = conn; cmd.CommandText = "select department_name from departments where department_id = 10"; cmd.CommandType = CommandType.Text; OracleDataReader dr = cmd.ExecuteReader(); dr.Read(); label1.Text = dr.GetString(0); conn.Dispose(); } For more details please refer : http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/dotnet/GettingStartedNETVersion/GettingStartedNETVersion.htm T hanks

Sijo george · Answer

thnx frnd..thanx alot

Dhirendra Misra · Answer

Hi, http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html You can check which is suitable for your machine and version of .net VS you are using.

Sijo george · Answer

hii dhirendra...thanks for your answer..and i will mark it after i try it..thnku very much.. I checked the link..there are so many options..which one i should download?

connectivity to database

Answers (4)