articleadd.aspx.vb

后台管理 内容添加功能

Imports System.Data.OleDb


Namespace DotNet2000

Partial Class ArticleAdd
    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
        '在此处放置初始化页的用户代码
        If Session("UserName") = "" Then
            NameTxt.Text = "访客"
        Else
            NameTxt.Text = Session("UserName")
        End If

        If Not IsPostBack Then
            Class02.Items.Clear()
            Class02.Items.Add("生活随笔")
            Class02.Items.Add("个人随想")
        End If
    End Sub

    Private Sub Class01_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles Class01.SelectedIndexChanged
        If Class01.SelectedValue = "01" Then
            Class02.Items.Clear()
            Class02.Items.Add("生活随笔")
            Class02.Items.Add("个人随想")
        ElseIf Class01.SelectedValue = "02" Then
            Class02.Items.Clear()
            Class02.Items.Add("ASP.NET")
            Class02.Items.Add("VB.NET")
            Class02.Items.Add("C#")
            Class02.Items.Add("JAVA")
            Class02.Items.Add("软件工程")
        End If
    End Sub

    Private Sub CmdOk_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CmdOk.Click
        Dim Conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(DbPath))
        Dim SqlStr As String = "insert into Article (Class01,Class02,title,ArticleTxt,NameTxt) values ('" & Class01.SelectedValue & "','" & Class02.SelectedValue & "','" & Trim(Title.Text) & "','" & ArticleTxt.Text & "','" & Trim(NameTxt.Text) & "')"
        Dim SqlCommand As New OleDbCommand(SqlStr, Conn)
        Conn.Open()

        SqlCommand.ExecuteNonQuery()

        'Dim Conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(DbPath))
        'Dim SqlStr As String = "insert into Article (Class01,Class02,title,ArticleTxt,NameTxt) values ('" & Class01.SelectedValue & "','" & Class02.SelectedValue & "','" & Trim(Title.Text) & "',@ArticleTxt,'" & Trim(NameTxt.Text) & "')"
        'Dim SqlCommand As New OleDbCommand(SqlStr, Conn)

        'SqlCommand.Parameters.Add(New OleDbParameter("@ArticleTxt", OleDbType.Char, 50000))
        'SqlCommand.Parameters("@ArticleTxt").Value = ArticleTxt.Text

        'Conn.Open()
        'SqlCommand.ExecuteNonQuery()

        Response.Redirect("MsgBox.aspx?Msg=03T")

        Conn.Close()
    End Sub
End Class

End Namespace