C# Change Connection String upon deployment

Hi,

I have built an WPF application. The application connects to SQL Server to retrieve some data. I wish to deploy my application on a friend’s computer. I have the exe file along with the msi file. I have a connection string in my settings.cs file that connects to my database, however my friends database will be in a different location to mine. What I would like to know is the best way to change the connection string when my friend goes to install the program on his computer?

Thanks for any help,
M