Hi all

I have made a web application where I have multiple user databases. On my Default page I have a Dropdownlist and each selection presents a user database. I have a custom membership provider and I could load the Login user control with the appropriate membership provider set. But the ting is: I don't want to set multiple connectionstrings i my web.config, and I don't want to create an application for each db.

I want to get the db name, pwd etc. from a database and then create the connectionstring when the selection has been made or in the LoggingIn event handler. I guess the only solution is to write a class that gets the db name and pwd from the database, decrypt it in some way and create the connectionstring.

I just wonder if anyone has any thoughts on how to do this in a way that doesn't create any security issues.

Best Regards

What is issue for not creating multiple connectionstring. They are the only string value at all.If u store dbName ,loginName and password in any table of db,u need to each time to fetch that data from table.

Bijgupt