retrieving data from Oracle 11g database and putting it in ASP.NET data grid (C#)


I have the following code for connecting to an Oracle DB

using Oracle.DataAccess.Client; // C# ODP.NET Oracle managed provider


string oradb = "Data Source=//;User Id=hr;Password=hr;"; // C#

string oradb = "Data Source=(DESCRIPTION="
             + "(ADDRESS=(PROTOCOL=TCP)(HOST=ORASRVR)(PORT=1521))"
             + "(CONNECT_DATA=(SERVICE_NAME=ORCL)));"
             + "User Id=hr;Password=hr;";
OracleConnection conn = new OracleConnection(oradb); // C#
OracleConnection conn = new OracleConnection(); // C#
conn.ConnectionString = oradb;

conn.Open(); // C#

string sql = " select department_name from departments where department_id = 10"; // C#
OracleCommand cmd = new OracleCommand(sql, conn);
cmd.CommandType = CommandType.Text;

conn.Close();   // C#
conn.Dispose(); // C#

but its not working. Any suggestions?



I have no idea about oracle but then i can see two strings for connections ....check with the connection path property..

this link would help you.

This article has been dead for over six months: Start a new discussion instead
Start New Discussion
View similar articles that have also been tagged: