简易留言薄GuestBook
Adinm页面：
Code<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Admin.aspx.cs" Inherits="Admin" %>
<!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>
</div>
<asp:Label ID="Label1" runat="server" Text="用户名"></asp:Label>
<asp:TextBox ID="tb_UserName" runat="server"></asp:TextBox>
<p>
<asp:Label ID="Label2" runat="server" Text="密码"></asp:Label>
<asp:TextBox ID="tb_Password" runat="server"></asp:TextBox>
<asp:Button ID="btn_Login" runat="server" Text="登录" onclick="btn_Login_Click" />
</p>
<asp:Repeater ID="rpt_Message" runat="server"
onitemcommand="rpt_Message_ItemCommand">
<ItemTemplate>
<table width="300px" style="border:solid lpx #666666;font-size:10pt;background-color:#f0f0f0" >
<tr>
<td align="left" width="400px">
<%# Eval("Message") %>>
</td>
<td align="right" width="200px">
<%#Eval("PostTime") %>-<%#Eval("UserName") %>
</td>
</tr>
<tr>
<td colspan="2" align="right">
<hr width="300px"/>
<asp:Button ID="btn_DeleteMessage" runat="server" Text="删除留言" CommandName="DeleteMessage" CommandArgument='<%#Eval("ID") %>'/>
管理员回复：<asp:TextBox runat="server" ID="tb_Reply" TextMode="MultiLine" Width="300px" Text='<% #Eval("Reply")%>'/>
<asp:Button ID="btn_SendReply" runat="server" Text="发表回复" CommandName="SendReply" CommandArgument='<%#Eval("ID")%>'/>
</td>
</tr>
</table>
<br/>
</ItemTemplate>
</asp:Repeater>
</form>
</body>
</html>
Admin cs代码：
Codeusing System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Admin : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["AdminCheck"] != null)
{
SetBind();
}
}
}
protected void btn_Login_Click(object sender, EventArgs e)
{
if (tb_UserName.Text == "admin" && tb_Password.Text == "admin")
{
Session["AdminCheck"] = "OK";
Response.Redirect(Request.Url.ToString());
}
}
private void SetBind()
{
SqlConnection conn = new SqlConnection("server=PC-200807121850;database=GuestBook;Trusted_Connection=True");
string Sql = "SELECT*FROM tbGuestBook ORDER BY PostTime DESC";
SqlDataAdapter da = new SqlDataAdapter(Sql, conn);
DataSet ds = new DataSet();
da.Fill(ds);
DataTable dt = ds.Tables[0];
rpt_Message.DataSource = dt;
rpt_Message.DataBind();
}
protected void rpt_Message_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "DeleteMessage")
{
SqlConnection conn = new SqlConnection("server=PC-200807121850;database=GuestBook;Trusted_Connection=True");
string Sql = "DELETE FROM tbGuestBook WHERE ID='" + e.CommandArgument + "'";
SqlCommand cmd = new SqlCommand(Sql, conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
SetBind();
}
if (e.CommandName == "SendReply")
{
SqlConnection conn = new SqlConnection("server=PC-200807121850;database=GuestBook;Trusted_Connection=True");
string Sql = "UPDATE tbGuestBook SET IsReplied=1,Reply='" + ((TextBox)e.Item.FindControl("tb_Reply")).Text + "'WHERE ID='" + e.CommandArgument + "'";
SqlCommand cmd = new SqlCommand(Sql, conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
SetBind();
}
}
protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
{
}
protected void PasswordRecovery1_SendingMail(object sender, MailMessageEventArgs e)
{
}
}
Default页面：
Code<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!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>
</div>
<asp:Label ID="Label1" runat="server" Text="姓名"></asp:Label>
<asp:TextBox ID="tb_UserName" runat="server"></asp:TextBox>
<p>
</p>
<asp:Label ID="Label2" runat="server" Text="留言"></asp:Label>
<asp:TextBox ID="tb_Message" runat="server" Height="234px" TextMode="MultiLine"
Width="355px"></asp:TextBox>
<p>
<asp:Button ID="btn_SendMessage" runat="server" onclick="btn_SendMessage_Click" Text="发表留言" />
<asp:Repeater ID="rpt_Message" runat="server">
<ItemTemplate>
<table width="600px" style="border:solid lpx #666666;font-size:10pt;background-color:#f0f0f0" >
<tr>
<td align="left" width="400px">
<%# Eval("Message") %>>
</td>
<td align="right" width="200px">
<%#Eval("PostTime") %>-<%#Eval("UserName") %>
</td>
</tr>
<tr>
<td colspan="2" align="right">
<hr width="300px"/>
管理员回复：<%#Eval("IsReplied").ToString()=="False" ? "暂无" :Eval("Reply")%>
</td>
</tr>
</table>
<br/>
</ItemTemplate>
</asp:Repeater>
</p>
</form>
</body>
</html>
Default cs代码：
Codeusing System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SetBind();
}
}
protected void btn_SendMessage_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("server=PC-200807121850;database=GuestBook;Trusted_Connection=True");
string Sql = "INSERT INTO tbGuestBook(UserName,PostTime,Message,IsReplied,Reply) values ('"+tb_UserName.Text+"','"+DateTime.Now+"','"+tb_Message.Text+"',0,'')";
SqlCommand cmd = new SqlCommand(Sql,conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
SetBind();
}
private void SetBind()
{
SqlConnection conn = new SqlConnection("server=PC-200807121850;database=GuestBook;Trusted_Connection=True");
string Sql = "SELECT*FROM tbGuestBook ORDER BY PostTime DESC";
SqlDataAdapter da = new SqlDataAdapter(Sql, conn);
DataSet ds = new DataSet();
da.Fill(ds);
DataTable dt = ds.Tables[0];
rpt_Message.DataSource = dt;
rpt_Message.DataBind();
}
}
浙公网安备 33010602011771号