?? replymessage.aspx
字號:
<%@ Page Language="C#" EnableSessionState="False" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<html><head>
<title>發布新問題</title>
<script Language="C#" runat="server">
DataSet ds ,rs;
DataRow dr ;
string postid ;
public void Page_Load(object sender , EventArgs e)
{
//檢查該頁面是否第一次被裝載
if(!Page.IsPostBack)
{
//從查詢字符串中得到 postid
postid = Request.Params["postid"] ;
if(postid!=null)
{
//數據庫連接字符串.
string strConn=@"Provider=Microsoft.Jet.OLEDB.4.0;";
strConn+="Data Source="+Server.MapPath(".\\database\\qa.mdb") ;
//生成一個數據庫連接
OleDbConnection myConn = new OleDbConnection(strConn) ;
//從 newpost 表中查詢記錄
string strCon ="SELECT subject, name, email, message ,dt FROM newpost ";
strCon+="WHERE postid="+postid ;
//設置一個 OleDbDataAdapter
OleDbDataAdapter myCommand =new OleDbDataAdapter(strCon,strConn);
ds = new DataSet();
//數據填充 DataSet
myCommand.Fill(ds,"newpost") ;
dr = ds.Tables["newpost"].Rows[0] ;
//取得主題的內容
subject.Text="Re:"+dr["subject"].ToString() ;
//選擇回復從回復的表格中
strCon ="SELECT name , email, subject, message ,dt FROM reply ";
strCon+="WHERE postid="+postid ;
//為回復表格生成一個新的 OleDbDataAdapter and DataSet
OleDbDataAdapter myCommand2 =new OleDbDataAdapter(strCon,strConn);
rs = new DataSet() ;
//填充 DataSet
myCommand2.Fill(rs, "reply") ;
strCon ="SELECT views FROM newpost WHERE postid = "+postid ;
//生成一個 OleDbCommand 在生成 OleDbDataReader 以后
OleDbCommand vicomm = new OleDbCommand(strCon, myConn) ;
myConn.Open();
OleDbDataReader reader ;
//生成一個 OleDbDataReader
reader = vicomm.ExecuteReader() ;
//讀出第一條記錄
reader.Read() ;
int i = reader.GetInt32(0) ;
//增加數量
i++ ;
reader.Close() ;
//更新數據表 newpost
strCon ="UPDATE newpost SET views = "+i+" WHERE (postid= "+postid+")" ;
vicomm.CommandText = strCon ;
vicomm.ExecuteNonQuery() ;
//關閉連接
myConn.Close();
}
}
}
// 這個事件被觸發當submit按鈕被提交的時候
public void Submit_Click(Object sender, EventArgs e)
{
//得到 postid
postid = Request.Params["postid"] ;
//當頁面有效的時候繼續
if(Page.IsValid){
DateTime now = DateTime.Now ;
errmess.Text="" ;
string req = "name="+ System.Web.HttpUtility.UrlEncode(name.Text,
System.Text.Encoding.UTF8);
req+="&&email="+ System.Web.HttpUtility.UrlEncode(email.Text,
System.Text.Encoding.UTF8);
req+="&&subject="+System.Web.HttpUtility.UrlEncode(subject.Text,
System.Text.Encoding.UTF8);
req+="&&ip="+System.Web.HttpUtility.UrlEncode(Request.UserHostAddress.ToString(),
System.Text.Encoding.UTF8);
req+="&&date="+ System.Web.HttpUtility.UrlEncode(now.ToString(),
System.Text.Encoding.UTF8);
req+="&&message="+ System.Web.HttpUtility.UrlEncode(message.Text,
System.Text.Encoding.UTF8);
req+="&&newpost="+ System.Web.HttpUtility.UrlEncode("no",
System.Text.Encoding.UTF8);
req+="&&previd="+ System.Web.HttpUtility.UrlEncode(postid,
System.Text.Encoding.UTF8);
Response.Redirect("postmessage.aspx?" + req);
}
else
{
errmess.Text="必須填入所有的內容!" ;
}
}
</script>
<LINK href="style.css" type=text/css rel=stylesheet></head>
<body topmargin="0" leftmargin="0" rightmargin="0" marginwidth="0" marginheight="0">
<br>
<div align=center>
<table border=0 width=80% cellspacing=2>
<tr class=fohead><th width=20%>作者姓名</th>
<th width=80%>內容</th></tr>
<tr class=folight><td rowspan=2 align="center">
<%= "<a href=mailto:"+dr["email"]+">"+dr["name"]+"</a>" %><br>
<font size=1><%= DateTime.Parse(dr["dt"].ToString()).ToShortDateString() %><br>
<%= DateTime.Parse(dr["dt"].ToString()).ToShortTimeString() %></font>
</td>
<td><b>主題: </b><%=dr["subject"] %></td></tr>
<tr class=folight>
<td><%=dr["message"] %> </td>
</tr>
<%-- 得到所有的回復和初始的內容 --%>
<% int no = rs.Tables["reply"].Rows.Count ;
if(no>0)
{
for(int j=0 ;j<no ; j++)
{
DataRow rd = rs.Tables["reply"].Rows[j] ;
%>
<tr class=fodark>
<td align="center"><%="<a href=mailto:"+rd["email"]+">"+rd["name"]+"</a>" %><br>
<font size=1><%= DateTime.Parse(rd["dt"].ToString()).ToShortDateString() %><br>
<%= DateTime.Parse(rd["dt"].ToString()).ToShortTimeString() %></font>
</td>
<td><%=rd["message"] %> </td>
</tr>
<%
}
}
%>
</table>
</div>
<h3 align="center" class="fodark">
<a href=qa.aspx>單擊這里</a> 回到Q&A首頁.
<br><br>回復上面的內容.</h3>
<br>
<asp:label id="errmess" text="" style="COLOR:#ff0000" runat="server" />
<form runat="server">
<table border="0" width="80%" align="center">
<tr >
<td class="fohead" colspan=2><b>回復這個問題</b></td>
</tr>
<tr class="folight" >
<td>Name :</td>
<td ><asp:textbox text="" id="name" runat="server" />
<asp:RequiredFieldValidator ControlToValidate=name display=Dynamic runat=server>
*</asp:RequiredFieldValidator></td>
</tr>
<tr class="folight">
<td>E-Mail :</td>
<td><asp:textbox text="" id="email" runat="server"/>
<asp:RequiredFieldValidator ControlToValidate=email display=Dynamic runat=server>
*</asp:RequiredFieldValidator>
<asp:RegularExpressionValidator runat="server"
ControlToValidate="Email"
ValidationExpression="[\w-]+@([\w-]+\.)+[\w-]+"
Display="Dynamic"
Font-Name="verdana" Font-Size="10pt"
ErrorMesage="請您輸入一個有效的Email地址">
</asp:RegularExpressionValidator></td>
</tr>
<tr class="folight">
<td> 問題:</td>
<td><asp:textbox test="" id="subject" width=200 runat="server"/>
<asp:RequiredFieldValidator ControlToValidate=subject display=Dynamic runat=server>
*</asp:RequiredFieldValidator>
</td></tr>
<tr class="folight">
<td>內容 :</td>
<td>
<asp:TextBox id=message runat="server"
Columns="30" Rows="15" TextMode="MultiLine"></asp:TextBox></td>
</tr>
<tr class=folight>
<td colspan=2>
<asp:Button class=fodark id=write onClick=Submit_Click runat="server" Text="Submit">
</asp:Button></td></tr>
</table>
</form><br>
<br>
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -