كيفية ربط ORCALE E-BUSINUSS SUITE مع سي شارب

public class DLApplication

{

private const String My_name = " DLApplication : ";

private static String m_sConStr = "SERVER=Crisi;USER ID=MyUser;PWD=pp1";

private int userId;

public int propertyUserId

{

get

{

return userId;

}

set

{

userId = value;

}

}

public OracleConnection GetCon()

{

try

{

OracleConnection sqlcon = new OracleConnection(m_sConStr);

return sqlcon;

}

catch (Exception ex)

{

throw new System.ApplicationException(My_name + " GetCon: " + ex.Message);

}

}

public OracleDataReader GetSqlReader(String Sql, ref OracleConnection con)

{

try

{

OracleCommand objOraCmd = new OracleCommand();

OracleDataReader objOraDrRead;

objOraCmd.Connection = con;

objOraCmd.CommandType = CommandType.Text;

objOraCmd.CommandText = Sql;

if (con.State != ConnectionState.Open) con.Open();

objOraDrRead = objOraCmd.ExecuteReader(CommandBehavior.CloseConnection);

return objOraDrRead;

}

catch (Exception ex)

{

throw new System.ApplicationException(My_name + " GetSqlReader: " + ex.Message);

}

}

public void CloseCon(ref OracleConnection thisCon)

{

try

{

if (thisCon.State != ConnectionState.Closed)

thisCon.Close();

}

catch (Exception ex)

{

throw new System.ApplicationException(My_name + " CloseCon: " + ex.Message);

}

}

public void ExecNonQuery(String sQuery)

{

OracleConnection objCon = new OracleConnection(m_sConStr);

OracleCommand objCmd;

try

{

objCon.Open();

objCmd = objCon.CreateCommand();

objCmd.CommandText = sQuery;

objCmd.ExecuteNonQuery();

}

catch (Exception ex)

{

throw new System.ApplicationException(My_name + " ExecNonQuery : " + ex.Message);

}

finally

{

if (objCon.State == ConnectionState.Open)

objCon.Close();

}

}

public DataView getDataView(String Query, OracleConnection Conn)

{

try

{

OracleDataAdapter oDa;

DataSet ds;

oDa = new OracleDataAdapter(Query, Conn);

ds = new DataSet();

oDa.Fill(ds);

if (Conn.State != ConnectionState.Closed)

Conn.Close();

return (ds.Tables[0].DefaultView);

}

catch (Exception ex)

{

throw new System.ApplicationException(My_name + " getDataView : " + ex.Message);

}

finally

{

if (Conn.State != ConnectionState.Closed)

Conn.Close();

}

}

}

جربت هذا الكود بس ما نفع معي

public static string Connection()

{

try

{

string oradb = "Data Source=XE;User Id=hr;Password=hr;";

conn = new OracleConnection(oradb);

conn.Open();

}

catch (OracleException e)

{

return e.Message;

}

return conn.State.ToString();

}