Update Connection String in Web.Config file periodically from Code Behind in ASP.Net

Question

HiI have a aspnet web application installed in the server The client updates the sql server credentials every 6 months Due to this reason i have manually update the connection string in the webconfig file for the application to function Is there a solution to thisHow to avoid manual edit sql server credentials in webconfig fileThanks

dharmendr · Accepted Answer

Hi hendrix169There is no solution to this You need to update the connection string manually in the webconfig fileYou can also update the connection string from code behind as wellAdd a page in which you need to provide all the details the required for updating the Connection StringFor this refer below articleChange Modify connection string in WebConfig at Runtime in ASPNet using C and VBNet

Update Connection String in Web.Config file periodically from Code Behind in ASP.Net

Change (Modify) connection string in Web.Config at Runtime in ASP.Net using C# and VB.Net

Company

Explore

Follow us

Contact Us