protected void btnSearch_Click(object sender, EventArgs e)
        {
            try
            {
                dt = new DataTable();
                int             agencyID  = Convert.ToInt32(drpAgencyName.SelectedValue);
                string          firstName = txtFirstName.Text;
                string          lastName  = txtLastName.Text;
                string          emailID   = txtEmail.Text;
                clsPeopleFinder pplFinder = new clsPeopleFinder();
                dt = pplFinder.FindPeople(agencyID, firstName, lastName, emailID, 0);
                grdUser.DataSource = dt;
                grdUser.DataBind();
                Session[clsConstant.SESS_TABLE] = dt;

                if (grdUser.Rows.Count == 0)
                {
                    lblGrid.Text = "There is no records available.";
                }
                else
                {
                    lblGrid.Text = "";
                }
            }
            catch (Exception ex)
            {
                logger.Error(ex);
            }
        }
 protected void grdUser_PageIndexChanging(object sender, GridViewPageEventArgs e)
 {
     try
     {
         dt = new DataTable();
         dt = Session[clsConstant.SESS_TABLE] as DataTable;
         clsPeopleFinder pplFinder = new clsPeopleFinder();
         grdUser.PageIndex  = e.NewPageIndex;
         grdUser.DataSource = dt;
         grdUser.DataBind();
         Session[clsConstant.SESS_TABLE] = dt;
     }
     catch (Exception ex)
     {
         logger.Error(ex);
     }
 }