im about to finish a winform app for a client and I was wondering about the most common ways to handle connection strings. I know you can change the path from within appConfig to whatever the path may be on the destination server but are there any established approaches to allowing the user to define the path themselves at some point?

If for example the user wanted to move the database to another machine, is it the standard aproach that they would have to go into the source code and redefine the string?

many thanks