Multiple Connection from Config File
Config File Change
;Data Source=MyPC\Sql2008" />
" 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
Post a Comment