Hi,

I recently built a ASP.NET application with security features (form authentication against a sql server 2000 username/password table) it works fine. However, there is another table containing information specific to the authenticated user. I set up a datagrid that shows me this information but I want to be able to filter this information for this user so that he/she see only data related to his user account immediately after logging in.
How can I pass the password from the login page to the sql statement for the datagrid?

I know I have to use session states but I'm not too sure how to implement them. Can someone point me to an example? I'm trying to figure out how to correctly write the global.asax page and the web.config file, and also what directive is required on each web page of my application. I'm somewhat of a newbie so forgive me if all of this sounds elementary.

thank you

Set the session in the login page and use that session value for filtering the information.

Eg.Session["username"]=txtUserName.Text; in the login page set the session like this..
 And for query select * from tbl where username=Session["username"];

Thank you. I'll give it a try!