inbox.aspx.vb

来自「java voice chat based on java core ,, u 」· VB 代码 · 共 50 行

Imports System.Data.SqlClient
Public Class inbox
    Inherits System.Web.UI.Page
    Protected WithEvents Form1 As System.Web.UI.HtmlControls.HtmlForm
    Protected WithEvents DataGrid1 As System.Web.UI.WebControls.DataGrid

#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
        If Not Page.IsPostBack Then
            GetMails()
        End If

    End Sub

    Sub GetMails()
        Dim con As New SqlConnection(Application("cs"))
        Try
            Dim da As New SqlDataAdapter("select subject,sd,mailfrom,mid from mails where  mailto = @acno order by sd desc", con)
            da.SelectCommand.Parameters.Add("@acno", SqlDbType.VarChar, 10).Value = Session("acno")
            Dim ds As New DataSet()
            da.Fill(ds, "mails")  ' query is executed, table created
            DataGrid1.DataSource = ds.Tables(0)
            DataGrid1.DataBind()
        Catch ex As Exception
            Response.Write(ex.Message)
        End Try

    End Sub

    Private Sub DataGrid1_PageIndexChanged(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEventArgs) Handles DataGrid1.PageIndexChanged
        DataGrid1.CurrentPageIndex = e.NewPageIndex
        GetMails()

    End Sub
End Class