I have now looked at hundreds of articles and forums for solutions.
I have the following forms:
A db selector form. The form has a combobox where I want to load the connections(connection name) you want to use to connect to a sql database. I need the user to be able to have multiple connections. I have a "Add" button on the form tha opens another form when clicked. This second form(Connection Add) has five fields: Connection Name, Server Name, Database NAme, User and Password. Here the user can add the connection details which will be used to build the connection string for the new connection. Once the details are entered a OK button is clicked to save the details.
I can save this to the database, but as the application hasn't connected to a database yet and I would not like to have a table to only save connections strings, this is not the option for me. I found a lot off articals on the connectionstring settings in the app.config file, but this is read only.
The other view is to create your own xml file. I am not to confident in working with xml. I can create a doc from scratch, but how do you add to it and how do you update a selected connection and retrieve the details based on a selected connection.
Any help would be appreciated. I am using Visual Basic 2005 Express with both SQL 2000 and SQL 2005