protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {

                var eventList = new EventList(User.Identity.Name);

                ddlEvents.DataSource = eventList.GetEvents();
                ddlEvents.DataTextField = "EName";
                ddlEvents.DataValueField = "pk_Event";
                ddlEvents.DataBind();

                DonorEventList DEL = new DonorEventList(User.Identity.Name);

                gvDonorEvents.DataSource = DEL.GetDonorEventList_Search(ddlEvents.SelectedIndex.ToString(), "", "",500, true);
                gvDonorEvents.DataBind();

            }
        }
        private void LoadGrid()
        {
            DonorEventList DEL = new DonorEventList(User.Identity.Name);


            bool blShow = chMailListOnly.Checked;


            gvDonorEvents.DataSource = DEL.GetDonorEventList_Search(ddlEvents.SelectedValue.ToString(), txtDonorID.Text.ToString(), txtName.Text.ToString(), 500, blShow);
            gvDonorEvents.DataBind();

            if(blShow)
            {
                gvDonorEvents.Columns[6].Visible = true;
                gvDonorEvents.Columns[7].Visible = false;

            }
            else
            {
                gvDonorEvents.Columns[6].Visible = false;
                gvDonorEvents.Columns[7].Visible = true;
            }
        }