Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting
Views: 1502 | Replies: 3
 |
•
•
Join Date: Mar 2007
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Get a Session state from a Query HI
I was wondering if anyone knew of a way to store a session state variable from a Query based on information in an access database
What i want to do is when the user logs in they supply their email address and password to log into site I want to store their CustomerID as a Session Variable to track them as they use the site, is this possible
Thanks
I was wondering if anyone knew of a way to store a session state variable from a Query based on information in an access database
What i want to do is when the user logs in they supply their email address and password to log into site I want to store their CustomerID as a Session Variable to track them as they use the site, is this possible
Thanks
•
•
Join Date: Jan 2005
Posts: 33
Reputation:
Rep Power: 4
Solved Threads: 0
Light Poster
Yeah it is possible the best thing to do is connect to a database using the datareader potentially then read and compare fields until you find the one you want. Once you find the user you need add it to a Session variable.
If you are wanting to track where they have been and are entering it into the DB then you will need to on page load just do an insert into the DB of the current page they are on.
Not sure what you are wanting but that is the genearl idea how to do it. I usually don't ever use an access database so i can't help you with that.
If you are wanting to track where they have been and are entering it into the DB then you will need to on page load just do an insert into the DB of the current page they are on.
Not sure what you are wanting but that is the genearl idea how to do it. I usually don't ever use an access database so i can't help you with that.
•
•
Join Date: Jan 2007
Posts: 7
Reputation:
Rep Power: 0
Solved Threads: 1
Newbie Poster
When a user logs in i just get his/her details from the database and store the ones i need in a Session. eg..
(rs = my record set)
Session("ID") = rs("ID")
Session("login") = "true"
Session("type") = rs("membertype")
To track the users actions just do what percent20 said.
(rs = my record set)
Session("ID") = rs("ID")
Session("login") = "true"
Session("type") = rs("membertype")
To track the users actions just do what percent20 said.
•
•
Join Date: Jan 2006
Location: Its the internet... i am everywhere lol
Posts: 274
Reputation:
Rep Power: 3
Solved Threads: 11
Posting Whiz in Training
dont you use the built in memebership providers? all the information is done for you. When a user is logged in and you need to know their information at any time just call Membership.GetUser() and it will return the current logged in user who made the request. It caches it too if you call it more than once in the page. Then you can use the profile provider too.
Much more powerful and easier to use than roll your own
Much more powerful and easier to use than roll your own
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
