How to set connection string during installation of Windows Form Application

Hi gokuldas,

Refer the below links.

1. http://stackoverflow.com/questions/9208442/change-app-config-during-installation
2. https://social.msdn.microsoft.com/Forums/vstudio/en-US/157962d7-d948-47d4-9eb0-be09e9973e7b/change-appconfig-applicationsettings-during-install?forum=vbgeneral

Your connection string look ok. If your in same network then u need to go to SQL Server Configuration Manager-> SQL Server Network Configuration-> goto Protocols for SQL and Enable TCP/IP

then it will work.

Thanks

Basit.

Hi gokuldas,

This can be done in the setup file. It's possible to add a new screen and the user could insert the connection string himself.

It's also possible to add code at the end of the setup that could read a file (bundled with the setup) that can contain the connection string.

In all the cases, the .cs should be in the app.config not directly in the application code.

Refer the below links.

http://www.codeproject.com/Tips/446121/Adding-connection-String-During-Installation

https://wlasson.wordpress.com/tutorialscode/net-20-windows-installer-and-the-connection-string-c/