Ahh the app is finished. Now the fun part. I have a windows app that stores connection string and other system dependant info in the app.config file. My question is, how do I modify the app config file during installation. An example would be prompting a user for server name, Username, and a Password during setup.

I realize I should not be using impersonation to connect to my database and should be using windows authentication but this is an app upgrade and I have no choice in the matter.