Connect string reading password from config file or database ?

hello,


I have a connect string to connect to MS SQL server which using UserID and Password.

Because we need change password once a while that I need update my source code and rebuild and publish every time I change password. I just wanted to know if it is password to read from config file or any text file or database to update the connection string

The connection string like following

<add name="MyApp.My.MySettings.MyAppConnectionString" connectionString="Data Source=MyServer;Initial Catalog=MyDatabase;User ID=MyUser;Password=MyPassword"
providerName="System.Data.SqlClient" />



Please help.
Thanks!


I didn't find the right solution from the Internet.



References:
https://social.msdn.microsoft.com/Forums...alstudiogeneral



brilliant brand Video