Hai thankz alot
I have written my code to add or update a connectionstring in web.config
but it is working fine in local system but .
and not getting reload or saved when i keep it in IIS
can u please check the code.
Dim connectionStringBuilder As New SqlConnectionStringBuilder()
'Creating New Connection String from User Interface !!!
'Using SQL Authentication
connectionStringBuilder.DataSource = server
connectionStringBuilder.UserID = uid
connectionStringBuilder.Password = pwd
connectionStringBuilder.InitialCatalog = database
'ConnectionString property will give us the final connection string
' connectionStringBuilder.ConnectionString
Dim webConfiguration As Configuration = WebConfigurationManager.OpenWebConfiguration(Request.ApplicationPath)
'Dim connections As ConnectionStringsSection = DirectCast(cfg.GetSection("connectionStrings"), ConnectionStringsSection)
Dim connections As ConnectionStringsSection = webConfiguration.ConnectionStrings
If connections.ConnectionStrings("SoftAssetMgmtConnectionString") Is Nothing Then
connections.ConnectionStrings.Add(New ConnectionStringSettings("SoftAssetMgmtConnectionString", connectionStringBuilder.ConnectionString))
Else
connections.ConnectionStrings.Remove("SoftAssetMgmtConnectionString")
connections.ConnectionStrings.Add(New ConnectionStringSettings("SoftAssetMgmtConnectionString", connectionStringBuilder.ConnectionString))
End If
webConfiguration.Save()
wat i need to do inorder to save the connection string in web.congfig
