Click here to Skip to main content
15,888,044 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i have 5 database with same table.i have situation like i have one login form in that we have to select Company Name from dropdown that company information like name userid password and other fields are taken from other database and other fields in login form are branch name,financial year, username, password that are verify by other database.Now first user select the company name then it verify the company name by using connection string by using userid and password after that it go to verify the all other fields from database. how to connect multiple database how to verify the connection string from dropdown.and after that all other field access the other connection field

What I have tried:

creates the connection string in web.config
Posted
Comments
AnvilRanger 30-Jun-16 12:29pm    
That is a very bad design for a db back-end for an application. You really should reconsider what you are attempting to do. For example if all 5 dbs have the same tables why not user just one db and integrate something like a Company table to differentiate the needed data.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900