Connection

  • Thread starter Thread starter Jun
  • Start date Start date
J

Jun

Hi,

I'm a new vb.net developer, before, I'am using BDE(Borland
Database Engine) for my database application.
In BDE you only change the servername/ip address to point
where the database location is. Now in vb.net connection
string there's a lot of variations, I'am thinking of using
a global variable using ini file, or registry for the
setting of the server, etc.

Is there a standard or recommended approach for this
matter? Can you reccomend any recources, articles, etc.

Thanks in advance.

Jun
 
Hi Jun,

You might put your connection string inside app.config file, 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