frmmain.vb

Tutorial on data access using store procedure for MSSQL

        Me.btnGetProducts.TabIndex = CType(resources.GetObject("btnGetProducts.TabIndex"), Integer)
        Me.btnGetProducts.Text = resources.GetString("btnGetProducts.Text")
        Me.btnGetProducts.TextAlign = CType(resources.GetObject("btnGetProducts.TextAlign"), System.Drawing.ContentAlignment)
        Me.btnGetProducts.Visible = CType(resources.GetObject("btnGetProducts.Visible"), Boolean)
        '
        'cboCategoriesInputParam
        '
        Me.cboCategoriesInputParam.AccessibleDescription = resources.GetString("cboCategoriesInputParam.AccessibleDescription")
        Me.cboCategoriesInputParam.AccessibleName = resources.GetString("cboCategoriesInputParam.AccessibleName")
        Me.cboCategoriesInputParam.Anchor = CType(resources.GetObject("cboCategoriesInputParam.Anchor"), System.Windows.Forms.AnchorStyles)
        Me.cboCategoriesInputParam.BackgroundImage = CType(resources.GetObject("cboCategoriesInputParam.BackgroundImage"), System.Drawing.Image)
        Me.cboCategoriesInputParam.Dock = CType(resources.GetObject("cboCategoriesInputParam.Dock"), System.Windows.Forms.DockStyle)
        Me.cboCategoriesInputParam.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
        Me.cboCategoriesInputParam.Enabled = CType(resources.GetObject("cboCategoriesInputParam.Enabled"), Boolean)
        Me.cboCategoriesInputParam.Font = CType(resources.GetObject("cboCategoriesInputParam.Font"), System.Drawing.Font)
        Me.cboCategoriesInputParam.ImeMode = CType(resources.GetObject("cboCategoriesInputParam.ImeMode"), System.Windows.Forms.ImeMode)
        Me.cboCategoriesInputParam.IntegralHeight = CType(resources.GetObject("cboCategoriesInputParam.IntegralHeight"), Boolean)
        Me.cboCategoriesInputParam.ItemHeight = CType(resources.GetObject("cboCategoriesInputParam.ItemHeight"), Integer)
        Me.cboCategoriesInputParam.Location = CType(resources.GetObject("cboCategoriesInputParam.Location"), System.Drawing.Point)
        Me.cboCategoriesInputParam.MaxDropDownItems = CType(resources.GetObject("cboCategoriesInputParam.MaxDropDownItems"), Integer)
        Me.cboCategoriesInputParam.MaxLength = CType(resources.GetObject("cboCategoriesInputParam.MaxLength"), Integer)
        Me.cboCategoriesInputParam.Name = "cboCategoriesInputParam"
        Me.cboCategoriesInputParam.RightToLeft = CType(resources.GetObject("cboCategoriesInputParam.RightToLeft"), System.Windows.Forms.RightToLeft)
        Me.cboCategoriesInputParam.Size = CType(resources.GetObject("cboCategoriesInputParam.Size"), System.Drawing.Size)
        Me.cboCategoriesInputParam.TabIndex = CType(resources.GetObject("cboCategoriesInputParam.TabIndex"), Integer)
        Me.cboCategoriesInputParam.Text = resources.GetString("cboCategoriesInputParam.Text")
        Me.cboCategoriesInputParam.Visible = CType(resources.GetObject("cboCategoriesInputParam.Visible"), Boolean)
        '
        'Label3
        '
        Me.Label3.AccessibleDescription = resources.GetString("Label3.AccessibleDescription")
        Me.Label3.AccessibleName = resources.GetString("Label3.AccessibleName")
        Me.Label3.Anchor = CType(resources.GetObject("Label3.Anchor"), System.Windows.Forms.AnchorStyles)
        Me.Label3.AutoSize = CType(resources.GetObject("Label3.AutoSize"), Boolean)
        Me.Label3.Dock = CType(resources.GetObject("Label3.Dock"), System.Windows.Forms.DockStyle)
        Me.Label3.Enabled = CType(resources.GetObject("Label3.Enabled"), Boolean)
        Me.Label3.Font = CType(resources.GetObject("Label3.Font"), System.Drawing.Font)
        Me.Label3.Image = CType(resources.GetObject("Label3.Image"), System.Drawing.Image)
        Me.Label3.ImageAlign = CType(resources.GetObject("Label3.ImageAlign"), System.Drawing.ContentAlignment)
        Me.Label3.ImageIndex = CType(resources.GetObject("Label3.ImageIndex"), Integer)
        Me.Label3.ImeMode = CType(resources.GetObject("Label3.ImeMode"), System.Windows.Forms.ImeMode)
        Me.Label3.Location = CType(resources.GetObject("Label3.Location"), System.Drawing.Point)
        Me.Label3.Name = "Label3"
        Me.Label3.RightToLeft = CType(resources.GetObject("Label3.RightToLeft"), System.Windows.Forms.RightToLeft)
        Me.Label3.Size = CType(resources.GetObject("Label3.Size"), System.Drawing.Size)
        Me.Label3.TabIndex = CType(resources.GetObject("Label3.TabIndex"), Integer)
        Me.Label3.Text = resources.GetString("Label3.Text")
        Me.Label3.TextAlign = CType(resources.GetObject("Label3.TextAlign"), System.Drawing.ContentAlignment)
        Me.Label3.Visible = CType(resources.GetObject("Label3.Visible"), Boolean)
        '
        'pgeAllTypes
        '
        Me.pgeAllTypes.AccessibleDescription = resources.GetString("pgeAllTypes.AccessibleDescription")
        Me.pgeAllTypes.AccessibleName = resources.GetString("pgeAllTypes.AccessibleName")
        Me.pgeAllTypes.Anchor = CType(resources.GetObject("pgeAllTypes.Anchor"), System.Windows.Forms.AnchorStyles)
        Me.pgeAllTypes.AutoScroll = CType(resources.GetObject("pgeAllTypes.AutoScroll"), Boolean)
        Me.pgeAllTypes.AutoScrollMargin = CType(resources.GetObject("pgeAllTypes.AutoScrollMargin"), System.Drawing.Size)
        Me.pgeAllTypes.AutoScrollMinSize = CType(resources.GetObject("pgeAllTypes.AutoScrollMinSize"), System.Drawing.Size)
        Me.pgeAllTypes.BackgroundImage = CType(resources.GetObject("pgeAllTypes.BackgroundImage"), System.Drawing.Image)
        Me.pgeAllTypes.Controls.AddRange(New System.Windows.Forms.Control() {Me.lblProductCountAndAvgPrice, Me.Label5, Me.btnGetProductCountAndAvgPrice, Me.cboCategoriesAllTypes, Me.Label6})
        Me.pgeAllTypes.Dock = CType(resources.GetObject("pgeAllTypes.Dock"), System.Windows.Forms.DockStyle)
        Me.pgeAllTypes.Enabled = CType(resources.GetObject("pgeAllTypes.Enabled"), Boolean)
        Me.pgeAllTypes.Font = CType(resources.GetObject("pgeAllTypes.Font"), System.Drawing.Font)
        Me.pgeAllTypes.ImageIndex = CType(resources.GetObject("pgeAllTypes.ImageIndex"), Integer)
        Me.pgeAllTypes.ImeMode = CType(resources.GetObject("pgeAllTypes.ImeMode"), System.Windows.Forms.ImeMode)
        Me.pgeAllTypes.Location = CType(resources.GetObject("pgeAllTypes.Location"), System.Drawing.Point)
        Me.pgeAllTypes.Name = "pgeAllTypes"
        Me.pgeAllTypes.RightToLeft = CType(resources.GetObject("pgeAllTypes.RightToLeft"), System.Windows.Forms.RightToLeft)
        Me.pgeAllTypes.Size = CType(resources.GetObject("pgeAllTypes.Size"), System.Drawing.Size)
        Me.pgeAllTypes.TabIndex = CType(resources.GetObject("pgeAllTypes.TabIndex"), Integer)
        Me.pgeAllTypes.Text = resources.GetString("pgeAllTypes.Text")
        Me.pgeAllTypes.ToolTipText = resources.GetString("pgeAllTypes.ToolTipText")
        Me.pgeAllTypes.Visible = CType(resources.GetObject("pgeAllTypes.Visible"), Boolean)
        '
        'lblProductCountAndAvgPrice
        '
        Me.lblProductCountAndAvgPrice.AccessibleDescription = resources.GetString("lblProductCountAndAvgPrice.AccessibleDescription")
        Me.lblProductCountAndAvgPrice.AccessibleName = resources.GetString("lblProductCountAndAvgPrice.AccessibleName")
        Me.lblProductCountAndAvgPrice.Anchor = CType(resources.GetObject("lblProductCountAndAvgPrice.Anchor"), System.Windows.Forms.AnchorStyles)
        Me.lblProductCountAndAvgPrice.AutoSize = CType(resources.GetObject("lblProductCountAndAvgPrice.AutoSize"), Boolean)
        Me.lblProductCountAndAvgPrice.Dock = CType(resources.GetObject("lblProductCountAndAvgPrice.Dock"), System.Windows.Forms.DockStyle)
        Me.lblProductCountAndAvgPrice.Enabled = CType(resources.GetObject("lblProductCountAndAvgPrice.Enabled"), Boolean)
        Me.lblProductCountAndAvgPrice.Font = CType(resources.GetObject("lblProductCountAndAvgPrice.Font"), System.Drawing.Font)
        Me.lblProductCountAndAvgPrice.Image = CType(resources.GetObject("lblProductCountAndAvgPrice.Image"), System.Drawing.Image)
        Me.lblProductCountAndAvgPrice.ImageAlign = CType(resources.GetObject("lblProductCountAndAvgPrice.ImageAlign"), System.Drawing.ContentAlignment)
        Me.lblProductCountAndAvgPrice.ImageIndex = CType(resources.GetObject("lblProductCountAndAvgPrice.ImageIndex"), Integer)
        Me.lblProductCountAndAvgPrice.ImeMode = CType(resources.GetObject("lblProductCountAndAvgPrice.ImeMode"), System.Windows.Forms.ImeMode)
        Me.lblProductCountAndAvgPrice.Location = CType(resources.GetObject("lblProductCountAndAvgPrice.Location"), System.Drawing.Point)
        Me.lblProductCountAndAvgPrice.Name = "lblProductCountAndAvgPrice"
        Me.lblProductCountAndAvgPrice.RightToLeft = CType(resources.GetObject("lblProductCountAndAvgPrice.RightToLeft"), System.Windows.Forms.RightToLeft)
        Me.lblProductCountAndAvgPrice.Size = CType(resources.GetObject("lblProductCountAndAvgPrice.Size"), System.Drawing.Size)
        Me.lblProductCountAndAvgPrice.TabIndex = CType(resources.GetObject("lblProductCountAndAvgPrice.TabIndex"), Integer)
        Me.lblProductCountAndAvgPrice.Text = resources.GetString("lblProductCountAndAvgPrice.Text")
        Me.lblProductCountAndAvgPrice.TextAlign = CType(resources.GetObject("lblProductCountAndAvgPrice.TextAlign"), System.Drawing.ContentAlignment)
        Me.lblProductCountAndAvgPrice.Visible = CType(resources.GetObject("lblProductCountAndAvgPrice.Visible"), Boolean)
        '
        'Label5
        '
        Me.Label5.AccessibleDescription = resources.GetString("Label5.AccessibleDescription")
        Me.Label5.AccessibleName = resources.GetString("Label5.AccessibleName")
        Me.Label5.Anchor = CType(resources.GetObject("Label5.Anchor"), System.Windows.Forms.AnchorStyles)
        Me.Label5.AutoSize = CType(resources.GetObject("Label5.AutoSize"), Boolean)
        Me.Label5.Dock = CType(resources.GetObject("Label5.Dock"), System.Windows.Forms.DockStyle)
        Me.Label5.Enabled = CType(resources.GetObject("Label5.Enabled"), Boolean)
        Me.Label5.Font = CType(resources.GetObject("Label5.Font"), System.Drawing.Font)
        Me.Label5.Image = CType(resources.GetObject("Label5.Image"), System.Drawing.Image)
        Me.Label5.ImageAlign = CType(resources.GetObject("Label5.ImageAlign"), System.Drawing.ContentAlignment)
        Me.Label5.ImageIndex = CType(resources.GetObject("Label5.ImageIndex"), Integer)
        Me.Label5.ImeMode = CType(resources.GetObject("Label5.ImeMode"), System.Windows.Forms.ImeMode)
        Me.Label5.Location = CType(resources.GetObject("Label5.Location"), System.Drawing.Point)
        Me.Label5.Name = "Label5"
        Me.Label5.RightToLeft = CType(resources.GetObject("Label5.RightToLeft"), System.Windows.Forms.RightToLeft)
        Me.Label5.Size = CType(resources.GetObject("Label5.Size"), System.Drawing.Size)
        Me.Label5.TabIndex = CType(resources.GetObject("Label5.TabIndex"), Integer)
        Me.Label5.Text = resources.GetString("Label5.Text")
        Me.Label5.TextAlign = CType(resources.GetObject("Label5.TextAlign"), System.Drawing.ContentAlignment)
        Me.Label5.Visible = CType(resources.GetObject("Label5.Visible"), Boolean)
        '
        'btnGetProductCountAndAvgPrice
        '
        Me.btnGetProductCountAndAvgPrice.AccessibleDescription = resources.GetString("btnGetProductCountAndAvgPrice.AccessibleDescription")
        Me.btnGetProductCountAndAvgPrice.AccessibleName = resources.GetString("btnGetProductCountAndAvgPrice.AccessibleName")
        Me.btnGetProductCountAndAvgPrice.Anchor = CType(resources.GetObject("btnGetProductCountAndAvgPrice.Anchor"), System.Windows.Forms.AnchorStyles)
        Me.btnGetProductCountAndAvgPrice.BackgroundImage = CType(resources.GetObject("btnGetProductCountAndAvgPrice.BackgroundImage"), System.Drawing.Image)
        Me.btnGetProductCountAndAvgPrice.Dock = CType(resources.GetObject("btnGetProductCountAndAvgPrice.Dock"), System.Windows.Forms.DockStyle)
        Me.btnGetProductCountAndAvgPrice.Enabled = CType(resources.GetObject("btnGetProductCountAndAvgPrice.Enabled"), Boolean)
        Me.btnGetProductCountAndAvgPrice.FlatStyle = CType(resources.GetObject("btnGetProductCountAndAvgPrice.FlatStyle"), System.Windows.Forms.FlatStyle)
        Me.btnGetProductCountAndAvgPrice.Font = CType(resources.GetObject("btnGetProductCountAndAvgPrice.Font"), System.Drawing.Font)
        Me.btnGetProductCountAndAvgPrice.Image = CType(resources.GetObject("btnGetProductCountAndAvgPrice.Image"), System.Drawing.Image)
        Me.btnGetProductCountAndAvgPrice.ImageAlign = CType(resources.GetObject("btnGetProductCountAndAvgPrice.ImageAlign"), System.Drawing.ContentAlignment)
        Me.btnGetProductCountAndAvgPrice.ImageIndex = CType(resources.GetObject("btnGetProductCountAndAvgPrice.ImageIndex"), Integer)
        Me.btnGetProductCountAndAvgPrice.ImeMode = CType(resources.GetObject("btnGetProductCountAndAvgPrice.ImeMode"), System.Windows.Forms.ImeMode)
        Me.btnGetProductCountAndAvgPrice.Location = CType(resources.GetObject("btnGetProductCountAndAvgPrice.Location"), System.Drawing.Point)
        Me.btnGetProductCountAndAvgPrice.Name = "btnGetProductCountAndAvgPrice"
        Me.btnGetProductCountAndAvgPrice.RightToLeft = CType(resources.GetObject("btnGetProductCountAndAvgPrice.RightToLeft"), System.Windows.Forms.RightToLeft)
        Me.btnGetProductCountAndAvgPrice.Size = CType(resources.GetObject("btnGetProductCountAndAvgPrice.Size"), System.Drawing.Size)
        Me.btnGetProductCountAndAvgPrice.TabIndex = CType(resources.GetObject("btnGetProductCountAndAvgPrice.TabIndex"), Integer)
        Me.btnGetProductCountAndAvgPrice.Text = resources.GetString("btnGetProductCountAndAvgPrice.Text")
        Me.btnGetProductCountAndAvgPrice.TextAlign = CType(resources.GetObject("btnGetProductCountAndAvgPrice.TextAlign"), System.Drawing.ContentAlignment)
        Me.btnGetProductCountAndAvgPrice.Visible = CType(resources.GetObject("btnGetProductCountAndAvgPrice.Visible"), Boolean)
        '
        'cboCategoriesAllTypes
        '
        Me.cboCategoriesAllTypes.AccessibleDescription = resources.GetString("cboCategoriesAllTypes.AccessibleDescription")
        Me.cboCategoriesAllTypes.AccessibleName = resources.GetString("cboCategoriesAllTypes.AccessibleName")
        Me.cboCategoriesAllTypes.Anchor = CType(resources.GetObject("cboCategoriesAllTypes.Anchor"), System.Windows.Forms.AnchorStyles)
        Me.cboCategoriesAllTypes.BackgroundImage = CType(resources.GetObject("cboCategoriesAllTypes.BackgroundImage"), System.Drawing.Image)
        Me.cboCategoriesAllTypes.Dock = CType(resources.GetObject("cboCategoriesAllTypes.Dock"), System.Windows.Forms.DockStyle)
        Me.cboCategoriesAllTypes.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
        Me.cboCategoriesAllTypes.Enabled = CType(resources.GetObject("cboCategoriesAllTypes.Enabled"), Boolean)
        Me.cboCategoriesAllTypes.Font = CType(resources.GetObject("cboCategoriesAllTypes.Font"), System.Drawing.Font)
        Me.cboCategoriesAllTypes.ImeMode = CType(resources.GetObject("cboCategoriesAllTypes.ImeMode"), System.Windows.Forms.ImeMode)
        Me.cboCategoriesAllTypes.IntegralHeight = CType(resources.GetObject("cboCategoriesAllTypes.IntegralHeight"), Boolean)
        Me.cboCategoriesAllTypes.ItemHeight = CType(resources.GetObject("cboCategoriesAllTypes.ItemHeight"), Integer)
        Me.cboCategoriesAllTypes.Location = CType(resources.GetObject("cboCategoriesAllTypes.Location"), System.Drawing.Point)
        Me.cboCategoriesAllTypes.MaxDropDownItems = CType(resources.GetObject("cboCategoriesAllTypes.MaxDropDownItems"), Integer)
        Me.cboCategoriesAllTypes.MaxLength = CType(resources.GetObject("cboCategoriesAllTypes.MaxLength"), Integer)
        Me.cboCategoriesAllTypes.Name = "cboCategoriesAllTypes"
        Me.cboCategoriesAllTypes.RightToLeft = CType(resources.GetObject("cboCategoriesAllTypes.RightToLeft"), System.Windows.Forms.RightToLeft)