I'm trying to figure how what the "best" way is to store and retrive the SQL Server connection information. Right now I have the connection strings hard coded and the login page has two buttons. One is for the the dev server and the other one is for the test server. This application will be deployed to individual customer sites, thus the sql server connection information will vary from site to site. Once I deploy the user will have the option of logging into a production database or a training database, depending on the choice, the database name is different and could actually be on a different physical server. I'd like to have the login page have a drop down that was filled with choices from a configuration file. I'm thinking it could be an xml file, but I don't know how to read the xml file and use it as a datasource for a downdown list. I'm sure that's possible though. Using this approach, the the server name/IP could be stored in a session variable for future use.

Thanks for any advice or tips.

Kirk