how to insert login and logout times

Good Afternoon Vineeth1311

The Simple thing you can do is to Insert a new record when the user logs into and when he logout Update the Field of datetime and set it to getdate() , which is the current time.

1 insert statement and 1 Update statement when the user logs out.

Thank you for posting at DotnetFunda

Vuyiswa Maseko


Thank you for posting at Dotnetfunda
[Administrator]

And also I want to insert the time when user closes the browser

Good Morning Vineeth1311

yes lets say i have a Table called timelogging defined like this

Create table timelogging 

(

ID int identity(100,01) Primary key not null ,

Username varchar(20) null,

LoginTime DateTime null,

LogoutTime DateTime null

)

in this Case when the User logs in you will insert a new Record and like this

insert into timelogging (Username,LoginTime)

values (@Username,GetDate())

and when the user Closes the Application by logging out , now you don't insert a new record but you Update a Field "LogoutTime like this

Update timelogging 

set LogoutTime  =Getdate()

where Username = @Username

Thank you Again For Posting at Dotnetfunda


Vuyiswa Maseko

Thank you for posting at Dotnetfunda
[Administrator]

Hello,

You can update the time on close event of window.

++
Thanks & Regards,
Deepika