webtestplacesearch.aspx.vb

在线考试系统详细源码

Imports System.Data                              '引入数据库操作类命名空间
Imports System.Data.OleDb                       '引入ADO.NET操作命名空间




Public Class WebForm2

    Inherits System.Web.UI.Page
    Protected WithEvents Label1 As System.Web.UI.WebControls.Label
    Protected WithEvents Button1 As System.Web.UI.WebControls.Button
    Protected WithEvents Form1 As System.Web.UI.HtmlControls.HtmlForm
    Public ADOcmd As OleDbDataAdapter
    '建立ADODataSetCommand对象
    Public ds As DataSet = New DataSet()
    '建立DataSet对象 
    Public mytable As Data.DataTable
    '建立表单对象
    Protected WithEvents DgTestPlaceInfo As System.Web.UI.WebControls.DataGrid
    Protected WithEvents DrDListTestDate As System.Web.UI.WebControls.DropDownList
    Protected WithEvents HyperLink1 As System.Web.UI.WebControls.HyperLink
    Protected WithEvents HyperLink6 As System.Web.UI.WebControls.HyperLink
    Protected WithEvents HyperLink7 As System.Web.UI.WebControls.HyperLink
    Protected WithEvents HyperLink8 As System.Web.UI.WebControls.HyperLink
    Protected WithEvents HyperLink9 As System.Web.UI.WebControls.HyperLink
    Protected WithEvents Panel2 As System.Web.UI.WebControls.Panel
    Public myrow As Data.DataRow                '建立数据行对象

#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
        '在此处放置初始化页的用户代码
    End Sub



    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim SearchSQL As String
        Dim testdate As String
        testdate = Trim(DrDListTestDate.SelectedItem.Text)
        If testdate <> "全部" Then
            SearchSQL = "SELECT * FROM tbtestplaceinfo WHERE (考试日期 = '" & testdate & "')"                                              '构造查询
            ADOcmd = New OleDbDataAdapter(SearchSQL, "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\computertest.mdb")
            '建立ADODataSetCommand对象
            ADOcmd.Fill(ds, "tbtestplaceinfo") '取得名为tbtestplaceinfo的表单
            DgTestPlaceInfo.DataSource = ds.Tables.Item(0).DefaultView
            DgTestPlaceInfo.DataBind()                    '绑定数据库
        Else
            SearchSQL = "SELECT * FROM tbtestplaceinfo" '构造查询
            ADOcmd = New OleDbDataAdapter(SearchSQL, "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\computertest.mdb")
            '建立ADODataSetCommand对象
            ADOcmd.Fill(ds, "tbtestplaceinfo")  '取得名为tbtestplaceinfo的表单
            DgTestPlaceInfo.DataSource = ds.Tables.Item(0).DefaultView
            DgTestPlaceInfo.DataBind() '绑定数据库
        End If
    End Sub

End Class