protected void LoadData()
        {
            Database db = EnterpriseLibraryContainer.Current.GetInstance <Database>("Clinic db Instance");

            try
            {
                string str = "select e.employeeid, e.firstname, e.lastname, p.specialty "
                             + "from employee e, physician p where e.EMPLOYEEID = p.EMPLOYEEID and e.EMPLOYEEID NOT IN (select employeeid from surgeon)"
                             + " and e.firstname like '%" + Fname.Text + "%' and e.lastname like '%" + Lname.Text + "%'";
                using (DataSet ds = db.ExecuteDataSet(CommandType.Text, str))
                {
                    if (ds.Tables[0].Rows.Count > 0)
                    {
                        Session.Add("Data", ds);
                        PhysEntries.DataSource = ds;
                        PhysEntries.DataBind();
                        //tcSearch.ActiveTabIndex = 1;
                        PhysEntries.Visible = true;
                        lblError.Visible    = false;
                    }
                    else
                    {
                        lblError.Text    = "No data found for the search criteria!";
                        lblError.Visible = true;
                    }
                }
            }
            catch (SqlException ex)
            {
                lblError.Text    = ex.Message.ToString();
                lblError.Visible = true;
            }
        }
 protected void Physician_PageIndexChanging(object sender, GridViewPageEventArgs e)
 {
     try
     {
         PhysEntries.PageIndex = e.NewPageIndex;
         if (Session["data"] != string.Empty || Session["Data"] != null)
         {
             PhysEntries.DataSource = Session["data"];
             PhysEntries.DataBind();
         }
         else
         {
             LoadData();
         }
     }
     catch (Exception ex)
     {
     }
 }