fl.aspx.vb

asp,vb.net编写,我的毕业设计,简单的网上购书系统,比较主流

Public Class fl
    Inherits System.Web.UI.Page

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

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

    End Sub
    Protected WithEvents DataGrid1 As System.Web.UI.WebControls.DataGrid
    Protected WithEvents Table1 As System.Web.UI.HtmlControls.HtmlTable
    Protected WithEvents FONT1 As System.Web.UI.HtmlControls.HtmlGenericControl
    Protected WithEvents Lnbfl As System.Web.UI.WebControls.LinkButton
    Protected WithEvents Table2 As System.Web.UI.HtmlControls.HtmlTable
    Protected WithEvents Lnbjr As System.Web.UI.WebControls.LinkButton
    Protected WithEvents Tbbz As System.Web.UI.WebControls.TextBox
    Protected WithEvents Tbfl As System.Web.UI.WebControls.TextBox
    Protected WithEvents Table3 As System.Web.UI.HtmlControls.HtmlTable

    '注意: 以下占位符声明是 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
    Dim sqlstr As String
    Dim myd As New main

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Lnbfl.Enabled = False
        If Not IsPostBack Then
            sqlstr = "select * from 书籍分类表"
            DataGrid1.DataSource = myd.ReDataSet(sqlstr)
            DataGrid1.DataBind()
        End If
    End Sub

    Private Sub Lnbjr_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Lnbjr.Click
        sqlstr = "exec infl'" & Tbfl.Text & "','" & Tbbz.Text & "'"
        Dim ss As String = myd.exesql(sqlstr)
        If ss = "T" Then
            Tbfl.Text = ""
            Tbbz.Text = ""

            'sqlstr = "select * from 书籍分类表"
            'DataGrid1.DataSource = myd.ReDataSet(sqlstr)
            'DataGrid1.DataBind()
            datab("select * from 书籍分类表")
            Lnbjr.Enabled = True
        Else
            ss = ss.Replace(vbCrLf, "")
            Response.Redirect("../message.aspx?msg=" & ss)

        End If
    End Sub
    Sub datab(ByVal str As String)
        DataGrid1.DataSource = myd.retab(str)
        DataGrid1.DataBind()
    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
        datab("select * from 书籍分类表")
    End Sub
End Class