📄 guestbook.aspx
字号:
public void lbref()
{
panrel.Visible=true;
lk.Visible=false;
string refsql="select * from ly where id="+Request.QueryString["id"];
OleDbConnection con=new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="+Server.MapPath("ly.mdb"));
OleDbDataAdapter da=new OleDbDataAdapter(refsql,con);
DataSet ds=new DataSet();
try
{
da.Fill(ds,"xxlist");
dgrel.DataSource=ds.Tables["xxlist"].DefaultView;
dgrel.DataBind();
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
public void butrefok(Object Src,EventArgs E)
{
string refcontent=Txtref.Text;
string hfsql="update ly set rel='"+refcontent+"' where id="+Request.QueryString["id"];
OleDbConnection con=new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="+Server.MapPath("ly.mdb"));
OleDbCommand cmd=new OleDbCommand(hfsql,con);
try
{
con.Open();
cmd.ExecuteNonQuery();
Response.Write("<script>alert('回复留言成功！');location.href='guestbook.aspx';<"+"/"+"script>");
}
catch(Exception ex)
{
//string cw+=Page.Error;
//Response.Write(ex.ToString());
xxx.Text=ex.ToString();
//Response.Write("<script>alert('回复留言失败！');location.href='guestbook.aspx';<"+"/"+"script>");
}
finally
{
con.Close();
}
}
public void Butlog_Click(Object Src,EventArgs e)
{
string admsql="select * from admins where adminame='"+Txtadmin.Text+"'";
//Response.Write(admsql);
string adminpass=Request.Form["Txtpass"].Trim();
OleDbConnection con=new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="+Server.MapPath("ly.mdb"));
OleDbCommand cmd=new OleDbCommand(admsql,con);
con.Open();
OleDbDataReader rs=cmd.ExecuteReader();
try
{
if(rs.Read())
{
if(rs["adminpass"].ToString()==adminpass)
{
admin.Visible=false;
xie.Visible=false;
lk.Visible=true;
panrel.Visible=false;
sys.Text="退出管理";
Session["lyadmin"]=adminpass;
//glxx.Visible=true;
//gs.Visible=false;
Response.Redirect("guestbook.aspx");
//Response.Write("OK");
//Response.Write(rs["adminame"].ToString());
}
else
{
xxx.Text="<h2>您的管理密码错误！</h2>";
}
}
else
{
xxx.Text="<h2>您的用户名错误！</h2>";
//Response.Write(rs["adminame"].ToString());
}
}
catch (Exception ex)
{
xxx.Text=ex.ToString();
}
finally
{
con.Close();
}
}
</script><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>寒冰冷水 ASP.NET 留言板 V1.0</title>
<link href="aspx.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
-->
</style>
</head>
<body>
<asahi:head id="tt" runat=server></asahi:head>
<form runat="server">
<center>
<br>
<asp:LinkButton ID="look" Text="查看留言" OnClick="look_click" runat="server"></asp:LinkButton>
<asp:LinkButton ID="qxie" Text="签写留言" OnClick="qxie_click" runat="server"></asp:LinkButton>
<asp:LinkButton ID="sys" Text="留言管理" OnClick="sys_click" runat="server"></asp:LinkButton><hr align="center" width="680" size="1" noshade>
<br>
</center>
<asp:Panel runat="server" Visible="false" ID="xie">
<table width="630" border="0" align="center" cellpadding="3" cellspacing="1">
<tr>
<td colspan="3"> </td>
</tr>
<tr>
<td>您的大名：</td>
<td><asp:TextBox ID="txtName" runat="server" /></td>
<td rowspan="5" align="center" valign="middle"><asp:Image ID="imglog" ImageUrl="images/1.gif" runat="server" /> </td>
</tr>
<tr>
<td>E-mail：</td>
<td><asp:TextBox ID="txtMail" runat="server" />
</td>
</tr>
<tr>
<td>您的主页：</td>
<td><asp:TextBox ID="txtHttp" runat="server" /></td>
</tr>
<tr>
<td>OICQ号码：</td>
<td><asp:TextBox ID="txtOicq" runat="server" /></td>
</tr>
<tr>
<td>您的形象：</td>
<td><asp:DropDownList ID="DroLog" OnSelectedIndexChanged="Logclick" runat="server" AutoPostBack="true">
</asp:DropDownList></td>
</tr>
<tr>
<td>留言主题:</td>
<td colspan="2"><asp:TextBox ID="txtObj" runat="server" /></td>
</tr>
<tr>
<td>留言内容:</td>
<td colspan="2"><asp:TextBox ID="txtContent" runat="server" TextMode="MultiLine" Columns="55" Rows="8" /></td>
</tr>
<tr>
<td> </td>
<td colspan="2"><asp:Button ID="ButOk" OnClick="ButOk_Click" Text="提交留言" runat="server" /></td>
</tr>
</table>
</asp:Panel>
<asp:Panel ID="lk" runat="server">
<table width="630" border="0" align="center" cellpadding="3" cellspacing="1">
<tr>
<td><asp:Repeater ID="dglist" OnItemCommand="dglist_click" runat="server">
<ItemTemplate>
<table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="#000000">
<tr>
<td width="120" align="center" valign="middle" bgcolor="#FFFFFF">
<img src="<%# DataBinder.Eval(Container.DataItem,"logo") %>"><br>
<%# DataBinder.Eval(Container.DataItem,"name") %>
</td>
<td valign="top" bgcolor="#FFFFFF">
<div id="nr"><div class="nrtou" id="nrtou">主题：<%# ((DataRowView)Container.DataItem)["biaoti"] %></div>
<div align="right" style="BORDER-RIGHT: gray 1px dotted; BORDER-TOP: gray 1px dotted; BORDER-LEFT: gray 1px dotted; BORDER-BOTTOM: gray 1px dotted;">
<a href="#" title="<%# ((DataRowView)Container.DataItem)["oicq"] %>"><img border="0" src="images/oicq.gif"></a> <a href="mailto:<%# ((DataRowView)Container.DataItem)["mail"] %>" title="<%# ((DataRowView)Container.DataItem)["mail"] %>"><img border="0" src="images/email.gif"></a> <a href="<%# ((DataRowView)Container.DataItem)["http"] %>" title="访问主页" target="_blank"><img border="0" src="images/homepage.gif"></a>
<a href="#" title="<%# ((DataRowView)Container.DataItem)["ip"] %>"><img border="0" src="images/ip.gif"></a>
</div>
<hr size="1" noshade>
<div id="nrcon"><%# ((DataRowView)Container.DataItem)["content"] %></div>
<hr size="1" noshade>
<div align="right" id="nrfoot" style="BORDER-RIGHT: gray 1px dotted; BORDER-TOP: gray 1px dotted; BORDER-LEFT: gray 1px dotted; BORDER-BOTTOM: gray 1px dotted">
<asp:Panel ID="glxx" Visible="true" runat="server"><a href="guestbook.aspx?id=<%# DataBinder.Eval(Container.DataItem,"id") %>&action=ref">回复留言</a>
<a href="guestbook.aspx?id=<%# DataBinder.Eval(Container.DataItem,"id") %>&action=del">删除留言</a> 留言时间：<%# DataBinder.Eval(Container.DataItem,"sj") %></asp:Panel>
<asp:Panel ID="gs" Visible="false" runat="server">留言时间：<%# DataBinder.Eval(Container.DataItem,"sj") %></asp:Panel></div></div></td>
</tr>
<tr bgcolor="#efefef">
<td align="center">站长回复</td>
<td> <%# ((DataRowView)Container.DataItem)["rel"] %></td>
</tr>
</table>
<br>
</ItemTemplate>
</asp:Repeater>
<asp:Label ID="lblnull" Text="对不起，还没有留言信息！" runat=server />
<div style="padding:5px;background-color:#dedede">
<asp:label ID="lblCurrentPage" runat="server"></asp:label>
<asp:HyperLink id="lnkPrev" runat="server">上一页</asp:HyperLink>
<asp:HyperLink id="lnkNext" runat="server">下一页</asp:HyperLink>
</div></td>
</tr>
</table>
</asp:Panel>
<asp:Panel ID="pandg" Visible="false" runat="server"><br>
<br>
<br>
<br>
<asp:DataGrid ID="dg" runat="server"></asp:DataGrid>
</asp:Panel>
<asp:Panel ID="panrel" runat="server">
<table width="630" border="0" align="center" cellpadding="3" cellspacing="1">
<tr>
<td>
<table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="#000000">
<asp:Repeater ID="dgrel" OnItemCommand="dglist_click" runat="server">
<ItemTemplate><tr>
<td width="100" align="center" bgcolor="#FFFFFF">
<img src="<%# ((DataRowView)Container.DataItem)["logo"] %>"><br>
<%# ((DataRowView)Container.DataItem)["name"] %>
</td>
<td valign="top" bgcolor="#FFFFFF"><div id="nrtou"><%# ((DataRowView)Container.DataItem)["biaoti"] %></div> <div id="nrcon"><%# ((DataRowView)Container.DataItem)["content"] %></div>
<div id="nrfoot">留言时间：<%# ((DataRowView)Container.DataItem)["sj"] %></div></td>
</tr>
</ItemTemplate>
</asp:Repeater>
<tr bgcolor="#efefef">
<td align="center">站长回复</td>
<td>
<asp:TextBox ID="Txtref" runat="server" TextMode="MultiLine" Columns="45" Rows="5" Text="" />
<asp:Button ID="Butrefok" runat="server" Text="提交回复" OnClick="butrefok" /></td>
</tr>
</table>
</td>
</tr>
</table>
</asp:Panel>
<asp:Panel ID="admin" runat="server" Visible="false">
<table width="630" border="0" align="center" cellpadding="3" cellspacing="1">
<tr align="center">
<td height="30" colspan="2"><h2><strong>对不起，您还没有登陆请先登陆</strong></h2></td>
</tr>
<tr>
<td width="40%" align="right">用户名：</td>
<td><asp:TextBox ID="Txtadmin" runat="server" /></td>
</tr>
<tr>
<td align="right">密 码：</td>
<td><asp:TextBox ID="Txtpass" runat="server" TextMode="Password" /></td>
</tr>
<tr>
<td> </td>
<td><asp:Button ID="Butlog" OnClick="Butlog_Click" runat="server" Text="登陆" /></td>
</tr>
</table>
</asp:Panel>
<asp:Label ID="xxx" runat="server"></asp:Label>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -