• λ我爱Aspx >> C#.Net >> 用ASP.Net编写留言本
  • 用ASP.Net编写留言本

  • :aspxer  Դ:internet  :2007-5-12 7:52:55  ؼ:.net,asp.net,asp
  • 1、用Access建造一个数据库data.mdb,建立表Guest,结构如下:

    ID 自动编号

    标题 字符串

    署名 字符串

    正文 备注。

    2、guest.ASPx

    <%@ Import Namespace="System.Data" %>

    <%@ Import Namespace="System.Data.OleDb" %>

    <html><head>

    <style>

    <!--

    body{font-size:9pt}

    p{font-size:9pt}

    td{font-size:9pt}

    //-->

    </style>

    <title>留言本</title></head>

    <body>

    <p align=right><font size=6>留言本</font></p>

    <script language=VB runat=server>

    Sub Page_Load(Source As Object, E As EventArgs)

    Dim myConn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=" & server.mappath("data.mdb"))

    Dim myAdapter As New OleDbDataAdapter

    Dim myOleDbCommandBuilder As OleDbCommandBuilder = New OleDbCommandBuilder(myAdapter)

    Dim DS As DataSet = New DataSet

    myAdapter.SelectCommand = new OleDbCommand("select ID, 标题, 署名 from Guest order by id desc", myconn)

    myconn.open()

    myAdapter.Fill(ds, "Guest")

    ml.DataSource=ds.Tables("Guest").DefaultView

    ml.DataBind()

    end sub

    </script>

    <ASP:DataGrid id="ml" runat="server"

    Width="100%"

    BorderColor="black"

    ShowFooter="false"

    CellPadding=3

    CellSpacing="0"

    Font-Name="宋体"

    Font-Size="9pt"

    Ҷƪл˵?
  • һƪAsp Object 之:Write
    һƪ如何把ASP编写成DLL(1)