client.designer.vb
来自「wrox出版社的另一套经典的VB2005数据库编程学习书籍,收集了书中源码,郑重」· VB 代码 · 共 318 行
VB
318 行
Partial Public Class Client
Inherits System.Windows.Forms.Form
<System.Diagnostics.DebuggerNonUserCode()> _
Public Sub New()
MyBase.New()
'This call is required by the Windows Form Designer.
InitializeComponent()
End Sub
'Form overrides dispose to clean up the component list.
<System.Diagnostics.DebuggerNonUserCode()> _
Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
If disposing AndAlso components IsNot Nothing Then
components.Dispose()
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.
<System.Diagnostics.DebuggerStepThrough()> _
Private Sub InitializeComponent()
Me.dgvNwind = New System.Windows.Forms.DataGridView
Me.gbWebMethod = New System.Windows.Forms.GroupBox
Me.btnExecuteCustID = New System.Windows.Forms.Button
Me.btnExecute = New System.Windows.Forms.Button
Me.rbBatch = New System.Windows.Forms.RadioButton
Me.txtSQL = New System.Windows.Forms.TextBox
Me.lblRows = New System.Windows.Forms.Label
Me.txtTime = New System.Windows.Forms.TextBox
Me.lblTime = New System.Windows.Forms.Label
Me.txtRows = New System.Windows.Forms.TextBox
Me.lblBatch = New System.Windows.Forms.Label
Me.cboYearESC = New System.Windows.Forms.ComboBox
Me.rbEmployeeSales = New System.Windows.Forms.RadioButton
Me.cboYearSBC = New System.Windows.Forms.ComboBox
Me.cboCategoryName = New System.Windows.Forms.ComboBox
Me.rbByCategory = New System.Windows.Forms.RadioButton
Me.txtCustomerID = New System.Windows.Forms.TextBox
Me.rbOrderHistory = New System.Windows.Forms.RadioButton
Me.rbMostExpensive = New System.Windows.Forms.RadioButton
Me.lblHeader = New System.Windows.Forms.Label
Me.txtSoapError = New System.Windows.Forms.TextBox
CType(Me.dgvNwind, System.ComponentModel.ISupportInitialize).BeginInit()
Me.gbWebMethod.SuspendLayout()
Me.SuspendLayout()
'
'dgvNwind
'
Me.dgvNwind.BorderStyle = System.Windows.Forms.BorderStyle.None
Me.dgvNwind.Location = New System.Drawing.Point(330, 32)
Me.dgvNwind.Name = "dgvNwind"
Me.dgvNwind.RowHeadersWidth = 25
Me.dgvNwind.Size = New System.Drawing.Size(286, 259)
Me.dgvNwind.TabIndex = 0
'
'gbWebMethod
'
Me.gbWebMethod.Controls.Add(Me.btnExecuteCustID)
Me.gbWebMethod.Controls.Add(Me.btnExecute)
Me.gbWebMethod.Controls.Add(Me.rbBatch)
Me.gbWebMethod.Controls.Add(Me.txtSQL)
Me.gbWebMethod.Controls.Add(Me.lblRows)
Me.gbWebMethod.Controls.Add(Me.txtTime)
Me.gbWebMethod.Controls.Add(Me.lblTime)
Me.gbWebMethod.Controls.Add(Me.txtRows)
Me.gbWebMethod.Controls.Add(Me.lblBatch)
Me.gbWebMethod.Controls.Add(Me.cboYearESC)
Me.gbWebMethod.Controls.Add(Me.rbEmployeeSales)
Me.gbWebMethod.Controls.Add(Me.cboYearSBC)
Me.gbWebMethod.Controls.Add(Me.cboCategoryName)
Me.gbWebMethod.Controls.Add(Me.rbByCategory)
Me.gbWebMethod.Controls.Add(Me.txtCustomerID)
Me.gbWebMethod.Controls.Add(Me.rbOrderHistory)
Me.gbWebMethod.Controls.Add(Me.rbMostExpensive)
Me.gbWebMethod.Location = New System.Drawing.Point(13, 32)
Me.gbWebMethod.Name = "gbWebMethod"
Me.gbWebMethod.Size = New System.Drawing.Size(294, 259)
Me.gbWebMethod.TabIndex = 1
Me.gbWebMethod.TabStop = False
Me.gbWebMethod.Text = "Select WebMethod to Execute"
'
'btnExecuteCustID
'
Me.btnExecuteCustID.Enabled = False
Me.btnExecuteCustID.Location = New System.Drawing.Point(228, 38)
Me.btnExecuteCustID.Name = "btnExecuteCustID"
Me.btnExecuteCustID.Size = New System.Drawing.Size(57, 19)
Me.btnExecuteCustID.TabIndex = 17
Me.btnExecuteCustID.Text = "Execute"
'
'btnExecute
'
Me.btnExecute.Enabled = False
Me.btnExecute.Location = New System.Drawing.Point(158, 117)
Me.btnExecute.Name = "btnExecute"
Me.btnExecute.Size = New System.Drawing.Size(57, 19)
Me.btnExecute.TabIndex = 16
Me.btnExecute.Text = "Execute"
'
'rbBatch
'
Me.rbBatch.AutoSize = True
Me.rbBatch.Location = New System.Drawing.Point(7, 118)
Me.rbBatch.Name = "rbBatch"
Me.rbBatch.Size = New System.Drawing.Size(119, 17)
Me.rbBatch.TabIndex = 14
Me.rbBatch.Text = "Ad Hoc Batch Query"
'
'txtSQL
'
Me.txtSQL.AutoSize = False
Me.txtSQL.Enabled = False
Me.txtSQL.Location = New System.Drawing.Point(8, 140)
Me.txtSQL.Margin = New System.Windows.Forms.Padding(3, 1, 3, 2)
Me.txtSQL.Multiline = True
Me.txtSQL.Name = "txtSQL"
Me.txtSQL.Size = New System.Drawing.Size(277, 89)
Me.txtSQL.TabIndex = 13
'
'lblRows
'
Me.lblRows.AutoSize = True
Me.lblRows.Location = New System.Drawing.Point(158, 236)
Me.lblRows.Margin = New System.Windows.Forms.Padding(3, 3, 0, 3)
Me.lblRows.Name = "lblRows"
Me.lblRows.Size = New System.Drawing.Size(91, 14)
Me.lblRows.TabIndex = 12
Me.lblRows.Text = "Number of Rows:"
'
'txtTime
'
Me.txtTime.Location = New System.Drawing.Point(92, 233)
Me.txtTime.Margin = New System.Windows.Forms.Padding(3, 2, 3, 3)
Me.txtTime.Name = "txtTime"
Me.txtTime.Size = New System.Drawing.Size(48, 20)
Me.txtTime.TabIndex = 9
'
'lblTime
'
Me.lblTime.AutoSize = True
Me.lblTime.Location = New System.Drawing.Point(8, 236)
Me.lblTime.Name = "lblTime"
Me.lblTime.Size = New System.Drawing.Size(85, 14)
Me.lblTime.TabIndex = 11
Me.lblTime.Text = "Execution Time:"
'
'txtRows
'
Me.txtRows.Location = New System.Drawing.Point(250, 233)
Me.txtRows.Margin = New System.Windows.Forms.Padding(1, 2, 3, 3)
Me.txtRows.Name = "txtRows"
Me.txtRows.Size = New System.Drawing.Size(35, 20)
Me.txtRows.TabIndex = 10
'
'lblBatch
'
Me.lblBatch.AutoSize = True
Me.lblBatch.Location = New System.Drawing.Point(228, 94)
Me.lblBatch.Name = "lblBatch"
Me.lblBatch.Size = New System.Drawing.Size(41, 14)
Me.lblBatch.TabIndex = 8
Me.lblBatch.Text = "(Batch)"
'
'cboYearESC
'
Me.cboYearESC.Enabled = False
Me.cboYearESC.FormattingEnabled = True
Me.cboYearESC.Items.AddRange(New Object() {"1996", "1997", "1998"})
Me.cboYearESC.Location = New System.Drawing.Point(158, 91)
Me.cboYearESC.Margin = New System.Windows.Forms.Padding(3, 1, 3, 2)
Me.cboYearESC.Name = "cboYearESC"
Me.cboYearESC.Size = New System.Drawing.Size(57, 21)
Me.cboYearESC.TabIndex = 7
'
'rbEmployeeSales
'
Me.rbEmployeeSales.AutoSize = True
Me.rbEmployeeSales.Location = New System.Drawing.Point(7, 92)
Me.rbEmployeeSales.Name = "rbEmployeeSales"
Me.rbEmployeeSales.Size = New System.Drawing.Size(144, 17)
Me.rbEmployeeSales.TabIndex = 6
Me.rbEmployeeSales.Text = "EmployeeSalesByCountry:"
'
'cboYearSBC
'
Me.cboYearSBC.Enabled = False
Me.cboYearSBC.FormattingEnabled = True
Me.cboYearSBC.Items.AddRange(New Object() {"1996", "1997", "1998"})
Me.cboYearSBC.Location = New System.Drawing.Point(228, 65)
Me.cboYearSBC.Name = "cboYearSBC"
Me.cboYearSBC.Size = New System.Drawing.Size(57, 21)
Me.cboYearSBC.TabIndex = 5
'
'cboCategoryName
'
Me.cboCategoryName.Enabled = False
Me.cboCategoryName.FormattingEnabled = True
Me.cboCategoryName.Items.AddRange(New Object() {"Beverages", "Condiments", "Confections", "Dairy Products", "Grains/Cereals", "Produce", "Seafood"})
Me.cboCategoryName.Location = New System.Drawing.Point(116, 66)
Me.cboCategoryName.Margin = New System.Windows.Forms.Padding(3, 3, 3, 1)
Me.cboCategoryName.Name = "cboCategoryName"
Me.cboCategoryName.Size = New System.Drawing.Size(99, 21)
Me.cboCategoryName.TabIndex = 4
'
'rbByCategory
'
Me.rbByCategory.AutoSize = True
Me.rbByCategory.Location = New System.Drawing.Point(7, 65)
Me.rbByCategory.Name = "rbByCategory"
Me.rbByCategory.Size = New System.Drawing.Size(104, 17)
Me.rbByCategory.TabIndex = 3
Me.rbByCategory.Text = "SalesByCategory:"
'
'txtCustomerID
'
Me.txtCustomerID.Enabled = False
Me.txtCustomerID.Location = New System.Drawing.Point(139, 39)
Me.txtCustomerID.Margin = New System.Windows.Forms.Padding(0, 3, 3, 3)
Me.txtCustomerID.Name = "txtCustomerID"
Me.txtCustomerID.Size = New System.Drawing.Size(47, 20)
Me.txtCustomerID.TabIndex = 2
Me.txtCustomerID.Text = "RATTC"
'
'rbOrderHistory
'
Me.rbOrderHistory.AutoSize = True
Me.rbOrderHistory.Location = New System.Drawing.Point(7, 39)
Me.rbOrderHistory.Margin = New System.Windows.Forms.Padding(3, 3, 1, 3)
Me.rbOrderHistory.Name = "rbOrderHistory"
Me.rbOrderHistory.Size = New System.Drawing.Size(129, 17)
Me.rbOrderHistory.TabIndex = 1
Me.rbOrderHistory.Text = "CustomerOrderHistory::"
'
'rbMostExpensive
'
Me.rbMostExpensive.AutoSize = True
Me.rbMostExpensive.Location = New System.Drawing.Point(7, 15)
Me.rbMostExpensive.Name = "rbMostExpensive"
Me.rbMostExpensive.Size = New System.Drawing.Size(154, 17)
Me.rbMostExpensive.TabIndex = 0
Me.rbMostExpensive.Text = "TenMostExpensiveProducts"
'
'lblHeader
'
Me.lblHeader.AutoSize = True
Me.lblHeader.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
Me.lblHeader.Location = New System.Drawing.Point(13, 8)
Me.lblHeader.Name = "lblHeader"
Me.lblHeader.Size = New System.Drawing.Size(363, 17)
Me.lblHeader.TabIndex = 2
Me.lblHeader.Text = "Select a WebMethod to Invoke and Fill the DataGridView"
'
'txtSoapError
'
Me.txtSoapError.Location = New System.Drawing.Point(516, 8)
Me.txtSoapError.Multiline = True
Me.txtSoapError.Name = "txtSoapError"
Me.txtSoapError.ScrollBars = System.Windows.Forms.ScrollBars.Both
Me.txtSoapError.Size = New System.Drawing.Size(100, 20)
Me.txtSoapError.TabIndex = 3
Me.txtSoapError.Visible = False
Me.txtSoapError.WordWrap = False
'
'Client
'
'Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13)
Me.AutoScaleDimensions = New System.Drawing.SizeF(6.0!, 13.0!)
Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
Me.ClientSize = New System.Drawing.Size(633, 307)
Me.Controls.Add(Me.txtSoapError)
Me.Controls.Add(Me.lblHeader)
Me.Controls.Add(Me.gbWebMethod)
Me.Controls.Add(Me.dgvNwind)
Me.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog
Me.MaximizeBox = False
Me.MinimizeBox = False
Me.Name = "Client"
Me.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen
Me.Text = "SQL Server 2005 Native SOAP Web Service Using HTTP.sys"
CType(Me.dgvNwind, System.ComponentModel.ISupportInitialize).EndInit()
Me.gbWebMethod.ResumeLayout(False)
Me.gbWebMethod.PerformLayout()
Me.ResumeLayout(False)
Me.PerformLayout()
End Sub
Friend WithEvents dgvNwind As System.Windows.Forms.DataGridView
Friend WithEvents gbWebMethod As System.Windows.Forms.GroupBox
Friend WithEvents rbMostExpensive As System.Windows.Forms.RadioButton
Friend WithEvents rbOrderHistory As System.Windows.Forms.RadioButton
Friend WithEvents txtCustomerID As System.Windows.Forms.TextBox
Friend WithEvents rbByCategory As System.Windows.Forms.RadioButton
Friend WithEvents cboCategoryName As System.Windows.Forms.ComboBox
Friend WithEvents cboYearSBC As System.Windows.Forms.ComboBox
Friend WithEvents rbEmployeeSales As System.Windows.Forms.RadioButton
Friend WithEvents cboYearESC As System.Windows.Forms.ComboBox
Friend WithEvents lblHeader As System.Windows.Forms.Label
Friend WithEvents lblBatch As System.Windows.Forms.Label
Friend WithEvents txtTime As System.Windows.Forms.TextBox
Friend WithEvents txtRows As System.Windows.Forms.TextBox
Friend WithEvents lblTime As System.Windows.Forms.Label
Friend WithEvents lblRows As System.Windows.Forms.Label
Friend WithEvents txtSQL As System.Windows.Forms.TextBox
Friend WithEvents rbBatch As System.Windows.Forms.RadioButton
Friend WithEvents btnExecute As System.Windows.Forms.Button
Friend WithEvents btnExecuteCustID As System.Windows.Forms.Button
Friend WithEvents txtSoapError As System.Windows.Forms.TextBox
End Class
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?