Connection String in WinForm App

From Logic Wiki
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")