<appSettings>
<add key="conStr" value="Data Source=Name;User Id=UID; Password=Password"></add>
</appSettings>
using System.Data.OracleClient;
OracleConnection oraconn = null;
private bool ConnectDatabase()
{
oraconn = new OracleConnection(ConfigurationSettings.AppSettings["conStr"]);
if (oraconn.State == System.Data.ConnectionState.Closed)
{
oraconn.Open();
}
return true;
}
private string GetData(string ID)
{
try
{
OracleDataReader drec;
OracleCommand cmd = new OracleCommand("Select colname from tablename where ID = '" + ID + "'", oraconn);
drec = cmd.ExecuteReader();
drec.Read();
if ( drec.HasRows )
{
return drec.GetValue(0).ToString();
}
else
return "E:No Data Present";
}
catch (Exception ex)
{
return ex.Message;
}
}
private string GetDataBySP(string ID)
{
try
{
OracleDataReader drec;
OracleCommand cmd = new OracleCommand("SP_NAME", oraconn);
cmd.CommandType = CommandType.StoredProcedure ;
drec = cmd.ExecuteReader();
drec.Read();
if ( drec.HasRows )
{
return drec.GetValue(0).ToString();
}
else
return "E:No Data Present";
}
catch (Exception ex)
{
return ex.Message;
}
}
ConnectDatabase();
GetData("1");
Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.
Comments (1)
Commented:
"Data Source=MyOracleDB;User Id=username;Password=passw
Security=no;"
This one works only with Oracle 8i release 3 or later
Declare the OracleConnection:
C#:
using System.Data.OracleClient;
OracleConnection oOracleConn = new OracleConnection();
oOracleConn.ConnectionStri
oOracleConn.Open();
VB.NET:
Imports System.Data.OracleClient
Dim oOracleConn As OracleConnection = New OracleConnection()
oOracleConn.ConnectionStri
oOracleConn.Open()