newliuyan.aspx.cs

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

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

public partial class newliuyan : System.Web.UI.Page
{
    String myCnn = ConfigurationSettings.AppSettings["con"];
    SqlConnection Conn;
    public void Add_Click(Object sender, EventArgs E)
    {
        Conn = new SqlConnection(myCnn);
        String strSQL = "insert into 留言表(作者,邮箱,标题,时间,内容) values (@作者,@邮箱,@标题,@时间,@内容)";
        SqlCommand Comm = new SqlCommand(strSQL, Conn);
        Comm.Parameters.Add(new SqlParameter("@作者", SqlDbType.Char));
        Comm.Parameters["@作者"].Value = 作者.Text;
        Comm.Parameters.Add(new SqlParameter("@邮箱", SqlDbType.Char));
        Comm.Parameters["@邮箱"].Value = 邮箱.Text;
        Comm.Parameters.Add(new SqlParameter("@标题", SqlDbType.Char));
        Comm.Parameters["@标题"].Value = 标题.Text;
        Comm.Parameters.Add(new SqlParameter("@内容", SqlDbType.Char));
        Comm.Parameters["@内容"].Value = 内容.Text;
        Comm.Parameters.Add(new SqlParameter("@时间", SqlDbType.Char));
        Comm.Parameters["@时间"].Value = DateTime.Now;
        Comm.Connection.Open();
        try
        {
            Comm.ExecuteNonQuery();
            Label1.Text = "提交成功";
        }
        catch (SqlException)
        {
            Label1.Text = "提交失败";
            Label1.Style["color"] = "red";
        }
        Comm.Connection.Close();

    }
    public void Clear_Click(Object sender, EventArgs E)
    {
        Response.Redirect("newliuyan.aspx");
    }
}