Click here to Skip to main content
13,090,930 members (47,719 online)
Rate this:
Please Sign up or sign in to vote.
See more:

I am developing a project where I use the database of the aspnet membership to my login, assign roles, etc..
my idea is to develop an area to audit my system where I need to know and record the following: when User login to the system, must save the day and time that this started, and do logof also need to take the day and time of output to be stored in a database.
the body of my table, I'm thinking this way:

id_auditoria (int) autoincrement
id_user FK(User of membership)
login datetime
logof datetime

I want this system through a Stored procedure, capable of catching and storing login date, and end to catch logof date and save too. I will use this table to check which user a certain day and time he accessed the system and see how long he was inside of it, just to control ...

appreciate some ideas ...
Posted 12-Jul-13 13:42pm
dholakiyaankit 12-Jul-13 23:43pm
you have to do a lot for this one user function with calculation of how long he stay in and also login logoff timings needed for this one
fasher_the_one 13-Jul-13 8:09am
what I need is just a way to get the date and time the User to perform the logout, because as already get login. I know what to do to insert the database after the data is available.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.170813.1 | Last Updated 12 Jul 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100