cbs.aspx.vb

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

Public Class cbs
    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 LinkButton3 As System.Web.UI.WebControls.LinkButton
    Protected WithEvents Lnbcbs As System.Web.UI.WebControls.LinkButton
    Protected WithEvents Lnbjr As System.Web.UI.WebControls.LinkButton
    Protected WithEvents Tbqt As System.Web.UI.WebControls.TextBox
    Protected WithEvents Tbfzr As System.Web.UI.WebControls.TextBox
    Protected WithEvents Tbdh As System.Web.UI.WebControls.TextBox
    Protected WithEvents Tbdz As System.Web.UI.WebControls.TextBox
    Protected WithEvents Tbcbs As System.Web.UI.WebControls.TextBox
    Protected WithEvents Table3 As System.Web.UI.HtmlControls.HtmlTable
    Protected WithEvents Table2 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
        Lnbcbs.Enabled = False
        If Not IsPostBack Then
            sqlstr = "select * from 出版社表"
            DataGrid1.DataSource = myd.redataset(sqlstr)
            DataGrid1.DataBind()
        End If
    End Sub

    Sub datab(ByVal str As String)
        DataGrid1.DataSource = myd.retab(Str)
        DataGrid1.DataBind()
    End Sub

    Private Sub Lnbjr_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Lnbjr.Click
        sqlstr = "exec incbs'" & Tbcbs.Text & "','" & Tbdz.Text & "','" & Tbdh.Text & "','" & Tbfzr.Text & "','" & Tbqt.Text & "'"
        Dim ss As String = myd.exesql(sqlstr)
        If ss = "t" Then
            Tbcbs.Text = ""
            Tbdz.Text = ""
            Tbdh.Text = ""
            Tbfzr.Text = ""
            Tbqt.Text = ""

            'sqlstr = "select * from 出版社表"
            'DataGrid1.DataSource = myd.ReDataSet(sqlstr)
            'DataGrid1.DataBind()
            datab("select * from 出版社表")
        Else

            ss = ss.Replace(vbCrLf, "")
            Response.Redirect("../message.aspx?msg=" & "添加出版社成功！")
        End If
    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