guestbook.aspx.cs

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

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
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;
using System.Xml.Linq;
using System.Data.Sql;
using System.Data.SqlClient;
public partial class guestbook : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string connstr = ConfigurationManager.ConnectionStrings["yutian66"].ConnectionString;
        SqlConnection conn = new SqlConnection(connstr);
        conn.Open();
        string id = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString()
            + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString();
        string title = TextBox1.Text.Trim();
        string typeid = DropDownList1.SelectedValue.Trim();
        string contents = TextBox2.Text.Trim();
        string sql = "insert into messages (id,title,contents,typeid) values('" + id + "','" + title + "','" + contents + "','" + typeid + "')";
        SqlCommand cmd = new SqlCommand(sql,conn);
        cmd.ExecuteNonQuery();
        Response.Write("<script>window.alert('恭喜您发布留言成功！')</script>");
        this.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('恭喜您发布留言成功！')</script>");
        conn.Close();
        Response.Redirect("guestbook.aspx");

    }
}