frmcustomer.vb

Visual Basic Oracle数据库联接

Option Strict Off
Imports System.Xml

Public Class frmCustomer
    Inherits System.Windows.Forms.Form
    Private Const strEmpty As String = ""
#Region " Windows Form Designer generated code "

    Public Sub New()
        MyBase.New()

        'This call is required by the Windows Form Designer.
        InitializeComponent()

        'Add any initialization after the InitializeComponent() call

    End Sub

    'Form overrides dispose to clean up the component list.
    Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
        If disposing Then
            If Not (components Is Nothing) Then
                components.Dispose()
            End If
        End If
        MyBase.Dispose(disposing)
    End Sub

    'Required by the Windows Form Designer
    Private components As System.ComponentModel.IContainer

    'NOTE: The following procedure is required by the Windows Form Designer
    'It can be modified using the Windows Form Designer.  
    'Do not modify it using the code editor.
    Friend WithEvents Label1 As System.Windows.Forms.Label
    Friend WithEvents Label4 As System.Windows.Forms.Label
    Friend WithEvents Label5 As System.Windows.Forms.Label
    Friend WithEvents Label6 As System.Windows.Forms.Label
    Friend WithEvents txtUniqueID As System.Windows.Forms.TextBox
    Friend WithEvents txtAddress As System.Windows.Forms.TextBox
    Friend WithEvents txtPhone1 As System.Windows.Forms.TextBox
    Friend WithEvents txtPhone2 As System.Windows.Forms.TextBox
    Friend WithEvents dsCust As System.Data.DataSet
    Friend WithEvents btnNavFirst As System.Windows.Forms.Button
    Friend WithEvents btnNavPrev As System.Windows.Forms.Button
    Friend WithEvents lblNavLocation As System.Windows.Forms.Label
    Friend WithEvents btnNavNext As System.Windows.Forms.Button
    Friend WithEvents btnLast As System.Windows.Forms.Button
    Friend WithEvents btnAdd As System.Windows.Forms.Button
    Friend WithEvents btnDelete As System.Windows.Forms.Button
    Friend WithEvents btnUpdate As System.Windows.Forms.Button
    Friend WithEvents btnLoad As System.Windows.Forms.Button
    Friend WithEvents btnClose As System.Windows.Forms.Button
    Friend WithEvents GroupBox1 As System.Windows.Forms.GroupBox
    Friend WithEvents Label7 As System.Windows.Forms.Label
    Friend WithEvents txtTitle As System.Windows.Forms.TextBox
    Friend WithEvents txtContact As System.Windows.Forms.TextBox
    Friend WithEvents Label3 As System.Windows.Forms.Label
    Friend WithEvents txtCoName As System.Windows.Forms.TextBox
    Friend WithEvents Label2 As System.Windows.Forms.Label
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
        Me.Label1 = New System.Windows.Forms.Label()
        Me.txtUniqueID = New System.Windows.Forms.TextBox()
        Me.Label4 = New System.Windows.Forms.Label()
        Me.txtAddress = New System.Windows.Forms.TextBox()
        Me.Label5 = New System.Windows.Forms.Label()
        Me.txtPhone1 = New System.Windows.Forms.TextBox()
        Me.Label6 = New System.Windows.Forms.Label()
        Me.txtPhone2 = New System.Windows.Forms.TextBox()
        Me.btnClose = New System.Windows.Forms.Button()
        Me.btnUpdate = New System.Windows.Forms.Button()
        Me.dsCust = New System.Data.DataSet()
        Me.btnNavFirst = New System.Windows.Forms.Button()
        Me.btnNavPrev = New System.Windows.Forms.Button()
        Me.lblNavLocation = New System.Windows.Forms.Label()
        Me.btnNavNext = New System.Windows.Forms.Button()
        Me.btnLast = New System.Windows.Forms.Button()
        Me.btnAdd = New System.Windows.Forms.Button()
        Me.btnDelete = New System.Windows.Forms.Button()
        Me.btnLoad = New System.Windows.Forms.Button()
        Me.GroupBox1 = New System.Windows.Forms.GroupBox()
        Me.Label7 = New System.Windows.Forms.Label()
        Me.txtTitle = New System.Windows.Forms.TextBox()
        Me.txtContact = New System.Windows.Forms.TextBox()
        Me.Label3 = New System.Windows.Forms.Label()
        Me.txtCoName = New System.Windows.Forms.TextBox()
        Me.Label2 = New System.Windows.Forms.Label()
        CType(Me.dsCust, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.GroupBox1.SuspendLayout()
        Me.SuspendLayout()
        '
        'Label1
        '
        Me.Label1.Location = New System.Drawing.Point(8, 16)
        Me.Label1.Name = "Label1"
        Me.Label1.Size = New System.Drawing.Size(64, 16)
        Me.Label1.TabIndex = 0
        Me.Label1.Text = "Unique ID"
        '
        'txtUniqueID
        '
        Me.txtUniqueID.AccessibleName = "Unique ID"
        Me.txtUniqueID.Enabled = False
        Me.txtUniqueID.Location = New System.Drawing.Point(80, 16)
        Me.txtUniqueID.Name = "txtUniqueID"
        Me.txtUniqueID.Size = New System.Drawing.Size(152, 21)
        Me.txtUniqueID.TabIndex = 1
        Me.txtUniqueID.Text = "UniqueID"
        Me.txtUniqueID.WordWrap = False
        '
        'Label4
        '
        Me.Label4.Location = New System.Drawing.Point(16, 160)
        Me.Label4.Name = "Label4"
        Me.Label4.Size = New System.Drawing.Size(56, 16)
        Me.Label4.TabIndex = 6
        Me.Label4.Text = "Address"
        '
        'txtAddress
        '
        Me.txtAddress.AccessibleName = "Address"
        Me.txtAddress.Location = New System.Drawing.Point(80, 152)
        Me.txtAddress.Multiline = True
        Me.txtAddress.Name = "txtAddress"
        Me.txtAddress.Size = New System.Drawing.Size(232, 72)
        Me.txtAddress.TabIndex = 7
        Me.txtAddress.Text = "Address"
        '
        'Label5
        '
        Me.Label5.Location = New System.Drawing.Point(16, 232)
        Me.Label5.Name = "Label5"
        Me.Label5.Size = New System.Drawing.Size(64, 16)
        Me.Label5.TabIndex = 8
        Me.Label5.Text = "Phone 1"
        '
        'txtPhone1
        '
        Me.txtPhone1.AccessibleName = "Phone 1"
        Me.txtPhone1.Location = New System.Drawing.Point(80, 232)
        Me.txtPhone1.Name = "txtPhone1"
        Me.txtPhone1.Size = New System.Drawing.Size(232, 21)
        Me.txtPhone1.TabIndex = 9
        Me.txtPhone1.Text = "Phone1"
        '
        'Label6
        '
        Me.Label6.Location = New System.Drawing.Point(16, 256)
        Me.Label6.Name = "Label6"
        Me.Label6.Size = New System.Drawing.Size(64, 16)
        Me.Label6.TabIndex = 10
        Me.Label6.Text = "Phone 2"
        '
        'txtPhone2
        '
        Me.txtPhone2.AccessibleName = "Phone 2"
        Me.txtPhone2.Location = New System.Drawing.Point(80, 256)
        Me.txtPhone2.Name = "txtPhone2"
        Me.txtPhone2.Size = New System.Drawing.Size(232, 21)
        Me.txtPhone2.TabIndex = 11
        Me.txtPhone2.Text = "Phone2"
        '
        'btnClose
        '
        Me.btnClose.AccessibleName = "Done"
        Me.btnClose.Location = New System.Drawing.Point(240, 288)
        Me.btnClose.Name = "btnClose"
        Me.btnClose.Size = New System.Drawing.Size(72, 24)
        Me.btnClose.TabIndex = 12
        Me.btnClose.Text = "&Close"
        '
        'btnUpdate
        '
        Me.btnUpdate.AccessibleName = "Done"
        Me.btnUpdate.Location = New System.Drawing.Point(168, 288)
        Me.btnUpdate.Name = "btnUpdate"
        Me.btnUpdate.Size = New System.Drawing.Size(72, 24)
        Me.btnUpdate.TabIndex = 13
        Me.btnUpdate.Text = "&Update"
        '
        'dsCust
        '
        Me.dsCust.DataSetName = "Customers"
        Me.dsCust.Locale = New System.Globalization.CultureInfo("en-US")
        '
        'btnNavFirst
        '
        Me.btnNavFirst.Location = New System.Drawing.Point(40, 320)
        Me.btnNavFirst.Name = "btnNavFirst"
        Me.btnNavFirst.Size = New System.Drawing.Size(40, 23)
        Me.btnNavFirst.TabIndex = 18
        Me.btnNavFirst.Text = "<<"
        '
        'btnNavPrev
        '
        Me.btnNavPrev.Location = New System.Drawing.Point(80, 320)
        Me.btnNavPrev.Name = "btnNavPrev"
        Me.btnNavPrev.Size = New System.Drawing.Size(35, 23)
        Me.btnNavPrev.TabIndex = 19
        Me.btnNavPrev.Text = "<"
        '
        'lblNavLocation
        '
        Me.lblNavLocation.BackColor = System.Drawing.Color.White
        Me.lblNavLocation.Location = New System.Drawing.Point(112, 320)
        Me.lblNavLocation.Name = "lblNavLocation"
        Me.lblNavLocation.Size = New System.Drawing.Size(95, 23)
        Me.lblNavLocation.TabIndex = 20
        Me.lblNavLocation.Text = "No Records"
        Me.lblNavLocation.TextAlign = System.Drawing.ContentAlignment.MiddleCenter
        '
        'btnNavNext
        '
        Me.btnNavNext.Location = New System.Drawing.Point(208, 320)
        Me.btnNavNext.Name = "btnNavNext"
        Me.btnNavNext.Size = New System.Drawing.Size(35, 23)
        Me.btnNavNext.TabIndex = 21
        Me.btnNavNext.Text = ">"
        '
        'btnLast
        '
        Me.btnLast.Location = New System.Drawing.Point(248, 320)
        Me.btnLast.Name = "btnLast"
        Me.btnLast.Size = New System.Drawing.Size(40, 23)
        Me.btnLast.TabIndex = 22
        Me.btnLast.Text = ">>"
        '
        'btnAdd
        '
        Me.btnAdd.Location = New System.Drawing.Point(8, 288)
        Me.btnAdd.Name = "btnAdd"
        Me.btnAdd.TabIndex = 23
        Me.btnAdd.Text = "&Add"
        '
        'btnDelete
        '
        Me.btnDelete.Location = New System.Drawing.Point(88, 288)
        Me.btnDelete.Name = "btnDelete"
        Me.btnDelete.TabIndex = 24
        Me.btnDelete.Text = "&Delete"
        '
        'btnLoad
        '
        Me.btnLoad.Location = New System.Drawing.Point(240, 16)
        Me.btnLoad.Name = "btnLoad"
        Me.btnLoad.TabIndex = 25
        Me.btnLoad.Text = "&Reload"
        '
        'GroupBox1
        '
        Me.GroupBox1.Controls.AddRange(New System.Windows.Forms.Control() {Me.Label7, Me.txtTitle, Me.txtContact, Me.Label3, Me.txtCoName, Me.Label2})
        Me.GroupBox1.Location = New System.Drawing.Point(8, 48)
        Me.GroupBox1.Name = "GroupBox1"
        Me.GroupBox1.Size = New System.Drawing.Size(320, 96)
        Me.GroupBox1.TabIndex = 28
        Me.GroupBox1.TabStop = False
        '
        'Label7
        '
        Me.Label7.Location = New System.Drawing.Point(36, 70)
        Me.Label7.Name = "Label7"
        Me.Label7.Size = New System.Drawing.Size(32, 16)
        Me.Label7.TabIndex = 33
        Me.Label7.Text = "Title"
        '
        'txtTitle
        '
        Me.txtTitle.Location = New System.Drawing.Point(76, 64)
        Me.txtTitle.Name = "txtTitle"
        Me.txtTitle.Size = New System.Drawing.Size(232, 21)
        Me.txtTitle.TabIndex = 32
        Me.txtTitle.Text = "ContactTitle"
        '
        'txtContact
        '
        Me.txtContact.AccessibleName = "Contact Name"
        Me.txtContact.Location = New System.Drawing.Point(76, 40)
        Me.txtContact.Name = "txtContact"
        Me.txtContact.Size = New System.Drawing.Size(232, 21)
        Me.txtContact.TabIndex = 31
        Me.txtContact.Text = "Contact"
        '
        'Label3
        '
        Me.Label3.Location = New System.Drawing.Point(12, 46)
        Me.Label3.Name = "Label3"
        Me.Label3.Size = New System.Drawing.Size(56, 16)
        Me.Label3.TabIndex = 30
        Me.Label3.Text = "Contact"
        '
        'txtCoName
        '
        Me.txtCoName.AccessibleName = "Company Name"
        Me.txtCoName.Location = New System.Drawing.Point(76, 14)
        Me.txtCoName.Name = "txtCoName"
        Me.txtCoName.Size = New System.Drawing.Size(232, 21)
        Me.txtCoName.TabIndex = 29
        Me.txtCoName.Text = "CompanyName"
        '
        'Label2
        '
        Me.Label2.Location = New System.Drawing.Point(4, 14)