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

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra10y ago
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