reply.aspx.vb

毕业设计时做的,一个管理关于污染管理的, 源代码,呵呵 想想当时还真厉害,可以实现污染检测

Imports System
Imports System.ComponentModel
Imports System.Data
Imports System.Data.OleDb
Imports System.Web
Imports System.Web.SessionState
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Configuration
Imports Microsoft.VisualBasic

Public Class reply
    Inherits System.Web.UI.Page
    Protected WithEvents LB As System.Web.UI.WebControls.Label
    Protected WithEvents Button1 As System.Web.UI.WebControls.Button
    Protected WithEvents Button2 As System.Web.UI.WebControls.Button
    Protected WithEvents TB As System.Web.UI.WebControls.TextBox

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

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

    End Sub

    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
        If Session("name") <> ConfigurationSettings.AppSettings("站长") Then Response.Redirect("default.aspx")
        Dim ID As String, page As String
        ID = Request.QueryString("ID")
        page = Request.QueryString("page")
        If ID.Length < 1 Then Response.Redirect("default.aspx")
        If Not IsPostBack Then
            Dim conn As OleDbConnection, comd As OleDbCommand, dr As OleDbDataReader
            conn = New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=" & Server.MapPath(ConfigurationSettings.AppSettings("数据库")))
            comd = New OleDbCommand("Select 内容,回复 From 留言 Where ID=" + ID, conn)
            comd.Connection.Open()
            dr = comd.ExecuteReader
            If dr.Read Then
                LB.Text = dr(0)
                TB.Text = dr(1).ToString
            Else
                Response.Redirect("default.aspx")
            End If
            dr.Close()
            comd.Connection.Close()
            comd.Dispose()
            conn.Close()
            conn.Dispose()
        End If
    End Sub

    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        Response.Redirect("default.aspx")
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim ID As String, page As String, text As String
        ID = Request.QueryString("ID")
        page = Request.QueryString("page")
        If ID.Length < 1 Then Response.Redirect("default.aspx")
        Dim conn As OleDbConnection, comd As OleDbCommand
        conn = New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=" & Server.MapPath(ConfigurationSettings.AppSettings("数据库")))
        comd = New OleDbCommand("Update 留言 Set 回复=@p1 Where ID=" + ID, conn)
        comd.Parameters.Add(New OleDbParameter("@p1", OleDbType.Char))
        text = TB.Text
        If text.Length < 1 Then text = "谢谢你的留言"
        text = Replace(text, vbCrLf, "<br>")
        comd.Parameters("@p1").Value = text
        comd.Connection.Open()
        comd.ExecuteNonQuery()
        comd.Connection.Close()
        comd.Dispose()
        conn.Close()
        conn.Dispose()
        Response.Redirect("default.aspx?page=" + page)
    End Sub
End Class