private void Checkpassword()
    {
        try
        {

            using (SqlCommand sqlCommand = new SqlCommand("SELECT COUNT(*) from login where username like @username AND password like @password", myConnection))
            {
                myConnection.Open();
                string userName = UsernameBox.Text;
                string passWord = Passwordbox.Text;
                sqlCommand.Parameters.AddWithValue("@username", userName);
                sqlCommand.Parameters.AddWithValue("@password", passWord);
                int userCount = (int)sqlCommand.ExecuteScalar();
                if(userCount > 0)
                {
                    Session["username"] = userName;
                    Session["password"] = passWord;
                    myConnection.Close();
                    Response.Redirect("AdminPage.aspx");

                }
                else
                {
                    StatusLabel.Text = "Incorrect username or password";
                    myConnection.Close();
                }
            }

        }
        catch (Exception ex)
        {
            myConnection.Close();
        }
    }