viewnews.aspx.vb

来自「后台管理 内容添加功能」· VB 代码 · 共 57 行

Imports System.Data.oledb


Namespace DotNet2000

Partial Class ViewNews
    Inherits System.Web.UI.Page

#Region " Web 窗体设计器生成的代码 "

    '该调用是 Web 窗体设计器所必需的。
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

    End Sub

    '注意: 以下占位符声明是 Web 窗体设计器所必需的。
    '不要删除或移动它。

    Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
        'CODEGEN: 此方法调用是 Web 窗体设计器所必需的
        '不要使用代码编辑器修改它。
        InitializeComponent()
    End Sub

#End Region

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        '在此处放置初始化页的用户代码
        Dim Conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(DbPath))
        Dim SqlStr As String = "select * from News where ID=" & Request("id")
        Dim SqlCommand As New OleDbCommand(SqlStr, Conn)
        Conn.Open()

        Dim Rs As OleDbDataReader = SqlCommand.ExecuteReader

        While Rs.Read()
            TitleTxt.Text = Rs.Item("NewsTitle")
            ContentTxt.Text = HtmlCode(Rs.Item("NewsContent"))
            NameTxt.Text = "发布人：" & Rs.Item("UserName") & "　发布日期：" & Rs.Item("TimeStr")
        End While

        Rs.Close()
        Conn.Close()

    End Sub
    Function HtmlCode(ByVal fString)
        If fString <> "" Then
            fString = Replace(fString, Chr(13), "")
            fString = Replace(fString, Chr(10) & Chr(10), "</P><P>")
            fString = Replace(fString, Chr(10), "<BR>")
            HtmlCode = fString
        End If
    End Function
End Class

End Namespace