how to display last login date

Bhabani prasad Dash

13y5.9k.NET

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vignesh Kumar13y ago
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 Gangariya13y ago
HI

mark this post as helped.
minu khandelwal13y ago
Last login date
Bhabani prasad Dash13y ago
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(); }
Bala13y ago
- 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 Gangariya13y ago
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,