protected void btnSearch_Click(object sender, EventArgs e)
        {
            //search the database for the given search string (includes partial matches)
            lstMembers.Items.Clear();

            string searchQuery = txtSearch.Text.Replace(" ", "%");
            searchQuery = searchQuery.Trim();

            MemberHandler memberHandler = new MemberHandler();

            lstMembers.DataSource = memberHandler.GetMemberSearchList(searchQuery);
            lstMembers.DataTextField = "Name";
            lstMembers.DataValueField = "MemberID";
            lstMembers.DataBind();
        }