*******************message.aspx***********************
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="message.aspx.cs" Inherits="Test_Default2" %>
<!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 src="JScript.js" type="text/javascript"></script>
<style type="text/css">
.style1
{
width: 100%;
height: 344px;
}
.style2
{
}
.style3
{
height: 306px;
}
body
{
text-align:center;
margin:auto auto 20px auto;
font-size:12px;
font-family:宋体;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div style="height: 351px">
<table class="style1">
<tr>
<td class="style3">
<div style="height: 100%" id="left_word">加载留言中……</div>
</div>
</td>
<td class="style2" rowspan="2">
<div style="height: 100%; id="div_top">
<div>
<span>姓名:</span>
<input type="text" id="username"/>
</div>
<div>
<span>性别:</span>
<input type="radio" value="男" name="sex" id="sexa" checked />男
<input type="radio" value="女" name="sex" id="sexb" /> 女</div>
<div>
<span> QQ:</span>
<input type="text" id="qq" />
</div>
<div>
<span>邮箱:</span>
<input type="text" id="mail" />
</div>
<div>
<textarea style="width:100%;height:300px" id="txt"></textarea>
</div>
<div style="text-align:center">
<input type="button" value="确定留言" οnclick="chk(this)" id="btn_submit"/>
</div>
</div>
</td>
<tr>
<td>
<div style="height: 100%">
<a href="javascript:firstpage()">首页</a>
<a href="javascript:previoustpage()">上一页</a>
<a href="javascript:nextpage()">下一页</a>
<a href="javascript:lastpage()">尾页</a>
第<span id="page">1</span>页
/共<span id="pagecount">1</span>页
</div>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
**************************************write.aspx********************************
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
public partial class write : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["add"] == "yes")
{
//OleDbConnection conn = connMdb.createConnMdb();
OleDbConnection conn=new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=" + Server.MapPath("guestbookData.mdb"));
OleDbDataAdapter oda = new OleDbDataAdapter();
oda.SelectCommand = new OleDbCommand("select * from wordData", conn);
DataSet ds = new DataSet(); //创建一个离线的数据集对象
oda.Fill(ds,"wordData");
DataRow dr = ds.Tables[0].NewRow(); //新建一个数据行
dr["username"] = Request.Form["username"]; //给该数据字段赋值
dr["sex"]=Request.Form["sex"];
dr["qq"]=Request.Form["bb"];
dr["mail"]=Request.Form["mail"];
dr["left_content"] = Request.Form["txt"].Replace(" < ", "< ").Replace("> ", "> ").Replace("/r/n", " <br> ").Replace(" ", " ");
ds.Tables[0].Rows.Add(dr); //把新建的行添加进数据表中
//编译命令,把对离线的数据库的操作,转换编译成真实的对应命令
OleDbCommandBuilder odb = new OleDbCommandBuilder(oda);
oda.Update(ds,"wordData"); //对离线数据库做的更改,回写到真实数据库中
}
}
}
**********************************game
<%@ Page Language="C#" AutoEventWireup="true" EnableViewState="false" CodeFile="getwordData.aspx.cs" Inherits="getwordData" %>
<%@ Import Namespace="System.Data" %>
<!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>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Repeater ID="Repeater1" runat="server">
<HeaderTemplate><table align="center" border="1" width="90%" cellpadding="8" cellspacing="0" style="border-collapse:collapse"></HeaderTemplate>
<ItemTemplate>
<tr>
<td style="text-align:left">
【编号:<%# ((DataRowView)Container.DataItem)["ID"] %>】
【姓名:<%# ((DataRowView)Container.DataItem)["username"] %>】
【性别:<%# ((DataRowView)Container.DataItem)["sex"] %>】
【QQ:<%# ((DataRowView)Container.DataItem)["qq"] %>】
【邮箱:<%# ((DataRowView)Container.DataItem)["mail"] %>】
</td>
</tr>
<tr><td style="text-align: left"><%# ((DataRowView)Container.DataItem)["left_content"]%></td></tr>
</ItemTemplate>
<SeparatorTemplate></table><br /><br /><table align="center" border="1" width="90%" cellpadding="8" cellspacing="0" style="border-collapse:collapse"></SeparatorTemplate>
<FooterTemplate></table></FooterTemplate>
</asp:Repeater>
</div>
</form>
</body>
</html>
*************cs代码*************
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
public partial class getwordData : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//OleDbConnection conn = connMdb.createConnMdb();
OleDbConnection conn=new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=" + Server.MapPath("guestbookData.mdb"));
OleDbDataAdapter oda = new OleDbDataAdapter();
oda.SelectCommand = new OleDbCommand("select * from wordData order by ID desc", conn);
DataSet ds = new DataSet();
oda.Fill(ds,"wordData");
int page=0;
if (Request.QueryString["page"] != null)
{
page=Convert.ToInt16(Request.QueryString["page"]);
}
PagedDataSource pds = new PagedDataSource();
pds.DataSource = ds.Tables[0].DefaultView;
pds.AllowPaging = true;
pds.PageSize = 4;
if (page >= pds.PageCount) //如果传递过来的页码大于最大页码,则取最大页码
{
page = pds.PageCount-1;
}
pds.CurrentPageIndex = page;
this.Repeater1.DataSource = pds;
this.Repeater1.DataBind();
Response.Write("pagecount=" + pds.PageCount.ToString()); //最大页码
}
}
********************************************Jscript.js**************************************************
function $(eid)
{
return document.getElementById(eid);
}
function chk()
{
if( $("username").value=="" )
{
alert("姓名不能为空!");
$("username").focus();
}
else if( $("qq").value=="" )
{
alert("QQ不能为空!");
$("qq").focus();
}
else if( $("mail").value=="" )
{
alert("邮箱不能为空!");
$("mail").focus();
}
else if( $("txt").value=="" )
{
alert("内容不能为空!");
$("txt").focus();
}
else
{
arguments[0].disabled=true;
arguments[0].value="发送中…";
var sex="男";
if($("sexb").checked==true)
{
sex="女";
}
var strdata;
strdata="username="+$("username").value; //姓名
strdata+="&sex="+sex; //性别
strdata+="&bb="+$("qq").value; //QQ
strdata+="&mail="+$("mail").value; //邮箱
strdata+="&txt="+$("txt").value;
var xmlhttp;
if(window.ActiveXObject)
{
try
{
xmlhttp=new ActiveXObject("msxml2.xmlhttp.3.0");
}
catch(e)
{
xmlhttp=new ActiveXObject("microsoft.xmlhttp");
}
}
else if(window.XMLHttpRequest)
{
xmlhttp=new XMLHttpRequest();
}
// xmlhttp.open("post","write.aspx?add=yes&st="+new Date().getTime(),true);
xmlhttp.open("post","write.aspx?add=yes")
xmlhttp.setRequestHeader("content-type","application/x-www-form-urlencoded");
xmlhttp.send(strdata);
xmlhttp.onreadystatechange=function()
{
if(xmlhttp.readystate==4)
{
if(xmlhttp.status==200)
{
$("btn_submit").disabled=false;
$("btn_submit").value="确定留言";
alert("留言成功!");
window.location.href="message.aspx";
}
else
{
alert("服务返回错误!");
}
}
}
}
}
function firstpage()
{
document.getElementById("left_word").innerHTML="加载留言中……";
getpagedata(0);
document.getElementById("page").innerHTML=1;
}
function previoustpage()
{
var page=parseInt(document.getElementById("page").innerHTML);
if(page<=1)
{
alert("不能再上一页了");
}
else
{
document.getElementById("left_word").innerHTML="加载留言中……";
page=page-1;
getpagedata(page-1);
document.getElementById("page").innerHTML=page;
}
}
function nextpage()
{
var page=parseInt(document.getElementById("page").innerHTML);
var pagecount=parseInt(document.getElementById("pagecount").innerHTML);
if(page>=pagecount)
{
alert("不能再下一页了");
}
else
{
document.getElementById("left_word").innerHTML="加载留言中……";
var page=parseInt(document.getElementById("page").innerHTML);
getpagedata(page);
page=page+1;
document.getElementById("page").innerHTML=page;
}
}
function lastpage()
{
var page=parseInt(document.getElementById("pagecount").innerHTML);
getpagedata(page-1);
document.getElementById("page").innerHTML=page;
}
function getpagedata(page)
{
var xmlhttp;
if(window.ActiveXObject)
{
try
{
xmlhttp=new ActiveXObject("msxml2.xmlhttp.3.0");
}
catch(e)
{
xmlhttp=new ActiveXObject("microsoft.xmlhttp");
}
}
else if(window.XMLHttpRequest)
{
xmlhttp=new XMLHttpRequest();
}
xmlhttp.open("get","getwordData.aspx?page="+page+"&st="+new Date().getTime(),true);
xmlhttp.onreadystatechange=function()
{
if(xmlhttp.readystate==4)
{
if(xmlhttp.status==200)
{
var strhtml=xmlhttp.responseText;
var pagecount; //最大页码数
pagecount=strhtml.match(/pagecount/=/d+/); //在返回的数据中,匹配出最大页码
pagecount=parseInt(pagecount[0].split("=")[1]);
strhtml=(strhtml.match(/<table[/s/S]*table>/g))[0];
document.getElementById("left_word").innerHTML=strhtml;
document.getElementById("pagecount").innerHTML=pagecount;
}
else
{
alert("服务器返回错误!");
}
}
}
xmlhttp.send(null);
}
getpagedata(0);