protected void btnSave_Click(object sender, EventArgs e)
        {
            TextBox      txtUserID        = DetailsView1.FindControl("txtUserID") as TextBox;
            TextBox      txtUserName      = DetailsView1.FindControl("txtUserName") as TextBox;
            DropDownList dropUserRole     = DetailsView1.FindControl("dropUserRole") as DropDownList;
            TextBox      txtUserStatus    = DetailsView1.FindControl("txtUserStatus") as TextBox;
            TextBox      txtUserLoginDate = DetailsView1.FindControl("txtUserLoginDate") as TextBox;
            TextBox      txtWrongAttempts = DetailsView1.FindControl("txtWrongAttempts") as TextBox;
            int          userID           = Convert.ToInt32(txtUserID.Text.ToString());
            string       userName         = txtUserName.Text.ToString();
            string       userRole         = dropUserRole.SelectedValue.ToString();
            string       userStatus       = txtUserStatus.Text.ToString();
            string       userLoginDate    = txtUserLoginDate.Text.ToString();
            string       wrongAttempts    = txtWrongAttempts.Text.ToString();

            Debug.WriteLine("");
            Debug.WriteLine("Data From Grid:");
            Debug.WriteLine("User ID: " + userID);
            Debug.WriteLine("User Name: " + userName);
            Debug.WriteLine("User Type: " + userRole);
            Debug.WriteLine("User Status: " + userStatus);
            Debug.WriteLine("User Login Date: " + userLoginDate);
            Debug.WriteLine("User Wrong Attempts: " + wrongAttempts);
            DatabaseConnectivity dbcon = new DatabaseConnectivity();
            int res = dbcon.setAUser(userID, userName, userRole, userStatus, userLoginDate, wrongAttempts);

            //nt ResultQuery = dbcon.setAClient(userID, userName, userRole, userStatus, userLoginDate, wrongAttempts);
            //Console.WriteLine("<script>alert(" + ResultQuery + "record has been updated." + ")</script>");
            //ClientScript.RegisterStartupScript(this.GetType(), DateTime.Now.ToString(), "<script>alert(" + ResultQuery + "record has been updated." + ")</script>", true);
            //ScriptManager.RegisterStartupScript(this, this.GetType(), DateTime.Now.ToString(), "<script>alert(" + ResultQuery +")</script>", true);
            DetailsView1.Visible = false;
            //DetailsView1.Style.Add("display", "none");
            _BindService();
        }