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 + -
显示快捷键?