ASP.NET+Ajax无刷新留言板

最新推荐文章于 2021-08-06 08:32:33 发布

LMAOhuaNL

最新推荐文章于 2021-08-06 08:32:33 发布

阅读量3.1k

点赞数

分类专栏： css C# asp.Net js Ajax 文章标签： asp.net ajax xmlhttprequest dataset function books

本文链接：https://blog.csdn.net/LMAOhuaNL/article/details/6720142

版权

asp.Net 同时被 3 个专栏收录

75 篇文章 0 订阅

订阅专栏

40 篇文章 0 订阅

订阅专栏

28 篇文章 0 订阅

订阅专栏

//AddMessagePage.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;

public partial class MessageBoard_AddMessagePage : System.Web.UI.Page
{
    //根据客户端的nickName,Content增加留言
    protected void Page_Load(object sender, EventArgs e)
    {
        
        string nickName = Request.QueryString["nickName"];
        string content = Request.QueryString["Content"];
        try
        {
            SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=UserDB;Integrated Security=True");
            conn.Open();
            string sql = string.Format("insert MessageInfo values('{0}','{1}')", nickName, content);
            SqlCommand command = new SqlCommand(sql, conn);
            command.ExecuteNonQuery();
            Response.Write("ok");
            conn.Close();
        }
        catch {
            Response.Write("fail");
        }
        Response.End();
    }
}










//GetMessage.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

public partial class MessageBoard_GetMessage : System.Web.UI.Page
{
	//加载的时候，显示所有留言
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=UserDB;Integrated Security=True");
        string sql = "select * from MessageInfo";
        DataSet ds = new DataSet();
        SqlDataAdapter adapter = new SqlDataAdapter(sql,conn);
        adapter.Fill(ds,"Books");
        Response.Write("<div>");
        for(int i=0;i<ds.Tables["Books"].Rows.Count;i++){
            DataRow dr=ds.Tables["Books"].Rows[i];
            Response.Write("<h3>"+dr["nickName"].ToString()+"说：</h3>"+"<p>"+dr["MessageContent"].ToString()+"</p>");
        }
        Response.Write("</div>");
    }
}




<!--UserAjaxMessage1.aspx-->
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="UserAjaxMessage1.aspx.cs" Inherits="MessageBoard_UserAjaxMessage1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <script language="javascript" type="text/javascript">
        var xmlHttp = null;
        //判断浏览器
        function createXMLHttpRequest() {
            if (window.XMLHttpRequest) {
                //Firefox,Netscape,Chrome,Safari等浏览器
                xmlHttp = new XMLHttpRequest();
            } else if (window.ActiveXObject) { //IE浏览器
                try {
                    xmlHttp = new ActiveXObject("Msxml2.XMLHTTP"); //创建xmlHttp对象
                } catch (e) {
                    try {
                        xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");//创建xmlHttp对象
                    }catch(e){}
                }
            }
        }
        function btnAddMessage() {
            var nickName = document.getElementById("nickName").value; //获取网名
            var content = document.getElementById("txtMessage").value; //留言内容
            createXMLHttpRequest(); //调用判断浏览器的方法
            xmlHttp.open("get", "AddMessagePage.aspx?nickName=" + escape(nickName) + "&content=" + escape(content));
            document.getElementById("PostMessage").style.display="block"; //提示正在提交数据
            xmlHttp.send();
            xmlHttp.onreadystatechange = function () {
                if (xmlHttp.readyState == 4 && xmlHttp.status == 200) {
                    if (xmlHttp.responseText == "ok") {
                        document.getElementById("showMessage").innerHTML += "<div><h3>" + nickName + "说：</h3><p>" + content + "</p></div>";
                    } else {
                        alert("留言失败");
                    }
                    document.getElementById("PostMessage").style.display = "none"; //数据提交完毕
                }
            }

        }
        function OnLoad() {
            req = new XMLHttpRequest();
            req.open("get", "GetMessage.aspx?rd="+Math.random()); //防止缓存
            req.send();
            req.onreadystatechange = function () {
                if (req.readyState == 4 && req.status == 200) {
                    document.getElementById("showMessage").innerHTML = req.responseText; //页面加载的时候，显示数据库中所有留言
                } 
            }
        }
    </script>
</head>
<body οnlοad="OnLoad()">
    <form id="form1" runat="server">
    <div>
        <div id="showMessage">
            <h3>恰恰说：</h3>
            <p>今天的天气真Tm不错</p>
            <h3>恰恰说：</h3>
            <p>今天的天气真Tm不错</p>
            <h3>恰恰说：</h3>
            <p>今天的天气真Tm不错</p>
            <h3>恰恰说：</h3>
            <p>今天的天气真Tm不错</p>
        </div>
        <div>
            <p><span>请输入你的网名：</span><input type="text" id="nickName" /></p>
            <p><span>请输入要说的话：</span><textarea id="txtMessage" rows="5" cols="22"></textarea></p>
            <p><input type="button" value="留言" οnclick="btnAddMessage()" /></p>
        </div>
        <div id="PostMessage" style="display:none;">正在提交数据</div>
    </div>
    </form>
</body>
</html>

LMAOhuaNL

关注

0
点赞
踩
6

收藏

觉得还不错? 一键收藏
2
评论
ASP.NET+Ajax无刷新留言板

//AddMessagePage.aspx.csusing System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;usi
复制链接

扫一扫