bookinfo.ascx.vb

图书借阅系统！ASP.NET实现的

Imports System.Data.SqlClient
Public Class BookInfo
    Inherits System.Web.UI.UserControl

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

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

    End Sub
    Protected WithEvents lbBookName As System.Web.UI.WebControls.Label
    Protected WithEvents lbBookAuthor As System.Web.UI.WebControls.Label
    Protected WithEvents lbPubName As System.Web.UI.WebControls.Label
    Protected WithEvents lbBarCode As System.Web.UI.WebControls.Label
    Protected WithEvents lbISBN As System.Web.UI.WebControls.Label
    Protected WithEvents lbSearchNO As System.Web.UI.WebControls.Label
    Protected WithEvents lbSeries As System.Web.UI.WebControls.Label
    Protected WithEvents lbPubDate As System.Web.UI.WebControls.Label
    Protected WithEvents lbPrice 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
        '在此处放置初始化页的用户代码
    End Sub
    Public Sub BindBookInfo(ByVal BookID As String)
        Dim obj As DBController = New DBController
        Dim myreader As SqlDataReader = obj.ExecReaderSql("select * from BookInfo where BookID=" + BookID)
        If myreader.Read Then
            lbBookName.Text = myreader("BookName")
            lbBookAuthor.Text = myreader("BookAuthor")
            lbPubName.Text = myreader("PubName")
            lbPubDate.Text = myreader("PubDate") '
            lbPrice.Text = myreader("Price")
            lbBarCode.Text = myreader("BarCode")
            lbSearchNO.Text = myreader("SearchNO")
            lbSeries.Text = myreader("Series")
            lbISBN.Text = myreader("ISBN")
        End If
        obj.Close()
    End Sub
End Class