Multiple Connection from Config File




Config File Change






    AppDB_1
;Data Source=MyPC\Sql2008" />
    AppDB_2
" connectionString="Password=123456;Persist Security Info=False;User ID=sa;Initial Catalog=AppDB_2;Data Source=MyPC\Sql2008" />

  


Front End Change

Dim strConnection As String = System.Configuration.ConfigurationManager.ConnectionStrings("AppDB_1").ToString
cnAppDB_1 = New SqlClient.SqlConnection(strConnection)
cnAppDB_1.Open()

System.Configuration.ConfigurationManager.ConnectionStrings("AppDB_2").ToString
cnAppDB_2 = New SqlClient.SqlConnection(strConnection)
cnAppDB_2.Open()

Comments

Popular posts from this blog

Shared / Static Class in vb.net/C#

Xamarin Forms : PopUp Page with RG.Plugins.Popup

Text was truncated or one or more characters had no match in the target code page.". (SQL Server Import and Export Wizard)