yifk.aspx.vb

The Management Information System of Library using .NET

Imports System.Data.SqlClient
Public Class yifk
    Inherits System.Web.UI.Page

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

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

    End Sub
    Protected WithEvents Label1 As System.Web.UI.WebControls.Label
    Protected WithEvents dbg 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
                mydatabind(Session("UID"))
        End If
    End Sub
    Function mydatabind(ByVal strAu_id As String)
        Dim cnlib2004 As SqlConnection
        Dim cmdAuBorrowList As SqlCommand
        Dim dr As SqlDataReader

        cnlib2004 = New SqlConnection(ConfigurationSettings.AppSettings("cncstr"))
        cmdAuBorrowList = New SqlCommand

        With cmdAuBorrowList
            .CommandType = CommandType.StoredProcedure
            .CommandText = "WebSelectMaxDateAuList"
            .Connection = cnlib2004
        End With

        Try
            cnlib2004.Open()
            dr = cmdAuBorrowList.ExecuteReader
            Me.dbg.DataSource = dr
            Me.dbg.DataBind()
        Catch ex As Exception
            Response.Redirect("error.aspx?errmsg=" + ex.Message)
        Finally
            cnlib2004.Close()
        End Try
    End Function

End Class