public partial class reply : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { int ID = Convert.ToInt32(Request.QueryString["guestID"]); SqlConnection con = DB.createcon(); con.Open(); SqlCommand cmd = new SqlCommand("update guest set Reply='" + this.TextBox1.Text + "' where ID=" + ID, con); if (Convert.ToInt32(cmd.ExecuteNonQuery()) > 0) { Response.Redirect("showmes.aspx?message=回復成功"); } else { Response.Redirect("showmes.aspx?message=回復失敗"); } } protected void Button2_Click(object sender, EventArgs e) { this.TextBox1.Text = ""; this.TextBox1.Focus(); }} |