protected void btnSearch_Click(object sender, EventArgs e) { if (ddlAdmins.SelectedValue == "0") { lblAdminmsg.Text = "Please Select Admins"; } if (ddlLocation.SelectedValue == "1") { lblAdminmsg.Text = "Please Select Location"; } using (PTCLEntities db = new PTCLEntities()) { if (ddlAdmins.SelectedItem.Text == null && ddlLocation.SelectedItem.Text == null) { lblAdminmsg.Text = "Please Select both CheckBoxes"; } else { int adminValue = Convert.ToInt32(ddlAdmins.SelectedValue); int LocationValue = Convert.ToInt32(ddlLocation.SelectedValue); var reportData = db.spFilterAdminWithLocation(adminValue, LocationValue).ToList(); GVAdmin.DataSource = reportData; } GVAdmin.DataBind(); GVAdmin.UseAccessibleHeader = true; if (GVAdmin.Rows.Count > 0) { GVAdmin.HeaderRow.TableSection = TableRowSection.TableHeader; lblAdminmsg.Text = ""; } else { lblAdminmsg.Text = "No Record to Show"; } } }