protected void gvReport_Sorting(object sender, GridViewSortEventArgs e)
        {
            DonorList DL = new DonorList();

            string[] SortOrder = ViewState["SortExpr"].ToString().Split(' ');
            if (SortOrder[0] == e.SortExpression)
            {
                if (SortOrder[1] == "ASC")
                {
                    ViewState["SortExpr"] = e.SortExpression + " " + "DESC";
                }
                else
                {
                    ViewState["SortExpr"] = e.SortExpression + " " + "ASC";
                }
            }
            else
            {
                ViewState["SortExpr"] = e.SortExpression + " " + "ASC";
            }

            gvReport.PageIndex = 0;

            gvReport.DataSource = DL.GetDonorDemoUpdates(ViewState["SortExpr"].ToString());
            gvReport.DataBind();

        }
        protected void Page_Load(object sender, EventArgs e)
        {
            string attachment = "attachment; filename=EventGuestList-Excel_" + DateTime.Now.ToString() + ".xls";

            Response.ClearContent();
            Response.AddHeader("content-disposition", attachment);
            Response.ContentType = "application/ms-excel";

            DonorList DL = new DonorList();

            gvExcel.DataSource = DL.GetDonorDemoUpdates();
            gvExcel.DataBind();

            
        }
        private void DataBind(int pPageIndex = 0)
        {


            if (pPageIndex <= 0)
            {
                pPageIndex = 0;
            }
            else
            {
                if (pPageIndex > gvReport.PageCount)
                    pPageIndex = gvReport.PageCount;

            }

            DonorList DL = new DonorList();

            gvReport.PageIndex = pPageIndex;
            gvReport.DataSource = DL.GetDonorDemoUpdates(ViewState["SortExpr"].ToString());
            gvReport.DataBind();

        }