Connection String in WinForm App

From Logic Wiki
Revision as of 12:34, 26 February 2015 by Macrop (Talk)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


in exe or dll apps connection string can be placed in config file like in web apps.

it can be set in app.config file like this

<?xml version="1.0"?>
<configuration>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>
  </startup>
  <appSettings>
    <add key ="ConnectionString" value="data source=vaughan;initial catalog=Aviva_Dev;persist security info=False;user id=sa;Password=noway.in;"/>
  </appSettings>
</configuration>

and can be read like this

ConfigurationManager.AppSettings("ConnectionString")