Click here to Skip to main content
Search within:



Next

Save logout time in database using session
Sign Up to vote bad
good
See more: C#ASP.NET
How to save logout time in database when user click on logout button using session in C#?
 string username = Session["uname"].ToString();
            string password = Session["pwd"].ToString();
            lbl_1.Text = username;
                cn.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = cn;
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandText = "SP_TRACK_USE";
                cmd.Parameters.AddWithValue("@Username", username);
                cmd.Parameters.AddWithValue("@Password", password);
                cmd.Parameters.AddWithValue("@COMMAND", 1);
                cmd.ExecuteScalar();
                cn.Close();
                Response.Redirect("Default.aspx");
Coding runs properly, but logout time is not saved in database.
Posted 17 Dec '12 - 22:07
Member 8110943356
Edited 17 Dec '12 - 22:10
André Kraak51.2K
v2
Add a Solution

Comments
faisal23 - 18 Dec '12 - 4:12
In stored procedure pick the machine time by getDate() and on logout button call this procedure and at the same time insert into proper table.
Member 8110943 - 18 Dec '12 - 4:30
i already try same coding as u said,but its not working.
AshishChaudha - 18 Dec '12 - 5:29
have you tried debugging??? Please share your stored procedure.
Member 8110943 - 18 Dec '12 - 5:48
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[SP_TRACK_USE] @Username varchar(50), @Password varchar(50), @COMMAND INT = 0 AS BEGIN SET NOCOUNT ON; IF(@COMMAND = 0) BEGIN INSERT INTO USERLOG (Username,Password,LOGIN,LOGOUT) VALUES (@Username,@Password,GETDATE(),NULL) END ELSE IF (@COMMAND = 1) BEGIN UPDATE USERLOG SET LOGOUT = GETDATE() WHERE Username=@Username and Password=@Password END END set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[SP_TRACK_USE] @Username varchar(50), @Password varchar(50), @COMMAND INT = 0 AS BEGIN SET NOCOUNT ON; IF(@COMMAND = 0) BEGIN INSERT INTO USERLOG (Username,Password,LOGIN,LOGOUT) VALUES (@Username,@Password,GETDATE(),NULL) END ELSE IF (@COMMAND = 1) BEGIN UPDATE USERLOG SET LOGOUT = GETDATE() WHERE Username=@Username and Password=@Password END END set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[SP_TRACK_USE] @Username varchar(50), @Password varchar(50), @COMMAND INT = 0 AS BEGIN SET NOCOUNT ON; IF(@COMMAND = 0) BEGIN INSERT INTO USERLOG (Username,Password,LOGIN,LOGOUT) VALUES (@Username,@Password,GETDATE(),NULL) END ELSE IF (@COMMAND = 1) BEGIN UPDATE USERLOG SET LOGOUT = GETDATE() WHERE Username=@Username and Password=@Password END END set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[SP_TRACK_USE] @Username varchar(50), @Password varchar(50), @COMMAND INT = 0 AS BEGIN SET NOCOUNT ON; IF(@COMMAND = 0) BEGIN INSERT INTO USERLOG (Username,Password,LOGIN,LOGOUT) VALUES (@Username,@Password,GETDATE(),NULL) END ELSE IF (@COMMAND = 1) BEGIN UPDATE USERLOG SET LOGOUT = GETDATE() WHERE Username=@Username and Password=@Password END END set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[SP_TRACK_USE] @Username varchar(50), @Password varchar(50), @COMMAND INT = 0 AS BEGIN SET NOCOUNT ON; IF(@COMMAND = 0) BEGIN INSERT INTO USERLOG (Username,Password,LOGIN,LOGOUT) VALUES (@Username,@Password,GETDATE(),NULL) END ELSE IF (@COMMAND = 1) BEGIN UPDATE USERLOG SET LOGOUT = GETDATE() WHERE Username=@Username and Password=@Password END END set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[SP_TRACK_USE] @Username varchar(50), @Password varchar(50), @COMMAND INT = 0 AS BEGIN SET NOCOUNT ON; IF(@COMMAND = 0) BEGIN INSERT INTO USERLOG (Username,Password,LOGIN,LOGOUT) VALUES (@Username,@Password,GETDATE(),NULL) END ELSE IF (@COMMAND = 1) BEGIN UPDATE USERLOG SET LOGOUT = GETDATE() WHERE Username=@Username and Password=@Password END END ALTER PROCEDURE [dbo].[SP_TRACK_USE] @Username varchar(50), @Password varchar(50), @COMMAND INT = 0 AS BEGIN SET NOCOUNT ON; IF(@COMMAND = 0) BEGIN INSERT INTO USERLOG (Username,Password,LOGIN,LOGOUT) VALUES (@Username,@Password,GETDATE(),NULL) END ELSE IF (@COMMAND = 1) BEGIN UPDATE USERLOG SET LOGOUT = GETDATE() WHERE Username=@Username and Password=@Password END END please give me solution for this pbm.

4 solutions

use SQL Server Session mode to store and pick the date from the system.
 
Exploring Session in ASP.NET[^]
hope it helped!
  Permalink  
Posted 17 Dec '12 - 22:21
Abhishek Pant15K
Comments
Member 8110943 - 18 Dec '12 - 4:54
Give me code for this..I tried but it doesn't work.
ProgramFOX - 18 Dec '12 - 5:20
My Edit: Shouting removed.
Hi,
 
why not you alter the StoredProcedure with additional parameter 'logout_time' and pass the value
string username = Session["uname"].ToString();
            string password = Session["pwd"].ToString();
            lbl_1.Text = username;
                cn.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = cn;
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandText = "SP_TRACK_USE";
                cmd.Parameters.AddWithValue("@Username", username);
                cmd.Parameters.AddWithValue("@Password", password);
                cmd.Parameters.AddWithValue("@logout_time", DateTime.Now());
                cmd.Parameters.AddWithValue("@COMMAND", 1);
                cmd.ExecuteScalar();
                cn.Close();
                Response.Redirect("Default.aspx");
  Permalink  
Posted 17 Dec '12 - 23:19
ashokmmrk927
Edited 17 Dec '12 - 23:26
Abhishek Pant15K
v2
You can do this in global.asax file.
  Permalink  
Posted 17 Dec '12 - 23:29
AshishChaudha39K
Why do you need to store the password ? Where are you storing the logout time ? If you add a column to store it and make the default getdate(), then that will work, but right now, you've either done that ( and it would work ), or you've not tried at all.
  Permalink  
Posted 17 Dec '12 - 22:12
Christian Graus604K
Comments
Member 8110943 - 18 Dec '12 - 4:27
UPDATE USERLOG SET LOGOUT = GETDATE() where Username=@Username and Password=@Password i m trying this code for saving logout time.Any mistake then please guide me
Member 8110943 - 18 Dec '12 - 4:29
UPDATE USERLOG SET LOGOUT = GETDATE() i also try this code but it also not save the logout time in database..
Christian Graus - 18 Dec '12 - 14:20
Well, gee, you're trying things at random, do you have any clue what you're doing ? Perhaps if you told us what DOES happen, if you get an error, etc, that would help. Is logout a datetime ?
Add a Solution

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

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 414
1 Arun Vasu 253
2 OriginalGriff 200
3 CPallini 163
4 Aarti Meswania 158
0 Sergey Alexandrovich Kryukov 10,169
1 OriginalGriff 7,749
2 CPallini 4,181
3 Rohan Leuva 3,482
4 Maciej Los 3,089


Advertise | Privacy | Mobile
Web02 | 2.6.130523.1 | Last Updated 18 Dec 2012
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid