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();
}
