Need to change connection string every time

Question

I build a register but every time I move pc, I need to change the string connection.

This is my code: http://pastebin.com/3CN3TmdB

How can I not have to change the data source every time I'm changing computer? If anyone could help me, that would be great! Thanks for any help.

This is my connection string:

string connection = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Gal\Desktop\WebApplication2\WebApplication2\App_Data\MyDB.mdf;Integrated Security=True;User Instance=True";

Why would you need to change the connection string on every computer? — Oded
– Oded, Commented Jun 22, 2013 at 10:01
You can investigate if |DataDirectory| can help you. See this question — rene
– rene, Commented Jun 22, 2013 at 10:02
Beacuse of this: C:\Users\Gal\Desktop\WebApplication2\WebApplication2, in every pc, its diffrent — Gal Israel
– Gal Israel, Commented Jun 22, 2013 at 10:06

Erik Schierboom · Accepted Answer · 2013-06-22 10:06:16Z

2

You should use the |DataDirectory| placeholder:

string connection = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MyDB.mdf;Integrated Security=True;User Instance=True";

.NET will replace the value of |DataDirectory| at runtime with the path to your App_Data folder.

answered Jun 22, 2013 at 10:06

Erik Schierboom

16.7k10 gold badges67 silver badges82 bronze badges

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

1 Comment

Erik Schierboom Over a year ago

You should use |DataDirectory| as that is standard way of dynamically pointing to your App_Data folder in .NET connection strings.

Ibrahim Attia · Accepted Answer · 2013-06-22 12:33:32Z

1

you can put connection string in a seperate file you can use udl file steps for use udl: 1-create text file 2-change the extension of text file to .udl 3-open udl file and choose provider then connection parameters 4-save and close file

in c# code you can refer to this file string connection = @"File Name=myudlFileName.udl";

answered Jun 22, 2013 at 12:33

Ibrahim Attia

914 bronze badges

Collectives™ on Stack Overflow

Need to change connection string every time

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related