protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { ddlHub.DataSource = context.Hubs.Where(x => x.Name.Contains("Hub")).Select(x => x.Name).ToList(); ddlHub.DataBind(); ddlHub.Items.Insert(0, new ListItem("All", "All")); ddlQuiz.DataSource = qc.GetQuizNames(); ddlQuiz.DataBind(); ddlQuiz.Items.Insert(0, new ListItem("All", "All")); gvResult.DataSource = qc.GetResults(); gvResult.DataBind(); if (gvResult.Rows.Count <= 0) { lblNoResult.Text = "No results available."; btnExcel.Enabled = false; btnExcel.BackColor = System.Drawing.Color.Gray; } else { lblNoResult.Visible = false; btnExcel.Enabled = true; btnExcel.BackColor = System.Drawing.ColorTranslator.FromHtml("#5bc0de"); } } catch (Exception ex) { Response.Write(ex); lblNoResult.Visible = true; lblNoResult.Text = "error loading results. please refresh the page."; } } }