protected void SelectSections() { dtSections = taSections.SelectSectionCategoryAndSectionName(); ddlSection.DataSourceID = null; ddlSection.DataSource = dtSections; ddlSection.DataTextField = dtSections.Columns["SectionName"].ToString(); ddlSection.DataValueField = dtSections.Columns["SectionId"].ToString(); ddlSection.DataBind(); ddlSection.Items.Insert(0, new ListItem("Please Select", "")); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; SelectCategories(); if (Request.QueryString["ID"] != null) { if (Request.QueryString["ID"] == "True") { lblMsg.Visible = true; lblMsg.Text = "Successfully Edited"; } } if (Request.QueryString["SectionId"] != null) { int SectionId = Convert.ToInt32(Request.QueryString["SectionId"]); dtSections = taSections.SelectSectionsbySectionId(SectionId); if (dtSections.Rows.Count > 0) { ddlCategory.Items.FindByValue(dtSections[0].CategoryId.ToString()).Selected = true; txtSectionName.Text = dtSections[0].SectionName.ToString(); } else { lblMsg.Text = "No record found"; btnEdit.Visible = false; return; } } else { lblMsg.Text = "No record found"; btnEdit.Visible = false; return; } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; if (Request.QueryString["SectionId"] != null) { int SectionId = Convert.ToInt32(Request.QueryString["SectionId"]); dtSections = taSections.SelectSectionsbySectionId(SectionId); if (dtSections.Rows.Count > 0) { dtFAQ = taFAQ.SelectQuestionsbySectionId(SectionId); if (dtFAQ.Rows.Count > 0) { Repeater2.DataSource = dtFAQ; Repeater2.DataBind(); } else { Repeater2.Visible = false; } } else { Repeater2.Visible = false; } } else { Repeater2.Visible = false; } }
private void BindData() { if (Request.QueryString["CategoryId"] != null) { int CategoryId = Convert.ToInt32(Request.QueryString["CategoryId"]); dtSections = taSections.SelectSectionsbyCategoryId(CategoryId); ddlCategory.Items.FindByValue(CategoryId.ToString()).Selected = true; } else dtSections = taSections.SelectAllSections(); if (dtSections.Rows.Count > 0) { GridView1.DataSourceID = null; GridView1.DataSource = dtSections; GridView1.DataBind(); } else { lblMsg.Text = "No record found"; return; } }