liuyanban.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Text;

public partial class CommentsAdd : System.Web.UI.Page
{

    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["uname"] == null)
        {
            Response.Write("<script>javascript:alert('留言请先登录！');location.href='default.aspx';</script>");
            return;
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string id = Request.QueryString["jiaoshiID"].ToString();//获取上一个页面传来的ID值
       
        string title = this.zhuti.Text.ToString();
        string Name = Session["uname"].ToString();
        string Note = this.liuyanneirong.Text.ToString();
        string sql;
        //sql语句意思为:向表liuyan中插入新数据
        sql = "insert into liuyan(jiaoshiID,Name,title,Note) values("+id+",'" + Name + "','" + title + "','" + Note + "')";

        int result = LinkDB.ExecuteSql(sql.ToString());
        if (result == 1)
        {
            Response.Write("<script>javascript:alert('留言成功！');location.href='default.aspx';</script>");
        }
        else
        {
            Response.Write("<script>javascript:alert('系统错误');</script>");
        }
    }
}