Examples of storing user info from db in profiles?
Hello - I have to go get a user's business account number from a database table, based on their login ID, and save that away to filter everything they do during a session (involves very sensitive financial info; has to be very secure).
I see examples for storing info in a user profile, but they all get the values from manual inputs from the user.
I also get the impression that trying to save the user ID from the LoggedIn event of a Login control is too soon, as Membership.GetUser() is not valued yet.
Can anybody point me to some examples of getting the logged-in user's ID, using it to lookup additional info in a database table, and saving it all in a profile (or session variables?)
(or, if there is a better/more secure way to do this, please clue me in...)