📄 showdiary.aspx
字号:
<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="gb2312" %>
<%@ Import Namespace="system.data" %>
<%@ Import Namespace="system.data.oledb" %>
<script runat="server">
dim conn as new oledbconnection("provider=microsoft.jet.oledb.4.0; data source="+server.MapPath("data/diary.mdb"))
dim ds as new dataset("my")
sub page_load(obj as object,e as eventargs)
filldatagrid()
end sub
sub dgdata_pageindexChanged(obj as object,e as datagridpagechangedeventargs)
dgdata.currentpageindex=e.newPageindex
dgdata.databind()
filldatagrid()
end sub
sub filldatagrid()
ds.clear()
dim sql as string="select * from diary order by d_id desc"
dim objcmd as new oledbdataAdapter(sql,conn)
objcmd.fill(ds, "diary")
dgdata.datasource=ds
dgdata.datamember="diary"
dgdata.databind()
end sub
</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>查看记录</title>
<link href="site_css.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#FFFFFF" text="#000000" background="images/bg1.gif">
<form runat="server">
<asp:datagrid ID="dgdata" runat="server" BorderStyle="none" BorderWidth="0" Font-Name="arial" Font-Size="8pt" CellPadding="4" CellSpacing="0" Width="100%" AutoGenerateColumns="false" ShowHeader="true" ShowFooter="true" OnPageIndexChanged="dgdata_pageindexChanged" AllowPaging="true" PageSize="10" PagerStyle-Mode="numericpages" PagerStyle-Font-Name="arial" PagerStyle-PageButtonCount="5" PagerStyle-HorizontalAlign="right">
<columns>
<asp:TemplateColumn>
<headertemplate>
<table width="760" border="0" cellspacing="1" cellpadding="6" align="center" bgcolor="#293863">
<tr>
<td class="diaryhead">查看日记</td>
</tr>
</headertemplate>
<itemtemplate>
<tr>
<td bgcolor="#FFFFFF" class="chinese"><br>
<%# container.dataitem("d_content")%>
<div align="right"><br>
<br>
<img src="images/SIGN.GIF" width="299" height="12"><br>
第<span class="newshead"><%# container.dataitem("d_id")%></span>篇，发表于-<span class="newshead"><%# container.dataitem("d_date")%></span></div></td>
</tr>
</itemtemplate>
<footertemplate>
<tr>
<td bgcolor="#FFFFFF" class="chinese">[<a href="#;" onclick="window.close()">关闭窗口</a>]</td>
</tr>
</table>
</footertemplate>
</asp:TemplateColumn>
</columns>
</asp:DataGrid>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -