How to store and get the last login activity of the user in asp.net?

Thanks
Pavan Kumar
Mark Answer if this fits the need

Thanks
Pavan Kumar
Mark Answer if this fits the need

string _ConnString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString; 

using (SqlConnection connection = new SqlConnection(_ConnString))

        {   string dateandtime = DateTime.Now.ToString();

            string loggedusername = HttpContext.Current.User.Identity.Name;

            string sql = "UPDATE users SET last_login_date=@dateandtime WHERE username=@loggedusername"; 

            connection.Open();       

            SqlCommand cmd = new SqlCommand(sql, connection);

            SqlParameter[] pram = new SqlParameter[2];

            pram[0] = new SqlParameter("@dateandtime", SqlDbType.VarChar, 49);

            pram[1] = new SqlParameter("@loggedusername", SqlDbType.VarChar, 49);



            pram[0].Value = dateandtime;

            pram[1].Value = loggedusername;



            for (int i = 0; i < pram.Length; i++)

            {

                cmd.Parameters.Add(pram[i]);

            }

            cmd.ExecuteNonQuery();

            connection.Close(); 

        }