inserttop5.aspx.vb

这是用ASP.NET和SQLserver编写的购物网站的程序

Imports System.Data.SqlClient
Public Class inserttop5
    Inherits System.Web.UI.Page
    Dim cm As SqlCommand
    Dim Cstring As String = ConfigurationSettings.AppSettings("ConnectionString")
    Protected WithEvents DList1 As System.Web.UI.WebControls.DropDownList
    Protected WithEvents DList2 As System.Web.UI.WebControls.DropDownList
    Dim nwindConn As SqlConnection = New SqlConnection(Cstring)
    Protected WithEvents Label8 As System.Web.UI.WebControls.Label
    Protected WithEvents Button2 As System.Web.UI.WebControls.Button
    Dim nwindConn1 As SqlConnection = New SqlConnection(Cstring)
#Region " Web 窗体设计器生成的代码 "

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

    End Sub
    Protected WithEvents Button1 As System.Web.UI.WebControls.Button
    Protected WithEvents Label1 As System.Web.UI.WebControls.Label
    Protected WithEvents Label2 As System.Web.UI.WebControls.Label

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

    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 Not IsPostBack Then
            Try
                If (Session("userpower") <> 2) Then
                    Response.End()
                End If
            Catch ex As Exception
                Response.Write("您不是管理者,不能打开该页,<a href='managerlogin.aspx'>管理员登录</a>")
                Response.End()
            End Try
            Session("userpower") = -1
            nwindConn.Open()
            Dim connSQL As String = "select itemid,itemname from item"
            Dim DS As New DataSet
            Dim adapter As New SqlDataAdapter(connSQL, nwindConn)
            adapter.Fill(DS)
            DList1.DataSource = DS.Tables(0)
            DList1.DataTextField() = DS.Tables(0).Columns("itemname").ToString
            DList1.DataValueField() = DS.Tables(0).Columns("itemid").ToString
            DList1.DataBind()
            DS.Dispose()
            adapter.Dispose()
            nwindConn.Close()
            nwindConn1.Open()
            Dim connSQL1 As String = "select itemid,itemname from top6"
            Dim DS1 As New DataSet
            Dim adapter1 As New SqlDataAdapter(connSQL1, nwindConn1)
            adapter1.Fill(DS1)
            DList2.DataSource = DS1.Tables(0)
            DList2.DataTextField() = DS1.Tables(0).Columns("itemname").ToString
            DList2.DataValueField() = DS1.Tables(0).Columns("itemid").ToString
            DList2.DataBind()
            DS1.Dispose()
            adapter1.Dispose()
            nwindConn1.Close()
        End If
    End Sub

    Private Sub DList1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DList1.SelectedIndexChanged

    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        nwindConn.Open()
        nwindConn1.Open()
        Dim cmd As New SqlCommand
        cmd.CommandText = "select * from item where itemid='" & DList1.SelectedValue & "'"
        cmd.Connection = nwindConn
        Dim myreader As SqlDataReader = cmd.ExecuteReader
        Dim cmd1 As New SqlCommand
        myreader.Read()
        Try
            cmd1.CommandText = "update top6 set itemid='" & myreader("itemid") & "',itemname='" & myreader("itemname") & "',qty='" & myreader("qty") & "',productid='" & myreader("productid") & "',image='" & myreader("image") & "',decn='" & myreader("decn") & "' where itemid='" & DList2.SelectedValue & "'"
            cmd1.Connection = nwindConn1
            cmd1.ExecuteNonQuery()
            Response.Write("<script language='JavaScript'>alert('提交成功');</script>")
        Catch ex As Exception
            Response.Write("<script language='JavaScript'>alert('更新有误');</script>")
        End Try

        Dim connSQL1 As String = "select itemid,itemname from top6"
        Dim DS1 As New DataSet
        Dim adapter1 As New SqlDataAdapter(connSQL1, nwindConn1)
        adapter1.Fill(DS1)
        DList2.DataSource = DS1.Tables(0)
        DList2.DataTextField() = DS1.Tables(0).Columns("itemname").ToString
        DList2.DataValueField() = DS1.Tables(0).Columns("itemid").ToString
        DList2.DataBind()
        DS1.Dispose()
        adapter1.Dispose()
        nwindConn1.Close()
        nwindConn.Close()

    End Sub

    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        Session("userpower") = 2
        Response.Redirect("manager.aspx")
    End Sub
End Class