newchequebook.aspx.vb

来自「java voice chat based on java core ,, u 」· VB 代码 · 共 46 行

Imports System.Data.SqlClient
Public Class newchequebook
    Inherits System.Web.UI.Page
    Protected WithEvents Form1 As System.Web.UI.HtmlControls.HtmlForm
    Protected WithEvents btnSubmit As System.Web.UI.WebControls.Button
    Protected WithEvents lblmsg As System.Web.UI.WebControls.Label

#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
    End Sub

    Private Sub btnSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
        Dim con As New sqlconnection(Application("cs"))
        Try
            con.Open()
            Dim cmd As New SqlCommand()
            cmd.CommandText = "requestforchequebook"
            cmd.CommandType = CommandType.StoredProcedure
            cmd.Connection = con
            cmd.Parameters.Add("@acno", SqlDbType.VarChar, 10).Value = Session("acno")

            cmd.ExecuteNonQuery()
            lblmsg.Text = "Cheque Book Request Accepted!"
        Catch ex As Exception
            lblmsg.Text = "Error --> " & ex.Message
        Finally
            con.Close()
        End Try
    End Sub
End Class