Changing the connection string from a form

[claire_bicknell]

I am sure this is fairly simple.

I have created a basic form and i would like it to be capable of changing the connection string from just this one form and it show throughout the project (on all other forms).

My connection string is currently this:

Const strConnection As String = "Data Source=PC-CLAIRE;Initial Catalog=ShoppingCentre;Integrated Security=True"

If i was to run this project on a different pc, it would fail at run time because it is linked to my home pc.

In my scenario I have an administrator which can change this connection string on a form in my project and this will then change the connection string accordingly on all forms in my project to the updated version.

Does this make sense? I found it hard to word.

Any help much appreciated. Thanks

 

[MattP]

Using Data Source = (local); : ADO.NET Data Providers : Data Platform Development : MSDN Forums

 

[claire_bicknell]

So to clarify...

by setting the Datasource = (local)

this allows me to open this on any computer and still find my database without any errors and without having to manually change the datasource each time it is run on a new pc?

Before my datasource = PC-Claire which was restricting me to my home pc only. I have understood correctly?

Thanks for your quick response