Sir actually iam a new bee in .Net
iam unable to understand the process flow and i see u r adding a connection string after that modifying it
iam adding a connection string in one page and changing it in another page.
since iam using code before iam loging into application i want to change the databse after i log into application .. since i cant use sessions becouse i may change it after a long time.
i need to get the server details from my connnection string and change the database.
so please can u help me in modifying the connection string ... using this code.
Example :
Dim connectionStringBuilder As New SqlConnectionStringBuilder()
Dim connectionStringBuilder1 As New SqlConnectionStringBuilder()
'Creating New Connection String from User Interface !!!
'Using SQL Authentication
connectionStringBuilder.DataSource = server1
connectionStringBuilder.UserID = uid
connectionStringBuilder.Password = pwd
connectionStringBuilder.InitialCatalog = dbname1
'ConnectionString property will give us the final connection string
' connectionStringBuilder.ConnectionString
connectionStringBuilder1.DataSource = server1
connectionStringBuilder1.UserID = uid
connectionStringBuilder1.Password = pwd
connectionStringBuilder1.InitialCatalog = "master"
Dim connectionStringBuilder2 As New SqlConnectionStringBuilder()
connectionStringBuilder2.DataSource = server1
connectionStringBuilder2.UserID = uid
connectionStringBuilder2.Password = pwd
connectionStringBuilder2.InitialCatalog = dbname2
'Dim connections As ConnectionStringsSection = DirectCast(cfg.GetSection("connectionStrings"), ConnectionStringsSection)
If connections.ConnectionStrings("SoftAssetMgmtConnectionString") Is Nothing Then
connections.ConnectionStrings.Add(New ConnectionStringSettings("SoftAssetMgmtConnectionString", connectionStringBuilder.ConnectionString))
connections.ConnectionStrings.Add(New ConnectionStringSettings("mastersam", connectionStringBuilder1.ConnectionString))
connections.ConnectionStrings.Add(New ConnectionStringSettings("2databaseconstring", connectionStringBuilder2.ConnectionString))
Else
connections.ConnectionStrings.Remove("SoftAssetMgmtConnectionString")
connections.ConnectionStrings.Remove("mastersam")
connections.ConnectionStrings.Remove("2databaseconstring")
connections.ConnectionStrings.Add(New ConnectionStringSettings("SoftAssetMgmtConnectionString", connectionStringBuilder.ConnectionString))
connections.ConnectionStrings.Add(New ConnectionStringSettings("mastersam", connectionStringBuilder1.ConnectionString))
connections.ConnectionStrings.Add(New ConnectionStringSettings("2databaseconstring", connectionStringBuilder2.ConnectionString))
End If
webConfiguration.Save()
ConfigurationManager.RefreshSection("ConnectionStrings")