webform1.aspx.vb

来自「介绍vb.net的一本很好的英文资料,深入浅出,值得一读」· VB 代码 · 共 36 行

Imports System.Data.SqlClient

Public Class WebForm1
    Inherits System.Web.UI.Page
    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
        'Put user code to initialize the page here
        Dim sqlConn As SqlConnection
        sqlConn = New SqlConnection()
        sqlConn.ConnectionString = "Data Source=localhost;Initial Catalog=Cargo;Integrated Security=True;"
        sqlConn.Open()
        Dim comInvoices As New SqlCommand("Select * from Invoices", sqlConn)
        Dim drInvoices As SqlDataReader
        drInvoices = comInvoices.ExecuteReader()
        DataGrid1.DataSource = drInvoices
        DataGrid1.DataBind()
    End Sub

End Class