How to connect Oracle 11g database in visual studio 2015 ??

Question

Hello everyoneI want to use my database that i had created in Oracle 11g to my project in Visual studio 2015.But i am unabpe to do so.So need help and hope i will get stepwise solutions.Thank you.....

Manas Mohapatra · Answer

Step1: Install both VisualStudio 2015 and Oracle 11g Step2: Download the dll here. http://www.oracle.com/technetwork/topics/dotnet/whatsnew/index.html. Then add the dll as refrence in VisualStudio project. Step3: Next write below code to get data from Oracle. 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(); Follow below links that may help you: http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/hol08/dotnet/getstarted-c/getstarted_c_otn.htm http://www.c-sharpcorner.com/UploadFile/deepak.sharma00/connecting-to-oracle-database-from-windows-forms-application/ http://stackoverflow.com/questions/4468199/how-to-connect-to-oracle-11g-database-using-asp-net