know.aspx.vb

利用简单框架结构vb+asp+sql,实现小型考试系统

Imports System.Data
Imports System.Data.SqlClient
Imports Exam.Module1
Public Class WebForm1
    Inherits System.Web.UI.Page

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

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

    End Sub

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

    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("Stuname") Is Nothing And Session("AdminName") Is Nothing Then
            Response.Write("<script language='javascript'>alert('考生不存在或者操作错误,请确认已登录.');window.location.href('index.aspx')</script>")
        End If
        If Session("Stuname") <> Nothing Then
            pnl1.Visible = True
            DataBingToRep()
        End If
    End Sub
    '
    '显示学生的已考课程
    Sub DataBingToRep()
        strsql = "select * from score where studentname='" & Session("Stuname") & "'"
        Dim cmd As New SqlDataAdapter(strsql, appconn)
        Dim ds As New DataSet
        cmd.Fill(ds, "sort")
        rep.DataSource = ds.Tables("sort").DefaultView
        rep.DataBind()
    End Sub

End Class