How to change connection string dynamically across ALL pages in VS.NET?[Resolved]

[aspfan]

Hi,
I have many ASP.NEt pages. I use the SQLConnection from the toolbox.
I move my project from one PC to another.

Now, i need a way to dynamically change the conenction string for the SQLConnection across all the pages in my project.

Who has methods to my problem?

[mendhak]

Store it in web.config.

[aspfan]

Store it in web.config.

Is that the only step.
I think i also need to "map" the SqlConnection in each of the page to the setting in web.config right?

How do i achive that ?

[aspfan]

Ok, i have solved it. thanks mendhak.
BUT, is there a piece of code or software that could help me change the connection string in web.config ?

My idea is, I have a project build on machine A.
I want to deploy that project on machine B.
So, i need to change the connection string of the project if the project was to be hosted on machine B.

Is there easier way to accomplish this?

Thanks for ur time

[mendhak]

That's about as easy as it gets and is one of the most widely used methods.

[aspfan]

That's about as easy as it gets and is one of the most widely used methods.

Alright.
Thanks for your help. You save a lot of my time.