nwxmlcols.designer.vb

wrox出版社的另一套经典的VB2005数据库编程学习书籍,收集了书中源码,郑重推荐,电子书,电子书下载

Partial Public Class NwXmlCols
	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.components = New System.ComponentModel.Container
        Me.tabNwindXml = New System.Windows.Forms.TabControl
        Me.pagCustomers = New System.Windows.Forms.TabPage
        Me.chkCustXML2Index = New System.Windows.Forms.CheckBox
        Me.chkCustXML2Schema = New System.Windows.Forms.CheckBox
        Me.chkCustXML1Index = New System.Windows.Forms.CheckBox
        Me.chkCustXML1Schema = New System.Windows.Forms.CheckBox
        Me.btnCustomerCols = New System.Windows.Forms.Button
        Me.txtCustomerData = New System.Windows.Forms.TextBox
        Me.txtCustomerSQL = New System.Windows.Forms.TextBox
        Me.btnFillCustomerXML2 = New System.Windows.Forms.Button
        Me.btnFillCustomerXML1 = New System.Windows.Forms.Button
        Me.pagCustomersXQuery = New System.Windows.Forms.TabPage
        Me.chkUseSqlXml = New System.Windows.Forms.CheckBox
        Me.gbCustCol = New System.Windows.Forms.GroupBox
        Me.rbCustXML2 = New System.Windows.Forms.RadioButton
        Me.rbCustXML1 = New System.Windows.Forms.RadioButton
        Me.btnExecuteCusts = New System.Windows.Forms.Button
        Me.gbCustomersXQuery = New System.Windows.Forms.GroupBox
        Me.rbLastCustByValue = New System.Windows.Forms.RadioButton
        Me.rbDeleteFax = New System.Windows.Forms.RadioButton
        Me.rbModifyFax = New System.Windows.Forms.RadioButton
        Me.rbInsertFax = New System.Windows.Forms.RadioButton
        Me.rbFindFaxF = New System.Windows.Forms.RadioButton
        Me.rbFindByCustCountryF = New System.Windows.Forms.RadioButton
        Me.rbGetAllF = New System.Windows.Forms.RadioButton
        Me.rbFindByCustID = New System.Windows.Forms.RadioButton
        Me.txtCustsXQResult = New System.Windows.Forms.TextBox
        Me.txtCustsXQuery = New System.Windows.Forms.TextBox
        Me.pagOrders = New System.Windows.Forms.TabPage
        Me.chkUseSalesOrders = New System.Windows.Forms.CheckBox
        Me.chkUseXmlWriter = New System.Windows.Forms.CheckBox
        Me.gbOrdersXML1Indexes = New System.Windows.Forms.GroupBox
        Me.chkOrderXML1IndexProp = New System.Windows.Forms.CheckBox
        Me.chkOrderXML1IndexValue = New System.Windows.Forms.CheckBox
        Me.chkOrderXML1IndexPath = New System.Windows.Forms.CheckBox
        Me.chkOrderXML2Index = New System.Windows.Forms.CheckBox
        Me.chkOrderXML2Schema = New System.Windows.Forms.CheckBox
        Me.chkOrderXML1Index = New System.Windows.Forms.CheckBox
        Me.chkOrderXML1Schema = New System.Windows.Forms.CheckBox
        Me.btnOrderCols = New System.Windows.Forms.Button
        Me.txtOrderData = New System.Windows.Forms.TextBox
        Me.txtOrderSQL = New System.Windows.Forms.TextBox
        Me.btnFillOrderXML2 = New System.Windows.Forms.Button
        Me.btnFillOrderXML1 = New System.Windows.Forms.Button
        Me.gbOrdersXML2Indexes = New System.Windows.Forms.GroupBox
        Me.chkOrderXML2IndexProp = New System.Windows.Forms.CheckBox
        Me.chkOrderXML2IndexValue = New System.Windows.Forms.CheckBox
        Me.chkOrderXML2IndexPath = New System.Windows.Forms.CheckBox
        Me.pagOrdersXQuery = New System.Windows.Forms.TabPage
        Me.chkUseOrdersSqlXml = New System.Windows.Forms.CheckBox
        Me.gbOrdersXMLColumn = New System.Windows.Forms.GroupBox
        Me.rbOrderXML2 = New System.Windows.Forms.RadioButton
        Me.rbOrderXML1 = New System.Windows.Forms.RadioButton
        Me.btnExecuteOrders = New System.Windows.Forms.Button
        Me.gbOrdersXQuery = New System.Windows.Forms.GroupBox
        Me.rbUpdateOrders = New System.Windows.Forms.RadioButton
        Me.txtMaxRows = New System.Windows.Forms.TextBox
        Me.rbRandomIDs = New System.Windows.Forms.RadioButton
        Me.rbAggregationsF = New System.Windows.Forms.RadioButton
        Me.rbFindByOrderDatesF = New System.Windows.Forms.RadioButton
        Me.rbFindByOrderCountryF = New System.Windows.Forms.RadioButton
        Me.rbFindLastOrderByIdF = New System.Windows.Forms.RadioButton
        Me.rbGetAllOrdersF = New System.Windows.Forms.RadioButton
        Me.rbFindLastOrderById = New System.Windows.Forms.RadioButton
        Me.lblMaxRows = New System.Windows.Forms.Label
        Me.txtOrdersXQResult = New System.Windows.Forms.TextBox
        Me.txtOrdersXQuery = New System.Windows.Forms.TextBox
        Me.pbFillColumn = New System.Windows.Forms.ProgressBar
        Me.txtTime = New System.Windows.Forms.TextBox
        Me.txtRowsPerSec = New System.Windows.Forms.TextBox
        Me.lblTime = New System.Windows.Forms.Label
        Me.lblRowsPerSec = New System.Windows.Forms.Label
        Me.txtRows = New System.Windows.Forms.TextBox
        Me.lblRows = New System.Windows.Forms.Label
        Me.chkBytes = New System.Windows.Forms.CheckBox
        Me.ttNwXmlCols = New System.Windows.Forms.ToolTip(Me.components)
        Me.dgvShowPlan = New System.Windows.Forms.DataGridView
        Me.btnShowplan = New System.Windows.Forms.Button
        Me.tabNwindXml.SuspendLayout()
        Me.pagCustomers.SuspendLayout()
        Me.pagCustomersXQuery.SuspendLayout()
        Me.gbCustCol.SuspendLayout()
        Me.gbCustomersXQuery.SuspendLayout()
        Me.pagOrders.SuspendLayout()
        Me.gbOrdersXML1Indexes.SuspendLayout()
        Me.gbOrdersXML2Indexes.SuspendLayout()
        Me.pagOrdersXQuery.SuspendLayout()
        Me.gbOrdersXMLColumn.SuspendLayout()
        Me.gbOrdersXQuery.SuspendLayout()
        CType(Me.dgvShowPlan, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.SuspendLayout()
        '
        'tabNwindXml
        '
        Me.tabNwindXml.Controls.Add(Me.pagCustomers)
        Me.tabNwindXml.Controls.Add(Me.pagCustomersXQuery)
        Me.tabNwindXml.Controls.Add(Me.pagOrders)
        Me.tabNwindXml.Controls.Add(Me.pagOrdersXQuery)
        Me.tabNwindXml.Location = New System.Drawing.Point(5, 7)
        Me.tabNwindXml.Name = "tabNwindXml"
        Me.tabNwindXml.SelectedIndex = 0
        Me.tabNwindXml.Size = New System.Drawing.Size(672, 423)
        Me.tabNwindXml.TabIndex = 3
        '
        'pagCustomers
        '
        Me.pagCustomers.Controls.Add(Me.chkCustXML2Index)
        Me.pagCustomers.Controls.Add(Me.chkCustXML2Schema)
        Me.pagCustomers.Controls.Add(Me.chkCustXML1Index)
        Me.pagCustomers.Controls.Add(Me.chkCustXML1Schema)
        Me.pagCustomers.Controls.Add(Me.btnCustomerCols)
        Me.pagCustomers.Controls.Add(Me.txtCustomerData)
        Me.pagCustomers.Controls.Add(Me.txtCustomerSQL)
        Me.pagCustomers.Controls.Add(Me.btnFillCustomerXML2)
        Me.pagCustomers.Controls.Add(Me.btnFillCustomerXML1)
        Me.pagCustomers.Location = New System.Drawing.Point(4, 22)
        Me.pagCustomers.Name = "pagCustomers"
        Me.pagCustomers.Padding = New System.Windows.Forms.Padding(3)
        Me.pagCustomers.Size = New System.Drawing.Size(664, 397)
        Me.pagCustomers.TabIndex = 0
        Me.pagCustomers.Text = "Customers Table"
        '
        'chkCustXML2Index
        '
        Me.chkCustXML2Index.AutoSize = True
        Me.chkCustXML2Index.Enabled = False
        Me.chkCustXML2Index.Location = New System.Drawing.Point(602, 121)
        Me.chkCustXML2Index.Name = "chkCustXML2Index"
        Me.chkCustXML2Index.Size = New System.Drawing.Size(59, 17)
        Me.chkCustXML2Index.TabIndex = 6
        Me.chkCustXML2Index.Text = "Indexes"
        '
        'chkCustXML2Schema
        '
        Me.chkCustXML2Schema.AutoSize = True
        Me.chkCustXML2Schema.Location = New System.Drawing.Point(534, 121)
        Me.chkCustXML2Schema.Name = "chkCustXML2Schema"
        Me.chkCustXML2Schema.Size = New System.Drawing.Size(61, 17)
        Me.chkCustXML2Schema.TabIndex = 5
        Me.chkCustXML2Schema.Text = "Schema"
        '
        'chkCustXML1Index
        '
        Me.chkCustXML1Index.AutoSize = True
        Me.chkCustXML1Index.Enabled = False
        Me.chkCustXML1Index.Location = New System.Drawing.Point(336, 121)
        Me.chkCustXML1Index.Name = "chkCustXML1Index"
        Me.chkCustXML1Index.Size = New System.Drawing.Size(59, 17)
        Me.chkCustXML1Index.TabIndex = 3
        Me.chkCustXML1Index.Text = "Indexes"
        '
        'chkCustXML1Schema
        '
        Me.chkCustXML1Schema.AutoSize = True
        Me.chkCustXML1Schema.Location = New System.Drawing.Point(268, 121)
        Me.chkCustXML1Schema.Name = "chkCustXML1Schema"
        Me.chkCustXML1Schema.Size = New System.Drawing.Size(61, 17)
        Me.chkCustXML1Schema.TabIndex = 2
        Me.chkCustXML1Schema.Text = "Schema"
        '
        'btnCustomerCols
        '
        Me.btnCustomerCols.Location = New System.Drawing.Point(8, 118)
        Me.btnCustomerCols.Name = "btnCustomerCols"
        Me.btnCustomerCols.Size = New System.Drawing.Size(111, 23)
        Me.btnCustomerCols.TabIndex = 25
        Me.btnCustomerCols.TabStop = False
        Me.btnCustomerCols.Text = "Add xml Columns"
        '
        'txtCustomerData
        '
        Me.txtCustomerData.AutoSize = False
        Me.txtCustomerData.Font = New System.Drawing.Font("Lucida Console", 9.0!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.txtCustomerData.Location = New System.Drawing.Point(8, 148)
        Me.txtCustomerData.Multiline = True
        Me.txtCustomerData.Name = "txtCustomerData"
        Me.txtCustomerData.ScrollBars = System.Windows.Forms.ScrollBars.Vertical
        Me.txtCustomerData.Size = New System.Drawing.Size(651, 243)
        Me.txtCustomerData.TabIndex = 6
        Me.txtCustomerData.TabStop = False
        '
        'txtCustomerSQL
        '
        Me.txtCustomerSQL.AutoSize = False
        Me.txtCustomerSQL.Font = New System.Drawing.Font("Lucida Console", 9.0!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.txtCustomerSQL.Location = New System.Drawing.Point(7, 7)
        Me.txtCustomerSQL.Multiline = True
        Me.txtCustomerSQL.Name = "txtCustomerSQL"
        Me.txtCustomerSQL.ScrollBars = System.Windows.Forms.ScrollBars.Vertical
        Me.txtCustomerSQL.Size = New System.Drawing.Size(651, 104)
        Me.txtCustomerSQL.TabIndex = 5
        Me.txtCustomerSQL.TabStop = False
        '
        'btnFillCustomerXML2
        '
        Me.btnFillCustomerXML2.Location = New System.Drawing.Point(412, 118)
        Me.btnFillCustomerXML2.Name = "btnFillCustomerXML2"
        Me.btnFillCustomerXML2.Size = New System.Drawing.Size(113, 23)
        Me.btnFillCustomerXML2.TabIndex = 4
        Me.btnFillCustomerXML2.Text = "Fill CustomerXML2"
        '
        'btnFillCustomerXML1
        '
        Me.btnFillCustomerXML1.Location = New System.Drawing.Point(148, 118)
        Me.btnFillCustomerXML1.Name = "btnFillCustomerXML1"
        Me.btnFillCustomerXML1.Size = New System.Drawing.Size(113, 23)
        Me.btnFillCustomerXML1.TabIndex = 1
        Me.btnFillCustomerXML1.Text = "Fill CustomerXML1"
        '
        'pagCustomersXQuery
        '
        Me.pagCustomersXQuery.Controls.Add(Me.chkUseSqlXml)
        Me.pagCustomersXQuery.Controls.Add(Me.gbCustCol)
        Me.pagCustomersXQuery.Controls.Add(Me.btnExecuteCusts)
        Me.pagCustomersXQuery.Controls.Add(Me.gbCustomersXQuery)
        Me.pagCustomersXQuery.Controls.Add(Me.txtCustsXQResult)
        Me.pagCustomersXQuery.Controls.Add(Me.txtCustsXQuery)
        Me.pagCustomersXQuery.Location = New System.Drawing.Point(4, 22)
        Me.pagCustomersXQuery.Name = "pagCustomersXQuery"
        Me.pagCustomersXQuery.Padding = New System.Windows.Forms.Padding(3)
        Me.pagCustomersXQuery.Size = New System.Drawing.Size(664, 397)
        Me.pagCustomersXQuery.TabIndex = 2
        Me.pagCustomersXQuery.Text = "Customers XQuery"
        '
        'chkUseSqlXml
        '
        Me.chkUseSqlXml.AutoSize = True
        Me.chkUseSqlXml.Checked = True
        Me.chkUseSqlXml.CheckState = System.Windows.Forms.CheckState.Checked
        Me.chkUseSqlXml.Location = New System.Drawing.Point(566, 186)
        Me.chkUseSqlXml.Name = "chkUseSqlXml"
        Me.chkUseSqlXml.Size = New System.Drawing.Size(76, 17)
        Me.chkUseSqlXml.TabIndex = 11