Programs Knowledge

using System.Configuration;//取得"config檔"必需的

using System.Data;//使用"DataTable"必需的

using System.Data.OracleClient;//取得"Oracle相關物件"必需的

//取得設定在config檔裡的變數

string Str1 = ConfigurationManager.AppSettings["Variable1"];

string Str2 = ConfigurationManager.AppSettings["Variable2"];

string connectionStr = ConfigurationManager.ConnectionStrings["OracleConnectionStr"].ToString();

OracleConnection oConn = new OracleConnection(connectionStr);

…

app.Config

//連線設定分別需要輸入HOST、PORT、SID、User Id and Password

<configuration>

  <appSettings>

    <add key = "Variable1" value ="abcdefg"/>

    <add key = "Variable2" value ="1234567"/>

  </appSettings>

  <connectionStrings>

    <add name="OracleConnectionStr" connectionString="Data Source=(DESCRIPTION=

(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.X.X)(PORT=1521)))

(CONNECT_DATA=(SID=XE)));User Id=system;Password=oracle"/>

  </connectionStrings>

</configuration>