Store the connection string in your
project settings.
What I like to do is store several connection strhings in the project settings, then have another setting that indicates which of those settings to pick from. Makes debugging easier, as you can switch connection strings without having to store them somewhere else.