Changing the connection string on multiple forms

Question

I have multiple forms in my project. Sometimes I work on my laptop, sometimes I work on my desktop. The problem is, when transferring my project from laptop to desktop and vice versa, I must change my connection string on all forms in the project.

This is my connection string. I declared it globally.

Dim CN As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=D:\Documents and Settings\Adriane05\Desktop\ThesisDB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True")

How can I change a single file without changing it on all forms?

If I understand the question correctly, Ronnie's problem is that the string has got a local directory path. An obvious solution would be to use a path that exists on both computers? — user1725145
– user1725145, Commented Nov 11, 2012 at 8:07

Origin · Accepted Answer · 2012-11-11 08:07:37Z

4

There are a few ways you could accomplish this. First is you could map your project folder to the same drive letter on all your computers so your connection string wouldn't change. I do this by default because my projects are on a drive that I encrypt with TrueCrypt

Another way is a simple code pattern. Store your connection string in a setting or global variable, and run something like this when your application loads:

if Environment.MachineName.Equals("laptop") then
    connectionString = ' Connection string 1
ElseIf Environment.MachineName.Equals("desktop") then
    connectionString = ' Connection string 2 
else
    connectionString = My.Settings.ConnectionString
End If

databaseProvider.Open(connectionString)

answered Nov 11, 2012 at 8:07

Origin

2,03315 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ronnie Adriane Baetiong Over a year ago

Thanks! sorry for the dumb question. Thx for this! now i can transfer my project from any computer :D

JohnB · Accepted Answer · 2012-11-11 08:06:28Z

1

Declare a global variable (or constant) somewhere and replace the statement mentioned in your post by

Dim CN As New SqlConnection(NameOfGlobalVariable)

?

answered Nov 11, 2012 at 8:06

JohnB

13.8k6 gold badges42 silver badges67 bronze badges

Comments

NeverHopeless · Accepted Answer · 2012-11-12 06:44:31Z

1

I would suggest to move connection string in config file. See these tutorials:

Store connection string in config

Connection Strings and Configuration Files

answered Nov 12, 2012 at 6:44

NeverHopeless

11.2k4 gold badges37 silver badges56 bronze badges

Collectives™ on Stack Overflow

Changing the connection string on multiple forms

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related