bookinglist.ascx.vb

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

Public Class BookingList
    Inherits System.Web.UI.UserControl

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

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

    End Sub
    Protected WithEvents BookingGrid As System.Web.UI.WebControls.DataGrid

    '注意: 以下占位符声明是 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
        '在此处放置初始化页的用户代码        
        If Not IsPostBack Then
            BindDBGrid()
        End If
    End Sub
    Private Sub BindDBGrid()
        Dim sqlstr As String = "select * from BookingInfo,UserInfo,BookInfo where BookingInfo.BookID=BookInfo.BookID and  BookingInfo.UserID=UserInfo.UserID  and UserInfo.UserID='" + Session("UserID") + "'"
        Dim obj As DBController = New DBController
        obj.BindDBGrd(sqlstr, BookingGrid)
    End Sub
    Public Function EditUrl(ByVal str As String) As String
        str = "ListContent.aspx?type=3&BookID=" + str '
        Return str
    End Function

End Class