?? default.aspx
字號:
<%@ Page Language="C#" Debug="true" %>
<%@ Assembly Name="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System" %>
<html><head>
<title>第八日.NET</title>
<script language="C#" runat="server" >
int startIndex;
void Page_Load(Object Src, EventArgs E)
{
if(System.DateTime.Now.Hour>=5&&System.DateTime.Now.Hour<=12)
{label1.Text="朋友上午好，歡迎光臨第八日.NET！ ";
}
else if(System.DateTime.Now.Hour>=12&&System.DateTime.Now.Hour<=18)
{
label1.Text="朋友下午好，歡迎光臨第八日.NET！";
}
else if(System.DateTime.Now.Hour>=18&&System.DateTime.Now.Hour<=24)
{
label1.Text="朋友晚上好，歡迎光臨第八日.NET！";
}
else
{
label1.Text="朋友，這么晚還光臨第八日，太感動了！";
}
//檢查該頁面是否第一次被裝載
if(!IsPostBack)
{
//使用 Binding 的方法
Binding() ;
}
}
public void Binding()
{
//ACCESS數據庫的連接字符串
string strConn=@"Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=";
strConn+=Server.MapPath(".\\db\\d8net.mdb");
//生成一個新的連接
OleDbConnection myConn = new OleDbConnection(strConn) ;
string strCom;
//檢查該頁面是否第一次被裝載
if(!IsPostBack)
{
//設置變量的初始值
startIndex =0;
//查詢字符串
strCom = "SELECT TOP 1 postid FROM newpost ORDER BY postid DESC" ;
//生成一個查詢命令
OleDbCommand countCommand = new OleDbCommand(strCom, myConn);
//打開連接
myConn.Open();
//生成一個 DataReader
OleDbDataReader countReader = countCommand.ExecuteReader();
//檢查是否 DataReader 中有記錄
if(!countReader.Read())
{
//如果沒有記錄存在，設置一個虛擬計數
DataGrid1.VirtualItemCount=0;
}
else
{
//設置虛擬計數的總數
DataGrid1.VirtualItemCount= countReader.GetInt32(0);
}
//關閉連接
myConn.Close();
}
//設置顯示的記錄為20條
strCom = "SELECT TOP 20 postid ,subject ,name ,replies ,views ,dt FROM newpost ";
strCom+= "WHERE postid < "+(DataGrid1.VirtualItemCount-(startIndex-1) );
strCom+=" ORDER BY postid DESC" ;
OleDbCommand forumCommand = new OleDbCommand(strCom, myConn);
myConn.Open();
OleDbDataReader forumReader = forumCommand.ExecuteReader();
//設置數據源
DataGrid1.DataSource = forumReader ;
//數據綁定
DataGrid1.DataBind();
myConn.Close();
}
public void DataGrid_Updt(object sender, DataGridPageChangedEventArgs e)
{
//設置下一頁的索引值
DataGrid1.CurrentPageIndex = e.NewPageIndex;
//更新變量
startIndex = (DataGrid1.CurrentPageIndex * DataGrid1.PageSize);
//聲名數據綁定
Binding();
}
public void Submit_Click(Object sender, EventArgs e)
{
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);
//得到留言者的IP地址
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);
//yes是提示該信息是一個新值
req+="&&newpost="+ System.Web.HttpUtility.UrlEncode("yes", System.Text.Encoding.UTF8);
//返回文件postmessage.aspx 加入查詢.
Response.Redirect("postmessage.aspx?" + req);
}
else
{
errmess.Text="請輸入所有填寫項!<br>" ;
}
}
</script>
<LINK href="mystyle.css" type=text/css rel=stylesheet></head>
<body topmargin="0" leftmargin="0" rightmargin="0" marginwidth="0" marginheight="0">
<!-- #Include File="header.inc" -->
<center>
<asp:label id="errmess" text="" style="COLOR:#ff0000" runat="server" />
<br>
<asp:Label id="label1" class=fodark text="" runat=server />
<form method="post" runat="server" ID=Form1>
<%-- 設置 DataGrid 的屬性 --%>
<asp:DataGrid id=DataGrid1 runat="server" ForeColor="Black"
OnPageIndexChanged="DataGrid_Updt" PageSize="20" AllowPaging="True" width=722
autogeneratecolumns="False"
AllowCustomPaging="True"
>
<PagerStyle BackColor="#03a729" Mode="NumericPages">
</PagerStyle>
<AlternatingItemStyle BorderColor="#03a729" BackColor="#669900">
</AlternatingItemStyle>
<FooterStyle ForeColor="White" BackColor="#03a729">
</FooterStyle>
<ItemStyle BackColor="#75b602">
</ItemStyle>
<HeaderStyle Font-Bold="True" ForeColor="White" BackColor="#03a729">
</HeaderStyle>
<Columns>
<asp:TemplateColumn HeaderText="<font color=#ffffff size=2>主題</font>" itemstyle-width=30%>
<ItemTemplate>
<asp:Label runat="server" Text='<%#"<a href=reply.aspx?postid="+DataBinder.Eval(Container, "DataItem.postid")+">"
+"<font size=2>"+DataBinder.Eval(Container, "DataItem.subject")+"</font>"+"</a>" %>' ID=Label2></asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="<font color=#ffffff size=2>作者姓名</font>" itemstyle-width=20%>
<ItemTemplate>
<asp:Label runat="server" Text='<%# "<font size=2>"+DataBinder.Eval(Container, "DataItem.name")+"</font>" %>' ID=Label3></asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="<font color=#ffffff size=2>回復數</font>" itemstyle-width=10%>
<ItemTemplate>
<asp:Label runat="server" width=10% Text='<%# "<font size=2>"+DataBinder.Eval(Container, "DataItem.replies")+"</font>" %>' ID=Label4>
</asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="<font color=#ffffff size=2>查看</font>" itemstyle-width=10%>
<ItemTemplate>
<asp:Label runat="server" width=10% Text='<%# "<font size=2>"+DataBinder.Eval(Container, "DataItem.views")+"</font>" %>' ID=Label5>
</asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="<font color=#ffffff size=2>發布日期</font>" itemstyle-width=30%>
<ItemTemplate>
<asp:Label runat="server" width=50% Text='
<%# "<font size=2>"+DateTime.Parse(DataBinder.Eval(Container, "DataItem.dt").ToString()).ToShortDateString()+"</font>" %>' ID=Label6>
</asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:DataGrid>
<br>
<asp:Label class=fodark text="<font color=#00000 >發布新主題</font>" runat=server />
<br>
<table border="0" width=722 align="center">
<tr >
<td class="fohead" colspan=2><b>發布新主題</b></td>
</tr>
<tr class="folight" >
<td>名字 :</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="提交"></asp:Button></td></tr>
</table>
</form>
</center>
<!-- #Include File="footer.inc" -->
</body></html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -