protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; if (Request.QueryString["ID"] != null) { if (Request.QueryString["ID"] == "True") { lblMsg.Text = "Successfully Edited"; } } if (Request.QueryString["GroupId"] != null) { int GroupId = Convert.ToInt32(Request.QueryString["GroupId"]); dtGroups = taGroups.SelectGroupbyGroupId(GroupId); if (dtGroups.Rows.Count > 0) { txtTitle.Text = dtGroups[0].GroupName.ToString(); } else { lblMsg.Text = "No record found"; return; } } else { lblMsg.Text = "No record found"; return; } }
protected void LoadGroups() { dtGroups = taGroups.SelectAllGroups(); ddlGroup.DataSource = dtGroups; ddlGroup.DataTextField = dtGroups.Columns[1].ToString(); ddlGroup.DataValueField = dtGroups.Columns[0].ToString(); ddlGroup.DataBind(); }
protected void LoadGroups() { dtGroups = taGroups.SelectAllGroups(); ddlGroup.DataSource = dtGroups; ddlGroup.DataTextField = dtGroups.Columns[1].ToString(); ddlGroup.DataValueField = dtGroups.Columns[0].ToString(); ddlGroup.DataBind(); ddlGroup.Items.Insert(0, new ListItem("Please select one","")); }
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { Label lblGroupId = (Label)e.Row.FindControl("lblGroupId"); dtGroups = taGroups.SelectGroupNamebyGroupId(Convert.ToInt32(lblGroupId.Text)); if (dtGroups.Rows.Count > 0) lblGroupId.Text = dtGroups[0].GroupName.ToString(); else lblGroupId.Visible = false; LinkButton btnDel = (LinkButton)e.Row.FindControl("lbtnDelete"); btnDel.Attributes.Add("OnClick", "return confirm('Are you sure to delete this record?');"); } }
protected void btnAdd_Click(object sender, EventArgs e) { dtNewsLetterGroup = taNewsLetterGroup.SelectFromGroupWhereTitleIsNone(); if (dtNewsLetterGroup.Rows.Count > 0) { taSubscriber.AddSubscriber(Convert.ToInt32(dtNewsLetterGroup[0].GroupId.ToString()), txtEmail.Text.Trim(), txtName.Text.Trim(), txtAddress.Text.Trim(), ddlCity.SelectedItem.Text.Trim(), DateTime.Now); } Response.Redirect("Thankyou.aspx?ID=Subscribed"); }
private void BindData() { dtGroups = taGroups.SelectAllGroups(); if (dtGroups.Rows.Count > 0) { GridView1.DataSourceID = null; GridView1.DataSource = dtGroups; GridView1.DataBind(); } else { lblMsg.Text = "No record found"; return; } }