//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>
ASP.NET+Ajax无刷新留言板
最新推荐文章于 2021-08-06 08:32:33 发布