Yeah I've got something like this. My app is used in 3 locations, UK, Australia and Thailand, so I have a splash screen asking the user what location they are in.
This will work if when you first made a connection to your server, you said to keep the connection string stored in your app to use for all connections.
Firstly you need to change the connection from Application to User, and from (Connection String) to String.
To-Do
a) open My Project and click the Settings tab
b) copy the connection string (all of it) that appears as the Value
c) drop down Scope and change to User
d) drop down Type and change to String
e) delete everything that appears in Value, and paste your connection string from (b)
Now you've got this, there is something to note
DO NOT EDIT YOUR DATASET(s) that use this connection!!!!
If you need to add a new DataTable, or edit one, or create a new query etc etc, you need to go back to My Project Settings and change the Type to (Connection String), and set the value to your saved string again.
Once done, press Synchronise up the top and save.
You can now edit your dataset(s). If you accidently try to make a change without changing the connection string back, you'll get an error. Close the dataSet designer and say NO to save changes. Close Visual Studio and reopen.
With that out the way, and Type set to String, you can now set your connection string in code.
On my splash screen I have 3 radio buttons in a group box. The code is set so that (only showing relevant code);
If Me.rbAustralia.Checked = True Then
My.Settings.SalesNPDConnectionString = "Data Source=UK-BAN-APP1;Initial Catalog=SalesNPD_Aus;Integrated Security=True"
ElseIf Me.rbUK.Checked = True Then
My.Settings.SalesNPDConnectionString = "Data Source=UK-BAN-APP1;Initial Catalog=SalesNPD_UK;Integrated Security=True"
ElseIf Me.rbThailand.Checked = True Then
My.Settings.SalesNPDConnectionString = "Data Source=UK-BAN-APP1;Initial Catalog=SalesNPD_Thai;Integrated Security=True"
End If
All 3 databases are on the same server. All 3 have EXACTLY the same schema in terms of table names and table column names.
The only change is the data, which is relevant to each site.
The splash screen just sets the correct database. The code above is condensed down, I actually go further and use Active Directory groups to define who from each location can view the other locations.
That hopefully should get you started, as I say the one thing to be wary about is editing datasets after changing the connection Type.
good luck
