📄 postthd.aspx
字号:
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<head><title>欣欣在线论坛</title>
<style type="text/css">
<!--
td{font-size:9pt;}
-->
</style>
<script language="C#" runat="server">
String strConn;
SqlConnection cn;
void Page_Load(Object Src, EventArgs E )
{
if((int)(Session["IsGood"])==0) { // 返回普通区
DisplayThd.NavigateUrl="display.aspx?subid="+Request.QueryString["subid"];
} else { // 返回精华区
DisplayThd.NavigateUrl="jinhua.aspx?subid="+Request.QueryString["subid"];
}
// 从Web.config文件中读取连接字符串
strConn=ConfigurationSettings.AppSettings["eForum"];
}
protected void PostBtn_Click(object sender, EventArgs e)
{
if (Page.IsValid) {
// 连接到eForum数据库
cn=new SqlConnection(strConn);
// 打开连接
cn.Open();
// 构造SQL语句，该语句往Threads表中添加一条记录
String strSQL="insert into Threads (SubId,Subject,NickName,"+
"SendTime,Body,Length) values (@SubId,@Subject,"+
"@NickName,@SendTime,@Body,@Length)";
// 创建Command对象
SqlCommand cm=new SqlCommand(strSQL,cn);
// 添加参数
cm.Parameters.Add(new SqlParameter("@SubId",SqlDbType.Int));
cm.Parameters.Add(new SqlParameter("@Subject",SqlDbType.NVarChar,40));
cm.Parameters.Add(new SqlParameter("@NickName",SqlDbType.NVarChar,20));
cm.Parameters.Add(new SqlParameter("@SendTime",SqlDbType.DateTime));
cm.Parameters.Add(new SqlParameter("@Body",SqlDbType.NVarChar,1000));
cm.Parameters.Add(new SqlParameter("@Length",SqlDbType.Int));
// 给参数赋值
cm.Parameters["@SubId"].Value=Request.QueryString["subid"];
cm.Parameters["@Subject"].Value=subject.Text;
cm.Parameters["@NickName"].Value=Session["UserName"];
cm.Parameters["@SendTime"].Value=DateTime.Now;
cm.Parameters["@Body"].Value=body.Text;
cm.Parameters["@Length"].Value=body.Text.ToString().Length;
// 执行ExecuteNonQuery()方法
cm.ExecuteNonQuery();
// 关闭连接
cn.Close();
Response.Write("<p><hr><center>");
Response.Write("<h1>恭喜!您的文章已张贴到论坛中!</h1>");
if((int)(Session["IsGood"])==0) { // 返回普通区
Response.Write("<b><font size=+2>");
Response.Write("<a href=display.aspx?subid="+
Request.QueryString["subid"]+">");
Response.Write("返回普通区</a></font></b>");
Response.Write("</center><p><hr>");
} else { // 返回精华区
Response.Write("<b><font size=+2>");
Response.Write("<a href=jinhua.aspx?subid="+
Request.QueryString["subid"]+">");
Response.Write("返回精华区</a></font></b>");
Response.Write("</center><p><hr>");
}
}
}
</script>
</head>
<body background="./images/gray.jpg">
<table width="100%">
<tr><td>
<asp:HyperLink runat="server" id="DisplayThd"
Text="[不张贴文章]" Target="_self" />
</td></tr>
</table>
<form runat="server">
<table width="100%">
<tr><td align="right" width="10%">主题:</td>
<td width="90%">
<asp:TextBox id="subject" Size="40"
MaxLength="40" runat="server" />**
<asp:RequiredFieldValidator id="RFV1"
ControlToValidate="subject"
Display="static" runat="server">不能为空
</asp:RequiredFieldValidator>
</td></tr>
<tr><td align="right">正文:</td>
<td>
<asp:TextBox id="body" Rows="4" Columns="50"
TextMode="Multiline" runat="server" />
</td></tr>
<tr><td colspan=2 align="center">
<asp:Button Text="张贴" OnClick="PostBtn_Click" runat="server" />
</td></tr>
</table>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -