web config set connection string from install

[KRaymond]

I want to change the server and the database in the web.config connection string based on what the user selects from the SQL Dialog.

[banna_k]

Hi @KRaymond,

Try using  "XML File Changes" view to configure the web config file

OR  

try with a custom action to update the web config file.

[KRaymond]

Thanks for the reply banna_k.  I have looked at both approaches.  I need to know where info is stored from the install when they select the SQL Server and the Database name.  Any examples would be great.

[banna_k]

Hi @KRaymond,

Each field in the dialog is bound with a property, you can use the property name to  retrieve the value later.  You can get the property names by exploring the dialog editor 

In case of SQL server, you can use [IS_SQLSERVER_SERVER] to get the value of IS_SQLSERVER_SERVER property.