Enable Database connection change

[redivider]

I have an application that I setup by adding a DataSet .xsd file to my project and then dragging tables from the Server Explorer data connections area. This automatically sets up the connection string in about a dozen places. Now I want the user to be able to point to the database they want to use, but I'm not sure where the connection needs to be updated. The connection string exist in the main solution's Properties\Settings.settings, Properties\Settings.designer.cs In the data access layer project's app.config Properties\Settings.settings, Properties\Settings.designer.cs How would i update this value? From where (and how) should i read it when the app starts up, or if its being updated programatically would i have to save it to a custom file and read if from there?