how to display last login date

Question

i have a label i want to show the user last login date.how it would be plz help me .i just want to entry the date when user login how it would be done lz tell me in detail

Vignesh Kumar · Answer

Hi Try this I have been using this for myself. protected void Login1_Authenticate( object sender AuthenticateEventArgs e) { Login login = (Login)sender; // Get the user attempting to login MembershipUser user = Membership.GetUser(login.UserName); if ( user != null ) { // Get the date the user last logged in before DateTime dtLastLogin = user.LastLoginDate; // To validate user -- if success then set the authentication if (Membership.ValidateUser(login.UserName login.Password)) { Session[  LastLoginDate ] = dtLastLogin; e.Authenticated = true ; } } }

Kiresh Gangariya · Answer

HI mark this post as helped.

minu khandelwal · Answer

Last login date

Bhabani prasad Dash · Answer

Thanks all of u for ur valuable time i solve dthis and the code is below private void lastlogin() { con.Open(); cmd = new SqlCommand(select * from last_logindetails con); rd = cmd.ExecuteReader(); while (rd.Read()) { if (Session[uid].ToString() == rd[username].ToString()) { up = 1; } } rd.Close(); con.Close(); if (up==1) { con.Open(); cmd = new SqlCommand(SELECT TOP 1 lastlogin FROM last_logindetails WHERE username = ' + Session[uid].ToString() + ' ORDER BY lastlogin DESC con); { cmd.Parameters.AddWithValue(@username Session[uid].ToString()); DateTime lastLogin = (DateTime)cmd.ExecuteScalar(); da = new SqlDataAdapter(cmd); ds = new DataSet(); da.Fill(ds); lbl_date.Text = ds.Tables[0].Rows[0][lastlogin].ToString(); } } else { lbl_date.Text = DateTime.Now.ToString(); } rd.Close(); con.Close(); }

Bala · Answer

- Do it first as Shapriya said. - Command is ----------------- - Select Last(Column_name) from Table_name where User_ID = '+User_ID.Text+' ; - Create Data Reader with obj Name - Store that Data Reader like dr.Read() lblLastdate.Text = dr.GetString(No.);

Kiresh Gangariya · Answer

1)In User Table make one Column With LastLoginDate AS DATETIME 2) Now in Login Page update this Field by DateTime.Now() using LoggedIn UserId In User Table. when user loggedin then retive that LastLoginDate using LoggedIn UserId to your Label. Thanks