"It depends on when you set your $_SESSION['section'] variable. Before the user logs in, you do not know who he/she is. So when the user logs in, you are still using the default database. After login, you can set your session variable (e.g. using User_Valdiated server event), then you can use Database_Connecting server event to check your session variable and change the connection info accordingly for subsequent pages."
The above clipping is from another post. How do we really implement this in asp.net? Is there any sample code for this? How do we connect another database after a user is validated.
Kind regards
Zam