Posted on: 12/24/2014 7:52:25 AM | Views : 471

Hello All,

I have a Scenario where i need to connect different databases while login. There are many branches the company has. And in Every branch they have there own database. In My Asp.Net Express Database i have a Branch table which has all connection strings of all the databases with IPAddress.  When The user opens the login form it provides a Dropdown list for connecting different branches. as shown Below.
The Sql Express Database Table which is in my Application App_Data Folder.

This is how i am validating the user. First i am getting the connection string from the local database based on the users selection. Then I am storing it in Session and Working with it.


Till now its working fine ...

Go to the complete details ...