Hello,
Download & Install Oracle Data Provider for Net[
^]. Use code similar to one shown below to connect to Oracle & Retrieve the data.
string strPass;
string strCon = "USER_NAME/PASSWORD@//DB_SERVER_HOST_OR_IP:PORT/SERVICE_NAME";
using (OracleConnection conn = new OracleConnection(strCon))
{
conn.Open();
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = conn;
cmd.CommandText = "SELECT * FROM emp_table WHERE username = :userId";
cmd.CommandType = CommandType.Text;
OracleParameter pUser = new OracleParameter();
pUser.OracleDbType = OracleDbType.Varchar2;
pUser.Value = "xyz";
cmd.Parameters.Add(pUser);
using (OracleDataReader dr = cmd.ExecuteReader())
{
dr.Read();
strPass = dr.GetOracleString(1));
}
}
}
Regards,