ADO.Net Best way to run a procedure once after user authentication

Question

I have a procedure that has to be run once when a user logs into my asp.net website. The closest event that i could find is the LoggedIn event on my login control, however i cannot use this as it is not able to find the UserId of the currently logged in user yet.

So, what is the best way to run a procedure once after a user is authenticated?

There is no OnAuthenticate event on the asp.net login control sadly. — Cinedine, May 01 '14 at 13:31
How exactly can i use the Session_start from global.asax to run my procedure? I cannot call it. — Cinedine, May 01 '14 at 13:56

score 0 · Answer 1 · answered May 01 '14 at 13:28

0

Maybe try a page refresh after login then run a function on page load looking for "if userid=not null run stored procedure".

answered May 01 '14 at 13:28

user3570283

13
5

Good idea, but i cannot use this. My Procedure writes a new record to the database everytime. if i set userid=not null it will never run. – Cinedine May 01 '14 at 13:34

score 0 · Answer 2 · answered May 01 '14 at 13:33

0

you can get the user yourself in onLoggedIn

MembershipUser user = Membership.GetUser(LoginControlName.UserName);
// then do stuff with the user.

answered May 01 '14 at 13:33

gorrilla10101

394
1
8

ADO.Net Best way to run a procedure once after user authentication

2 Answers2