protected void GetDoctorReviews()
 {
     try
     {
         string CS = ConfigurationManager.ConnectionStrings["ConnectToPatientPortal"].ConnectionString;
         using (SqlConnection con = new SqlConnection(CS))
         {
             string         query = "Select * from Reviews where ForId='" + Session["SelectedDoctorForDetailView"] + "'";
             SqlDataAdapter da    = new SqlDataAdapter(query, con);
             DataTable      dt    = new DataTable();
             da.Fill(dt);
             GridViewReviews.DataSource = dt;
             GridViewReviews.DataBind();
         }
     }
     catch (Exception ex)
     {
         Session["Exception"] = ex;
         Response.Redirect("~/404.aspx");
     }
 }
 private void PopulateGrid()
 {
     GridViewReviews.DataSource = GetData();
     GridViewReviews.DataBind();
 }
 private void UpdateGridViewReviews()
 {
     GridViewReviews.DataSource = DataAccess.selectQuery("Select * from Reviews where UID=" + id);
     GridViewReviews.DataBind();
 }