Author: djs25uk | Posted on: 7/28/2010 12:27:29 PM | Views : 415

Dear All
I had a similar problem with this yesterday and someone helped me (which was great)  but I'm not really understanding what's going on and wondered if you can help me understand as I think it's going to come up in my code again and again.
I'm building an application that will be used by a number of different schools who want completely separate databases so I've decided to have multiple connection strings and membership/role providers in my web.config file. In my code, I'm trying to set which connection string and provider to use at runtime for the correct database according to the logged in user.
I'm coming into a lot of bits in my code that previously worked fine, that now don't. For example, I used to use:
Dim rolebox As ListItem For Each rolebox In UserRoles.Items If rolebox.Selected Then Roles.AddUs ...

Go to the complete details ...