reportquery.aspx.vb

来自「一个很不错的实验室管理系统,用vb+sql编写,功能强大,界面美观」· VB 代码 · 共 34 行

Public Class ReportQuery
    Inherits clsReport
    Protected WithEvents drpAddress As System.Web.UI.HtmlControls.HtmlSelect

#Region " Web Form Designer Generated Code "

    'This call is required by the Web Form Designer.
    <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: This method call is required by the Web Form Designer
        'Do not modify it using the code editor.
        InitializeComponent()
    End Sub

#End Region

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        '显示地址
        PubStrSql = "select * from addresstable"
        PubDataAdapter.SelectCommand.CommandText = PubStrSql
        PubDataAdapter.Fill(PubDataSet, "tblAddress")
        With drpAddress
            .DataSource = PubDataSet.Tables("tblAddress")
            .DataTextField = "Address"
            .DataValueField = "Address"
            .DataBind()
        End With
    End Sub
End Class