protected void SaveText(object sender, EventArgs e) { conn.Open(); if (cmstrDefualts.CheckQueryString("status", out status)) { dv.RowFilter = "PageStatus=" + status; } for (int i = 0; i < EditTextRepeater.Items.Count; i++) { int myid = 0; int.TryParse(((HiddenField)EditTextRepeater.Items[i].FindControl("MyIdHiddenField")).Value.ToString(), out myid); dv[i]["myText"] = ((ASP.controls_cmstrtextboxcontrol_ascx)EditTextRepeater.Items[i].FindControl("GeneralMyTextBox")).Text; string myText = ((ASP.controls_cmstrtextboxcontrol_ascx)EditTextRepeater.Items[i].FindControl("GeneralMyTextBox")).Text.Replace("'", "''"); string newpass = ((ASP.controls_cmstrtextboxcontrol_ascx)EditTextRepeater.Items[i].FindControl("GeneralMyTextBox")).GetValuepass.Replace("'", "''"); // string myText = ((ASP.controls_cmstrtextboxcontrol_ascx)((LinkButton)sender).Parent.FindControl("GeneralMyTextBox")).Text.Replace("'","''"); // myText = ((ASP.controls_cmstrtextboxcontrol_ascx)((LinkButton)sender).Parent.FindControl("GeneralMyTextBox")).DataFieldValue.Replace("'", "''"); // dv[i]["myText"] = myText; string sql = String.Format("Update langtext2 Set `{2}`='{0}' Where LangTextID={1} ", myText, myid, myLang); MySqlCommand cmd = new MySqlCommand(sql, conn); cmd.ExecuteNonQuery(); } conn.Close(); Languages.PageNames.Clear(); Languages.TextPages.Clear(); Languages.sendMagLangs.Clear(); EditTextRepeater.DataSource = dv; EditTextRepeater.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { GoBack.NavigateUrl = "ManageSiteGenText.aspx?sitelang=" + Request.QueryString["sitelang"] + "&cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"]; if (cmstrDefualts.CheckQueryString("status", out status)) { GoBack.NavigateUrl = "ManageSiteGenText.aspx?sitelang=" + Request.QueryString["sitelang"] + "&cat=" + Request.QueryString["cat"] + "&sub=" + Request.QueryString["sub"] + "&status="; } if (Request.QueryString["sitelang"] != null && int.TryParse(Request.QueryString["sitelang"], out myLang)) { if (Request.QueryString["page"] != null) { int.TryParse(Request.QueryString["page"], out pageid); } string pagequery = pageid == 0 ? "" : " AND langtext2.PageID=" + pageid; String sql = String.Format("Select langtext2.PageID as mypage, LangTextID, `{1}` as myText,TextType,PageStatus,TextComment,TextName,pagename From langtext2 left join pages2 On pages2.pageid=langtext2.PageID where 1=1 {0} order by PageStatus", pagequery, myLang); MySqlDataAdapter MyAdapter = new MySqlDataAdapter(sql, conn); MyAdapter.Fill(ds, "lang"); dv = ds.Tables["lang"].DefaultView; if (!IsPostBack) { if (cmstrDefualts.CheckQueryString("status", out status)) { dv.RowFilter = "PageStatus=" + status; } EditTextRepeater.DataSource = dv; EditTextRepeater.DataBind(); string[] myvalues = { "PageStatus", "mypage" }; if (dv.Count > 0) { pageHeader.Text = dv[0]["pagename"].ToString(); } dv.RowFilter = "PageStatus>0"; DataTable mytable = dv.ToTable(true, myvalues); StatusRepeater.DataSource = mytable; StatusRepeater.DataBind(); } } else { Response.Redirect("../"); } }