หน้า Login Admin กับ User ไปคนละ Page และกด Approve แล้วให้ข้อมูล หายไป

  protected void btnLogin_Click(object sender, EventArgs e)
        {

           strConnString = "Data Source=NEWPROGRAMMER;Initial Catalog=customer;Integrated Security=True";
          objConn = new SqlConnection();
          objConn.ConnectionString = strConnString;
          objConn.Open();
          int intNumRows = 0;
          strSQL = "SELECT COUNT(*) FROM register WHERE username = '" + this.txtUsername.Text + "' AND [password] = '" + this.txtPassword.Text + "' ";
          objCmd = new SqlCommand(strSQL, objConn);
          intNumRows = Convert.ToInt32(objCmd.ExecuteScalar());

          if (intNumRows > 0)
          {
              Session["strUser"] = this.txtUsername.Text;
              Response.Redirect("Report.aspx");
          }
          else
          {
              this.pnlLogin.Visible = false;
              this.lblStatus.Visible = true;
              this.lblStatus.Text = "Username/Password is wrong.";
          }
           
            objConn.Close();
            objConn = null;
           
           
        }

  String strSQL;
            protected void myRepeater_ItemCommand(Object source, RepeaterCommandEventArgs e)
            {
                if (e.CommandName == "Update")
                {
                //*** Username ***//
             Label lblUsername = (Label)(e.Item.FindControl("lblUsername"));
            strSQL = "UPDATE register SET status = 1 WHERE username = '" +lblUsername.Text + "' ";
            objCmd = new SqlCommand(strSQL, objConn);
            objCmd.ExecuteNonQuery();

            BindData();
                }
            }

            protected void myRepeater_ItemDataBound(Object sender, RepeaterItemEventArgs e)
            {
                //*** Username ***//
                Label lblUsername = (Label)(e.Item.FindControl("lblUsername"));
                if (lblUsername != null)
            {
                lblUsername.Text = (string)DataBinder.Eval(e.Item.DataItem, "username");
            }
 
            //*** Lastname ***//
                Label lblLastname = (Label)(e.Item.FindControl("lblLastname"));
                if (lblLastname != null)
            {
                lblLastname.Text = (string)DataBinder.Eval(e.Item.DataItem, "lastname");
            }

            //*** Password ***//
                Label lblPassword = (Label)(e.Item.FindControl("lblPassword"));
                if (lblPassword != null)
            {
                lblPassword.Text = (string)DataBinder.Eval(e.Item.DataItem, "password");
            }
            //*** Address ***//
                Label lblAddress = (Label)(e.Item.FindControl("lblAddress"));
                if (lblAddress != null)
            {
                lblAddress.Text = (string)DataBinder.Eval(e.Item.DataItem, "address");
            }
            //*** Tel ***//
                Label lblTel = (Label)(e.Item.FindControl("lblTel"));
                if (lblTel != null)
            {
                lblTel.Text = DataBinder.Eval(e.Item.DataItem, "tel").ToString();
            }
            //*** Mobile ***//
                Label lblMobile = (Label)(e.Item.FindControl("lblMobile"));
                if (lblMobile != null)
            {
                lblMobile.Text = DataBinder.Eval(e.Item.DataItem, "mobile").ToString();
            }
                //Email//
                Label lblEmail = (Label)(e.Item.FindControl("lblEmail"));
                if (lblEmail != null)
                {
                    lblEmail.Text = DataBinder.Eval(e.Item, "email").ToString();
                }

            //*** Approve ***//
                LinkButton lnkApprove = (LinkButton)(e.Item.FindControl("lnkApprove"));
                if (lnkApprove != null)
                {
                     lnkApprove.Attributes.Add("OnClick", "return confirm('Delete Record?');");            
                 }
            }