protected void Recover_Click(object sender, EventArgs e) { // get pageid string pageid = Request.QueryString["pageid"]; bool isPublished = true; // execute update query //UPDATE pages SET pagetitle = "123", pagebody = "321", isPublished = true WHERE pageid = 1 string query = "UPDATE pages SET isPublished = " + isPublished + " WHERE pageid = " + pageid; // db instance WEBSITEDB db = new WEBSITEDB(); // execute crud query db.CRUD_Query(query); Response.Redirect("DetailPage.aspx?pageid=" + pageid); }
protected void Edit_Click(object sender, EventArgs e) { string pagetitle = PageTitle.Text; string pagebody = PageBody.Text; // get pageid string pageid = Request.QueryString["pageid"]; // execute update query //UPDATE pages SET pagetitle = "123", pagebody = "321", isPublished = true WHERE pageid = 1 string query = "UPDATE pages SET pagetitle = \"" + pagetitle + "\"" + ", pagebody = \"" + pagebody + "\"" + " WHERE pageid = " + pageid; // db instance WEBSITEDB db = new WEBSITEDB(); // execute crud query db.CRUD_Query(query); Response.Redirect("DetailPage.aspx?pageid=" + pageid); }