31 January 2012

mengambil nilai appSettings dan connectionStrings di app.config

Ketika membuat aplikasi windows form menggunakan VB.NET, berikut cara mengambil string di app.config
requirement :
- tambahkan reference system.configuration ke project tersebut
- tambahkan application configuration ke project (akan menambahkan file app.config ke project)

dengan isi app.config sebagai berikut :

<appSettings>
    <add key="pathToOracleBin" value="C:\oracle\product\11.2.0\client_2\bin\"/>
    <add key="userToRepository" value="source"/>
    <add key="passToRepository" value="oracle"/>
    <add key="hostRepository" value=" dbservice "/>
  </appSettings>
  <connectionStrings>
    <add name="StrTodb" providerName="Oracle.DataAccess.Client" connectionString="Data Source=dbservice;User Id=source;Password=oracle;"/>
  </connectionStrings>


#mengambil nilai dari pathToOracleBin di appSettings
 Dim userToRepository As String = System.Configuration.ConfigurationManager.AppSettings(" pathToOracleBin ")


#mengambil nilai dari  StrTodb di connectionStrings
Dim connStrToDb As String = System.Configuration.ConfigurationManager.ConnectionStrings("StrTodb").ConnectionString

No comments:

Post a Comment