public void loaddata()
 {
     try
     {
         ds = new DataSet();
         ds = pCheckUP.GetPatientCheckupDetails();
         GridPatientCheckUp.DataSource = ds;
         GridPatientCheckUp.DataBind();
     }
     catch (SqlException ex)
     {
         ShowMessageBox("Remote Acess Not Available");
     }
 }
 protected void GridPatientCheckUp_PageIndexChanging(object sender, GridViewPageEventArgs e)
 {
     GridPatientCheckUp.PageIndex = e.NewPageIndex;
     loaddata();
     GridPatientCheckUp.DataBind();
 }