How to track and load a specific user's information?

Question

I'm making a small portal in ASP.net (with C#.net4) where users can login and add, edit their personal information (PI). But I don't get how to load information (stored in a SQL server DB) in the page when a specific user is logged in.

For example: If Sam is logged in, he can view his PI. When Vicky is logged in, she can view her PI.

who can help me with this?

thanks in advance.

Answer 1

You need to retain the ID of the logged in user in a session variable and then use it to filter the query with which you fetch each user's info.

So if a user's ID is 278 then your query would run as:

SELECT first_name, last_name, * FROM user_table WHERE user_id = 278

From a session variable stored like:

Session["UserId"] = currentUserId;