VB.NET relative path connection string

Question

I need to make this connection string into a relative path so I can move my program from PC to PC without having to change the connection string every time. This is what I have in VB.NET:

 con.ConnectionString = "Data Source=(LocalDB)\v11.0;AttachDbFilename=""C:\Users\Chris\Desktop\Newfolder\PizzaEmporium.mdf"";Integrated Security = True;Connect Timeout=30"

I get kind of lost on some of the examples from the Internet.

Robert Anderson · Accepted Answer · 2014-09-05 03:36:47Z

1

Dim Path As String = Environment.CurrentDirectory

Dim con As String = "Data Source=(LocalDB)\v11.0; AttachDbFilename=" & Path &
  "\PizzaEmporium.mdf;Integrated Security=True;Connect Timeout=30"

edited Sep 5, 2014 at 3:36

answered Sep 5, 2014 at 1:32

Robert Anderson

1,2568 silver badges11 bronze badges

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

1 Comment

Trevor Over a year ago

Strings concatenation should use the" &" to concate, just a thought.

Peter Mortensen · Accepted Answer · 2015-10-08 18:43:29Z

0

Get the path of the current directory with:

 Dim path As String = Environment.CurrentDirectory

edited Oct 8, 2015 at 18:43

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Sep 5, 2014 at 1:31

Cory

1,28316 silver badges32 bronze badges

Collectives™ on Stack Overflow

VB.NET relative path connection string

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest