How to change database in runtime??

I am using VS2005 and SQL 2005.
If I change connection string in AppConfig in runtime the app needs to be restarted to connect to new database.
Databases are completly the same schema but with different amount of data.
Strong type tableadapters do not have connection string property exposed.

So how to change active database in runtime??
Who is Participating?
Strong typed tableadapters does have connectionstring exposed: tableAdapter.Connection.ConnectionString
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.