How to append quotes

[G12Consult]

I am trying to add " to my string so that I can use it in a connection string.

Not sure how or where to add it.

 Dim strConnectionString As String strConnectionString = Session("connectionString") e.g. returns TENANT_1432]

but it needs to be "TENANT_1432" to use in the code below.

 'Start Login Authentication 
Dim constring As String = ConfigurationManager.ConnectionStrings(strConnectionString).ConnectionString]

 

[jbenson001]

I am not sure why you would need quotes around the value. Maybe you could explain further. But to answer your questions you could do this:

​

Dim constring As String = '"' + ConfigurationManager.ConnectionStrings(strConnectionString).ConnectionString] + '"'

If you can't read it '"' = single quote, double quote, single quote

 

[G12Consult]

I am trying to dynamically select a database depending on who is trying to log in.

I have the database connections stored in a config file, so I just need to dynamically populate the connection string name

 

[xwb]

If this is VB, ' is a comment so '"' will not work. Use "" (2 double quotes) instead