浅谈“三层结构”原理与用意 2
#001 <%@ page language="c#" codebehind="listlword.aspx.cs" autoeventwireup="false"
inherits="tracelword1.listlword" %>
#002 <!doctype html public "-//w3c//dtd html 4.0 transitional//en">
#003
#004 <html>
#005 <head>
#006 <title>listlword</title>
#007 <meta name="generator" content="microsoft visual studio .net 7.1">
#008 <meta name="code_language" content="c#">
#009 <meta name=vs_defaultclientscript content="javascript">
#010 <meta name=vs_targetschema content="http://schemas.microsoft.com/intellisense/ie5">
#011 </head>
#012 <body ms_positioning="gridlayout">
#013
#014 <form id="__aspnetform" method="post" runat="server">
#015
#016 <a href="postlword.aspx">发送新留言</a>
#017
#018 <asp:datalist id="m_lwordlistctrl" runat="server">
#019 <itemtemplate>
#020 <div>
#021 <%# databinder.eval(container.dataitem, "posttime") %>
#022 <%# databinder.eval(container.dataitem, "textcontent") %>
#023 </div>
#024 </itemtemplate>
#025 </asp:datalist>
#026
#027 </form>
#028
#029 </body>
#030 </html>
以最普通的设计方式制作留言板,效率很高。
这些代码可以在visual studio.net 2003开发环境的设计视图中快速建立。
listlword.aspx 后台程序文件 listlword.aspx.cs
#001 using system;
#002 using system.collections;
#003 using system.componentmodel;
#004 using system.data;
#005 using system.data.oledb; // 需要操作 access 数据库
#006 using system.drawing;
#007 using system.web;
#008 using system.web.sessionstate;
#009 using system.web.ui;
#010 using system.web.ui.webcontrols;
#011 using system.web.ui.htmlcontrols;
#012
#013 namespace tracelword1
#014 {
#015 /// <summary>
#016 /// listlword 列表留言板信息
#017 /// </summary>
#018 public class listlword : system.web.ui.page
#019 {
#020 // 留言列表控件
#021 protected system.web.ui.webcontrols.datalist m_lwordlistctrl;
#022
#023 /// <summary>
#024 /// listlword.aspx 页面加载函数
#025 /// </summary>
#026 private void page_load(object sender, system.eventargs e)
#027 {
#028 lword_databind();
#029 }
#030
#031 #region web 窗体设计器生成的代码
#032 override protected void oninit(eventargs e)
#033 {
#034 initializecomponent();
#035 base.oninit(e);
#036 }
#037
#038 private void initializecomponent()
#039 {
#040 this.load+=new system.eventhandler(this.page_load);
#041 }
#042 #endregion
#043
#044 /// <summary>
#045 /// 绑定留言信息列表
#046 /// </summary>
#047 private void lword_databind()
#048 {
#049 string mdbconn=@"provider=microsoft.jet.oledb.4.0;
data source=c:\dbfs\tracelworddb.mdb";
#050 string cmdtext=@"select * from [lword] order by [lwordid] desc";
#051
#052 oledbconnection dbconn=new oledbconnection(mdbconn);
#053 oledbdataadapter dbadp=new oledbdataadapter(cmdtext, dbconn);
#054
#055 dataset ds=new dataset();
#056 dbadp.fill(ds, @"lwordtable");
#057
#058 m_lwordlistctrl.datasource=ds.tables[@"lwordtable"].defaultview;
#059 m_lwordlistctrl.databind();
#060 }
#061 }
#062 }