สอบถาม Code เก็บสถิติการเข้าดูหน้าเว็บของแต่ละ User ว่าเข้าดูกี่ครั้ง

UPDATE table_log SET VIEW = VIEW + 1 WHERE username = 'abc';

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using System.Web.Security;
using System.Data;

public partial class Login : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
        }
    }

    protected void btnOK_Click(object sender, EventArgs e)
    {
        if (CheckAuthenticate(txtUsername.Text.Trim(), txtPassword.Text.Trim()))
        {
            FormsAuthentication.RedirectFromLoginPage("UserLog", false);
        }
        else
        {
            ClearList();
        }
    }

    protected void btnCancel_Click(object sender, EventArgs e)
    {
        ClearList();
    }

    #region Method
    
    private void ClearList()
    {
        txtUsername.Text = "";
        txtPassword.Text = "";
        SetFocusCtrl(txtUsername);
    }

  

    private void SetFocusCtrl(System.Web.UI.Control ctrl)
    {
        string script = "<SCRIPT language=\"javascript\">" + "document.getElementById('" + ctrl.ID + "').focus() </SCRIPT>";
        ClientScript.RegisterStartupScript(this.GetType(), "focus", script.Trim());
    }

    private bool CheckAuthenticate(string Username, string Password)
    {
        string querystr = "select * from emp where ltrim(rtrim(Username))='" + Username.Trim() + "' and ltrim(rtrim(Password)) ='" + Password.Trim() + "'";
        vdoClassUtil cUtil = new vdoClassUtil();
        DataTable dtUser = cUtil.GetDatatable(querystr);


        if (dtAgent.Rows.Count == 1)
        {
          
            return true;
        }
        else
        {
            return false;
        }

    }

    #endregion

   
}

private bool CheckAuthenticate(string Username, string Password)
    {      

        string querystr = "select * from video_emp where ltrim(rtrim(Username))='" + Username.Trim() + "' and ltrim(rtrim(Password)) ='" + Password.Trim() + "'";
        vdoClassUtil cUtil = new vdoClassUtil();
        DataTable dtAgent = cUtil.GetDatatable(querystr);

                       
        if (dtAgent.Rows.Count == 1)
        {

           string strToday = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString();
           string strSQLLog = "INSERT INTO video_login (";
            strSQLLog += "\r" + " Username, Status_dtm ";
            strSQLLog += "\r" + ") VALUES (";
            strSQLLog += "\r '" + txtUsername.Text.Trim().ToLower() + "', getdate())";
            cUtil.RunQuery(strSQLLog);


        }
        else
        {
            return false;
        }