Using Session variable in ASP.NET 1

[fdarkness]

Due to the way my server is set up, I have a session variable set to identify a user when they go onto the site (it's an internal only website).

In the global.asax page, I have:

Session["CISUserID"] = Request.Form["UserID"];

in the Session_Start method. It appears to work fine (tested it with an output statement).

Now I'm trying to call the session variable in a SELECT statement and I'm getting an error that says "CS0103: The name 'Session' does not exist in the current context". From what I read, this means that I haven't declared it, but I wasn't aware I needed to declare a Session variable. Is that the case? If so, where do I declare it?

The code that is causing the error is:

  comm.CommandText = "SELECT SystemUsers.UserID, SystemUsers.TeamID, NTLogon, " +
  "DevLogon, LastName, FirstName, Email, Transit, " +
  "SystemManagers.UserID, Manager, StartDate FROM SystemUsers, " +
  "SystemManagers WHERE SystemUsers.ManagerID = " +
  "SystemManagers.ManagerID AND NTLogon = " + Session["CISUserID"];

It's the last line that causes the error code to show up.

 

[tperri]

If you aren't on a Page, then you need to make a reference to the HttpContext.

So you'd say HttpContext.Current.Session["CISUserID"].ToString()

 

[fdarkness]

You are wonderful! Thank you thank you!!!

 

[tperri]

You're welcome