how to update 'datetime' in column after login

Question

I have a table name is 'User_tbl' where i am saving data of all registered users and the same table is being used to verify the users during Login.

I want to update only 'LastSeen' column with current datetime after login.

Look at this picture.

code behind

  protected void Submit(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

            con.Open();
            SqlCommand cmd = new SqlCommand("select * from User_tbl where UserName =@username and Password=@password", con);
            cmd.Parameters.AddWithValue("@username", txtUserName.Text);
            cmd.Parameters.AddWithValue("@password", txtPWD.Text);

            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);


            if (dt.Rows.Count > 0)
            {
                //to define the user seesion (starting user session)

                Session["username"] = txtUserName.Text;

                Response.Redirect("default2.aspx");

            }

            else

            {

                ClientScript.RegisterStartupScript(Page.GetType(), "LoginValidate", "<script language='javascript'> document.getElementById('errorMessage').innerHTML = 'Invalid Username or Password'</script>");

            }


        }

Answer 1

Do you mean something like this?

SqlConnection sqlConn = new SqlConnection(connection string here);
SqlCommand sqlComm = new SqlCommand();
sqlComm = sqlConn.CreateCommand();
sqlComm.CommandText = @"UPDATE User_tbl SET LastSeen=GetDate() WHERE UserName='@userName'";
sqlComm.Parameters.Add("@userName", SqlDbType.VarChar);
sqlComm.Parameters["@userName"].Value = txtUserName.Text;
sqlConn.Open();
sqlComm.ExecuteNonQuery();
sqlConn.Close();

You'd need to place something along those lines in your 'if (dt.Rows.Count > 0)' code.

You may wish to reuse the same connection that you created for your SELECT statement.

Many other options are available. Often this sort of thing is best achieved using a stored procedure, where you can check the login credentials and perform any related updates in a single request to the database server.