Public Class OutDate
    Inherits System.Web.UI.UserControl

#Region " Web 窗體設計器生成的代碼 "

    '該調用是 Web 窗體設計器所必需的。
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

    End Sub
    Protected WithEvents OutDateGrid 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
        '在此處放置初始化頁的用戶代碼
        Dim obj As DBController = New DBController
        '
        Dim sqlstr As String = "select distinct UserInfo.UserID,Unit from UserInfo,LendInfo where IsBack=0 and UserInfo.UserID=LendInfo.UserID and ReturnDate<'" + Now.ToString + "'"
        obj.BindDBGrd(sqlstr, OutDateGrid)
    End Sub

End Class