selectuser.aspx.vb

VB.NET和SQLSERver2000编写在线考试系统

Public Class Selectuser
    Inherits System.Web.UI.Page

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

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

    End Sub
    Protected WithEvents DataGrid1 As System.Web.UI.WebControls.DataGrid
    Protected WithEvents Image1 As System.Web.UI.WebControls.Image
    Protected WithEvents Image9 As System.Web.UI.WebControls.Image
    Protected WithEvents Image7 As System.Web.UI.WebControls.Image
    Protected WithEvents Image6 As System.Web.UI.WebControls.Image
    Protected WithEvents Image5 As System.Web.UI.WebControls.Image
    Protected WithEvents Image4 As System.Web.UI.WebControls.Image
    Protected WithEvents Image3 As System.Web.UI.WebControls.Image
    Protected WithEvents Image8 As System.Web.UI.WebControls.Image
    Protected WithEvents Image2 As System.Web.UI.WebControls.Image
    Protected WithEvents LinkButton1 As System.Web.UI.WebControls.LinkButton
    Protected WithEvents ImageButton2 As System.Web.UI.WebControls.ImageButton

    '注意: 以下占位符声明是 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
    Dim dt As DataTable
    Public Sub message(ByVal str As String)
        Dim strscript As String = "<script language=javascript>alert('" & str & "')</script>"
        RegisterClientScriptBlock("系统消息", strscript)
    End Sub
    Public Sub bind()
        Dim q As SqlClass = New SqlClass
        q.Open()
        Dim str As String = "select * from 成绩登记表"
        dt = q.GetDataTable(str, "ID")
        Dim dv As DataView = New DataView(Dt)
        DataGrid1.DataSource = dv
        DataGrid1.DataBind()
        q.close()
    End Sub
    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") <> 3) Then
                    Response.End()
                End If
            Catch ex As Exception
                Response.Write("您还登录,请您先登录<a href='SuperLogin.aspx'>首页</a>")
                Response.End()
            End Try
        End If
        bind()
    End Sub

    Private Sub DataGrid1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DataGrid1.SelectedIndexChanged

    End Sub

    Private Sub DataGrid1_DeleteCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.DeleteCommand
        Dim id As String = DataGrid1.DataKeys(e.Item.ItemIndex)
        Dim str As String = "select 试卷名称 from 成绩登记表 where ID='" & id & "'"
        Dim q As New SqlClass
        q.Open()
        Dim s As String = q.GetString(str)
        Try
            str = "delete from 成绩登记表 where 试卷名称='" & s & "'"
            q.ExecuteSQL(str)
            message("删除成功")
            bind()
        Catch ex As Exception
            message("删除失败")
        End Try
        If DataGrid1.PageCount > 1 And DataGrid1.CurrentPageIndex = (DataGrid1.PageCount - 1) And DataGrid1.Items.Count = 1 Then
            DataGrid1.CurrentPageIndex = DataGrid1.CurrentPageIndex - 1
        End If
    End Sub

    Private Sub DataGrid1_ItemCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.ItemCommand
        If e.CommandName = "Select" Then
            Dim id As String = DataGrid1.DataKeys(e.Item.ItemIndex)
            Dim str As String = "select 试卷 from 成绩登记表 where ID='" & id & "'"
            Dim q As New SqlClass
            q.Open()
            Dim s As String = q.GetString(str)
            Try
                str = "delete from 试卷名称表 where 试卷名称='" & s & "'"
                q.ExecuteSQL(str)
                str = "if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[" & s & "]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[" & s & "]"
                q.ExecuteSQL(str)
                message("删除成功")
                bind()
            Catch ex As Exception
                message("删除失败")
            End Try
            If DataGrid1.PageCount > 1 And DataGrid1.CurrentPageIndex = (DataGrid1.PageCount - 1) And DataGrid1.Items.Count = 1 Then
                DataGrid1.CurrentPageIndex = DataGrid1.CurrentPageIndex - 1
            End If
        Else
            If e.CommandName = "Judge" Then
                Session("tablename") = dt.Rows(e.Item.ItemIndex).Item("试卷名称")
                Response.Redirect("papermanage.aspx")
            End If
        End If
    End Sub

    Private Sub DataGrid1_PageIndexChanged(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEventArgs) Handles DataGrid1.PageIndexChanged
        DataGrid1.CurrentPageIndex = e.NewPageIndex
        bind()
    End Sub

    Private Sub ImageButton2_Click(ByVal sender As System.Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles ImageButton2.Click
        Response.Redirect("welcome.aspx")
    End Sub

    Private Sub LinkButton1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LinkButton1.Click
        Response.Redirect("Addpaper.aspx")
    End Sub
End Class