Access web.config file from a web service
-
How do I access a web.config from my web service I need to grab the connection string of one of many data basis Regards:confused:
Access it the same way you normally would, ConfigurationManager.ConnectionStrings
only two letters away from being an asset
-
Access it the same way you normally would, ConfigurationManager.ConnectionStrings
only two letters away from being an asset
-
This What I have done It works fine But I need to get only the one from the default web.config file. Dim the_string_final As String = "" Dim the_string_temp As String = "" Dim counter As String = 0 Dim connectionStrings As ConnectionStringSettingsCollection = _ WebConfigurationManager.ConnectionStrings Try Dim connectionStringsEnum As IEnumerator = _ connectionStrings.GetEnumerator() Dim i As Integer = 0 While connectionStringsEnum.MoveNext() Dim name As String = connectionStrings(i).Name Debug.WriteLine(name) Debug.WriteLine(connectionStrings.Item(i).ConnectionString) counter = counter + 1 the_string_temp = "****Number: " + counter + " '" + connectionStrings.Item(i).ConnectionString + "'" + "NAME: " + name the_string_final = the_string_temp + the_string_final i += 1 End While Return the_string_final Catch ex As Exception End Try Return the_string_final The output: ****Number: 2 'Data Source=(local);User ID=sa1'NAME: SL2010WSConnectionString****Number: 1 'data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true'NAME: LocalSqlServer
-
This What I have done It works fine But I need to get only the one from the default web.config file. Dim the_string_final As String = "" Dim the_string_temp As String = "" Dim counter As String = 0 Dim connectionStrings As ConnectionStringSettingsCollection = _ WebConfigurationManager.ConnectionStrings Try Dim connectionStringsEnum As IEnumerator = _ connectionStrings.GetEnumerator() Dim i As Integer = 0 While connectionStringsEnum.MoveNext() Dim name As String = connectionStrings(i).Name Debug.WriteLine(name) Debug.WriteLine(connectionStrings.Item(i).ConnectionString) counter = counter + 1 the_string_temp = "****Number: " + counter + " '" + connectionStrings.Item(i).ConnectionString + "'" + "NAME: " + name the_string_final = the_string_temp + the_string_final i += 1 End While Return the_string_final Catch ex As Exception End Try Return the_string_final The output: ****Number: 2 'Data Source=(local);User ID=sa1'NAME: SL2010WSConnectionString****Number: 1 'data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true'NAME: LocalSqlServer
I Have tried this as well and no luck Dim rootWebConfig As System.Configuration.Configuration rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(Nothing) Dim connString As System.Configuration.ConnectionStringSettings If (0 < rootWebConfig.ConnectionStrings.ConnectionStrings.Count) Then connString = rootWebConfig.ConnectionStrings.ConnectionStrings("MyString") If Not (Nothing = connString.ConnectionString) Then Console.WriteLine("Mystring = {0}", connString.ConnectionString) Else Console.WriteLine("Mystring") End If End If
-
WebConfigurationManager.ConnectionStrings["Default"].ToString()
only two letters away from being an asset
-
WebConfigurationManager.ConnectionStrings["Default"].ToString()
only two letters away from being an asset
-
Hi Mark This works Dim the_string_final As String = WebConfigurationManager.ConnectionStrings("SL2010WSConnectionString").ToString() Thanx Ok now next question, How do I edit this field in the web.config file?
HI I tried this Dim Config As System.Configuration.Configuration = WebConfigurationManager.OpenWebConfiguration("/SL2010WS") Dim csSettings As New ConnectionStringSettings("SL2010WSConnectionString", new_string) Dim csSection As ConnectionStringsSection = Config.ConnectionStrings csSection.ConnectionStrings.Clear() Config.Save(ConfigurationSaveMode.Modified) Return (new_string + " was saved to web.config") As soon as I try to save the file then the VS tells me I do not have access to this file. I checked but the file is not read only :confused: