Code in App.Config

  • Thread starter Thread starter Lora Connors
  • Start date Start date
L

Lora Connors

The location of my Access database is "c:\lora\lora.mdb".
I'd like to declare a Common Variable that can store the
Connection String values for a Database. But, I'm not
sure about the code to be written in the App.Config.
Also, how do I bind it at run time using code?
Thanks!
 
Hi Lora,

Example:
<configuration>
<appSettings>
<add key="connectionString" value="data source=myserver;initial
catalog=Apps;Integrated Security=SSPI;packet size=4096" />
</appSettings>
</configuration>

Either bind it at design time (DynamicProperties) or access it using

(C#)
string conn =
System.Configuration.ConfigurationSettings.AppSettings["YourConnection"];
(VB.NET)
Dim conn as String =
System.Configuration.ConfigurationSettings.AppSettings("YourConnection")
 
Back
Top