关闭

asp.net ajax 留言板

484人阅读 评论(0) 收藏 举报
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class 留言板 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string sql = ConfigurationManager.ConnectionStrings["strcnn"].ConnectionString;
            using (SqlConnection sqlcnn = new SqlConnection(sql))
            {
                SqlCommand sqlcmm = sqlcnn.CreateCommand();
                sqlcmm.CommandText = "select [content] from chat";
                sqlcnn.Open();
                SqlDataReader reader = sqlcmm.ExecuteReader();
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        this.txt_show.Text += "小王说:\n" + Convert.ToString(reader["content"]) + "\n";
                    }
                }
            }
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
         string sql = ConfigurationManager.ConnectionStrings["strcnn"].ConnectionString;
         using (SqlConnection sqlcnn = new SqlConnection(sql))
         {
             SqlCommand sqlcmm = sqlcnn.CreateCommand();
             sqlcmm.CommandText = "insert into chat ([content],createtime) values (@con,@time)";
             sqlcmm.Parameters.AddWithValue("@con",this.txt_say.Text.Trim ());
             sqlcmm.Parameters.AddWithValue("@time",DateTime.Now);
             sqlcnn.Open();
             sqlcmm.ExecuteNonQuery();
         }
         ScriptManager.RegisterStartupScript(this, this.GetType(), "", "<script>openLayer('test_con3')</script>", false);
        // this.txt_say.Text = "";
         this.txt_show.Text += "小王说:\n" + this.txt_say.Text + "\n";
    }
}

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:280189次
    • 积分:3405
    • 等级:
    • 排名:第11855名
    • 原创:113篇
    • 转载:13篇
    • 译文:0篇
    • 评论:31条
    最新评论