booklist.aspx.vb

这是一个电子商务入门级的代码。 其中包括用户注册

Imports System.Data
Imports System.Data.OleDb
Public Class bookList
    Inherits System.Web.UI.Page
    Protected WithEvents DataGrid1 As System.Web.UI.WebControls.DataGrid
    Protected WithEvents Button1 As System.Web.UI.WebControls.Button
    Protected WithEvents Label1 As System.Web.UI.WebControls.Label

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

    '该调用是 Web 窗体设计器所必需的。
    <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: 此方法调用是 Web 窗体设计器所必需的
        '不要使用代码编辑器修改它。
        InitializeComponent()
    End Sub

#End Region

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim mycon As New OleDbConnection()
        Dim myds As New DataSet()
        mycon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("OnLineSale.mdb")
        mycon.Open()
        Dim sqlstr
        sqlstr = "select buyID as 交易号, cusName as 客户名字,cusTel as 电话号码,cusAddr as 客户地址,gName as 商品名称" & _
                 ",gType as 商品类型,gID as 商品编号,gPrice as '单价(元)',num as 购买数量,gPrice * num as '金额小计(元)' from q2"
        Dim myadpt As OleDbDataAdapter = New OleDbDataAdapter(sqlstr, mycon)
        myadpt.Fill(myds, "table1")
        DataGrid1.DataSource = myds.Tables("table1").DefaultView
        DataGrid1.DataBind()
        mycon.Close()
        mycon = Nothing '在此处放置初始化页的用户代码
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Response.Redirect("managerOption.aspx")
    End Sub

    Private Sub DataGrid1_DeleteCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.DeleteCommand
        DataGrid1.EditItemIndex = -1
        Dim mycon As New OleDbConnection()
        Dim myds As New DataSet()
        Dim mycmd As New OleDbCommand()
        mycon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("OnLineSale.mdb")
        mycon.Open()
        Dim sqlstr
        sqlstr = "delete from buy where buyid=" & e.Item.Cells(1).Text
        mycmd.Connection = mycon
        mycmd.CommandText = sqlstr
        mycmd.ExecuteNonQuery()

        sqlstr = "update goods set gAccessNum=gAccessNum-" & e.Item.Cells(9).Text & _
                 " where gID=" & e.Item.Cells(7).Text
        mycmd.Connection = mycon
        mycmd.CommandText = sqlstr
        mycmd.ExecuteNonQuery()

        sqlstr = "select buyID as 交易号, cusName as 客户名字,cusTel as 电话号码,cusAddr as 客户地址,gName as 商品名称" & _
                 ",gType as 商品类型,gPrice as '单价(元)',num as 购买数量,gPrice * num as '金额小计(元)' from q2"
        Dim myadpt As OleDbDataAdapter = New OleDbDataAdapter(sqlstr, mycon)
        myadpt.Fill(myds, "table1")
        DataGrid1.DataSource = myds.Tables("table1").DefaultView
        DataGrid1.DataBind()
        mycon.Close()
    End Sub
End Class