webform6.aspx.vb

来自「这是用ASP.NET和SQLserver编写的购物网站的程序」· VB 代码 · 共 52 行

Imports System.Data.SqlClient
Public Class WebForm6
    Inherits System.Web.UI.Page
    Dim connString As String = "data source=(local);initial catalog=ECDB;user id=sa;pwd=200343"
    Dim conn As SqlConnection = New SqlConnection(connString)
    Dim queSQL As String
    Public im As String = "images/IBM ThinkPad Z60T 251218C.jpg"
   

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

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

    End Sub
    Protected WithEvents DataList1 As System.Web.UI.WebControls.DataList
    Protected WithEvents Im1 As System.Web.UI.WebControls.Image
    Protected WithEvents Im2 As System.Web.UI.WebControls.Image

    '注意: 以下占位符声明是 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
        '在此处放置初始化页的用户代码
        queSQL = "SELECT * from item"
        Dim cmd As New SqlCommand
        cmd.CommandText = queSQL
        conn.Open()
        cmd.Connection = conn

        Dim reader As SqlDataReader
        reader = cmd.ExecuteReader
        DataList1.DataSource = reader
        DataList1.DataBind()
        conn.Close()
    End Sub


    Private Sub DataList1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DataList1.SelectedIndexChanged

    End Sub
End Class