How to Change database connection at runtime in a Windows Forms application

Question

How to Change database connection at runtime in a Windows Forms application ? Thank you

Satyapriya Nayak · Answer

Hi Samio Please refer the below link http://www.c-sharpcorner.com/UploadFile/1a81c5/configuring-connection-string-in-app-config-file-during-runt/ Thanks

Jignesh Trivedi · Answer

hi If your Connection String is in app.config file then you can change it run time. Basically app.config is xmll file so you can read it select node and also change and rewrite. please read http://social.msdn.microsoft.com/forums/en-US/winforms/thread/e89b0402-12cf-4f24-8e7f-ec449aab75f6/ In this blog has idea to save connection string in setting file and change it run time. hope this help.