frmmain.vb

Tutorial on data access using store procedure for MSSQL

        Me.pgeNoParams.Text = resources.GetString("pgeNoParams.Text")
        Me.pgeNoParams.ToolTipText = resources.GetString("pgeNoParams.ToolTipText")
        Me.pgeNoParams.Visible = CType(resources.GetObject("pgeNoParams.Visible"), Boolean)
        '
        'txtTenMostExpProds
        '
        Me.txtTenMostExpProds.AccessibleDescription = resources.GetString("txtTenMostExpProds.AccessibleDescription")
        Me.txtTenMostExpProds.AccessibleName = resources.GetString("txtTenMostExpProds.AccessibleName")
        Me.txtTenMostExpProds.Anchor = CType(resources.GetObject("txtTenMostExpProds.Anchor"), System.Windows.Forms.AnchorStyles)
        Me.txtTenMostExpProds.AutoSize = CType(resources.GetObject("txtTenMostExpProds.AutoSize"), Boolean)
        Me.txtTenMostExpProds.BackgroundImage = CType(resources.GetObject("txtTenMostExpProds.BackgroundImage"), System.Drawing.Image)
        Me.txtTenMostExpProds.Dock = CType(resources.GetObject("txtTenMostExpProds.Dock"), System.Windows.Forms.DockStyle)
        Me.txtTenMostExpProds.Enabled = CType(resources.GetObject("txtTenMostExpProds.Enabled"), Boolean)
        Me.txtTenMostExpProds.Font = CType(resources.GetObject("txtTenMostExpProds.Font"), System.Drawing.Font)
        Me.txtTenMostExpProds.ImeMode = CType(resources.GetObject("txtTenMostExpProds.ImeMode"), System.Windows.Forms.ImeMode)
        Me.txtTenMostExpProds.Location = CType(resources.GetObject("txtTenMostExpProds.Location"), System.Drawing.Point)
        Me.txtTenMostExpProds.MaxLength = CType(resources.GetObject("txtTenMostExpProds.MaxLength"), Integer)
        Me.txtTenMostExpProds.Multiline = CType(resources.GetObject("txtTenMostExpProds.Multiline"), Boolean)
        Me.txtTenMostExpProds.Name = "txtTenMostExpProds"
        Me.txtTenMostExpProds.PasswordChar = CType(resources.GetObject("txtTenMostExpProds.PasswordChar"), Char)
        Me.txtTenMostExpProds.RightToLeft = CType(resources.GetObject("txtTenMostExpProds.RightToLeft"), System.Windows.Forms.RightToLeft)
        Me.txtTenMostExpProds.ScrollBars = CType(resources.GetObject("txtTenMostExpProds.ScrollBars"), System.Windows.Forms.ScrollBars)
        Me.txtTenMostExpProds.Size = CType(resources.GetObject("txtTenMostExpProds.Size"), System.Drawing.Size)
        Me.txtTenMostExpProds.TabIndex = CType(resources.GetObject("txtTenMostExpProds.TabIndex"), Integer)
        Me.txtTenMostExpProds.Text = resources.GetString("txtTenMostExpProds.Text")
        Me.txtTenMostExpProds.TextAlign = CType(resources.GetObject("txtTenMostExpProds.TextAlign"), System.Windows.Forms.HorizontalAlignment)
        Me.txtTenMostExpProds.Visible = CType(resources.GetObject("txtTenMostExpProds.Visible"), Boolean)
        Me.txtTenMostExpProds.WordWrap = CType(resources.GetObject("txtTenMostExpProds.WordWrap"), Boolean)
        '
        'Label1
        '
        Me.Label1.AccessibleDescription = resources.GetString("Label1.AccessibleDescription")
        Me.Label1.AccessibleName = resources.GetString("Label1.AccessibleName")
        Me.Label1.Anchor = CType(resources.GetObject("Label1.Anchor"), System.Windows.Forms.AnchorStyles)
        Me.Label1.AutoSize = CType(resources.GetObject("Label1.AutoSize"), Boolean)
        Me.Label1.Dock = CType(resources.GetObject("Label1.Dock"), System.Windows.Forms.DockStyle)
        Me.Label1.Enabled = CType(resources.GetObject("Label1.Enabled"), Boolean)
        Me.Label1.Font = CType(resources.GetObject("Label1.Font"), System.Drawing.Font)
        Me.Label1.Image = CType(resources.GetObject("Label1.Image"), System.Drawing.Image)
        Me.Label1.ImageAlign = CType(resources.GetObject("Label1.ImageAlign"), System.Drawing.ContentAlignment)
        Me.Label1.ImageIndex = CType(resources.GetObject("Label1.ImageIndex"), Integer)
        Me.Label1.ImeMode = CType(resources.GetObject("Label1.ImeMode"), System.Windows.Forms.ImeMode)
        Me.Label1.Location = CType(resources.GetObject("Label1.Location"), System.Drawing.Point)
        Me.Label1.Name = "Label1"
        Me.Label1.RightToLeft = CType(resources.GetObject("Label1.RightToLeft"), System.Windows.Forms.RightToLeft)
        Me.Label1.Size = CType(resources.GetObject("Label1.Size"), System.Drawing.Size)
        Me.Label1.TabIndex = CType(resources.GetObject("Label1.TabIndex"), Integer)
        Me.Label1.Text = resources.GetString("Label1.Text")
        Me.Label1.TextAlign = CType(resources.GetObject("Label1.TextAlign"), System.Drawing.ContentAlignment)
        Me.Label1.Visible = CType(resources.GetObject("Label1.Visible"), Boolean)
        '
        'btnGet10MostExpProds
        '
        Me.btnGet10MostExpProds.AccessibleDescription = resources.GetString("btnGet10MostExpProds.AccessibleDescription")
        Me.btnGet10MostExpProds.AccessibleName = resources.GetString("btnGet10MostExpProds.AccessibleName")
        Me.btnGet10MostExpProds.Anchor = CType(resources.GetObject("btnGet10MostExpProds.Anchor"), System.Windows.Forms.AnchorStyles)
        Me.btnGet10MostExpProds.BackgroundImage = CType(resources.GetObject("btnGet10MostExpProds.BackgroundImage"), System.Drawing.Image)
        Me.btnGet10MostExpProds.Dock = CType(resources.GetObject("btnGet10MostExpProds.Dock"), System.Windows.Forms.DockStyle)
        Me.btnGet10MostExpProds.Enabled = CType(resources.GetObject("btnGet10MostExpProds.Enabled"), Boolean)
        Me.btnGet10MostExpProds.FlatStyle = CType(resources.GetObject("btnGet10MostExpProds.FlatStyle"), System.Windows.Forms.FlatStyle)
        Me.btnGet10MostExpProds.Font = CType(resources.GetObject("btnGet10MostExpProds.Font"), System.Drawing.Font)
        Me.btnGet10MostExpProds.Image = CType(resources.GetObject("btnGet10MostExpProds.Image"), System.Drawing.Image)
        Me.btnGet10MostExpProds.ImageAlign = CType(resources.GetObject("btnGet10MostExpProds.ImageAlign"), System.Drawing.ContentAlignment)
        Me.btnGet10MostExpProds.ImageIndex = CType(resources.GetObject("btnGet10MostExpProds.ImageIndex"), Integer)
        Me.btnGet10MostExpProds.ImeMode = CType(resources.GetObject("btnGet10MostExpProds.ImeMode"), System.Windows.Forms.ImeMode)
        Me.btnGet10MostExpProds.Location = CType(resources.GetObject("btnGet10MostExpProds.Location"), System.Drawing.Point)
        Me.btnGet10MostExpProds.Name = "btnGet10MostExpProds"
        Me.btnGet10MostExpProds.RightToLeft = CType(resources.GetObject("btnGet10MostExpProds.RightToLeft"), System.Windows.Forms.RightToLeft)
        Me.btnGet10MostExpProds.Size = CType(resources.GetObject("btnGet10MostExpProds.Size"), System.Drawing.Size)
        Me.btnGet10MostExpProds.TabIndex = CType(resources.GetObject("btnGet10MostExpProds.TabIndex"), Integer)
        Me.btnGet10MostExpProds.Text = resources.GetString("btnGet10MostExpProds.Text")
        Me.btnGet10MostExpProds.TextAlign = CType(resources.GetObject("btnGet10MostExpProds.TextAlign"), System.Drawing.ContentAlignment)
        Me.btnGet10MostExpProds.Visible = CType(resources.GetObject("btnGet10MostExpProds.Visible"), Boolean)
        '
        'pgeInputParam
        '
        Me.pgeInputParam.AccessibleDescription = resources.GetString("pgeInputParam.AccessibleDescription")
        Me.pgeInputParam.AccessibleName = resources.GetString("pgeInputParam.AccessibleName")
        Me.pgeInputParam.Anchor = CType(resources.GetObject("pgeInputParam.Anchor"), System.Windows.Forms.AnchorStyles)
        Me.pgeInputParam.AutoScroll = CType(resources.GetObject("pgeInputParam.AutoScroll"), Boolean)
        Me.pgeInputParam.AutoScrollMargin = CType(resources.GetObject("pgeInputParam.AutoScrollMargin"), System.Drawing.Size)
        Me.pgeInputParam.AutoScrollMinSize = CType(resources.GetObject("pgeInputParam.AutoScrollMinSize"), System.Drawing.Size)
        Me.pgeInputParam.BackgroundImage = CType(resources.GetObject("pgeInputParam.BackgroundImage"), System.Drawing.Image)
        Me.pgeInputParam.Controls.AddRange(New System.Windows.Forms.Control() {Me.Label4, Me.grdProducts, Me.btnGetProducts, Me.cboCategoriesInputParam, Me.Label3})
        Me.pgeInputParam.Dock = CType(resources.GetObject("pgeInputParam.Dock"), System.Windows.Forms.DockStyle)
        Me.pgeInputParam.Enabled = CType(resources.GetObject("pgeInputParam.Enabled"), Boolean)
        Me.pgeInputParam.Font = CType(resources.GetObject("pgeInputParam.Font"), System.Drawing.Font)
        Me.pgeInputParam.ImageIndex = CType(resources.GetObject("pgeInputParam.ImageIndex"), Integer)
        Me.pgeInputParam.ImeMode = CType(resources.GetObject("pgeInputParam.ImeMode"), System.Windows.Forms.ImeMode)
        Me.pgeInputParam.Location = CType(resources.GetObject("pgeInputParam.Location"), System.Drawing.Point)
        Me.pgeInputParam.Name = "pgeInputParam"
        Me.pgeInputParam.RightToLeft = CType(resources.GetObject("pgeInputParam.RightToLeft"), System.Windows.Forms.RightToLeft)
        Me.pgeInputParam.Size = CType(resources.GetObject("pgeInputParam.Size"), System.Drawing.Size)
        Me.pgeInputParam.TabIndex = CType(resources.GetObject("pgeInputParam.TabIndex"), Integer)
        Me.pgeInputParam.Text = resources.GetString("pgeInputParam.Text")
        Me.pgeInputParam.ToolTipText = resources.GetString("pgeInputParam.ToolTipText")
        Me.pgeInputParam.Visible = CType(resources.GetObject("pgeInputParam.Visible"), Boolean)
        '
        'Label4
        '
        Me.Label4.AccessibleDescription = resources.GetString("Label4.AccessibleDescription")
        Me.Label4.AccessibleName = resources.GetString("Label4.AccessibleName")
        Me.Label4.Anchor = CType(resources.GetObject("Label4.Anchor"), System.Windows.Forms.AnchorStyles)
        Me.Label4.AutoSize = CType(resources.GetObject("Label4.AutoSize"), Boolean)
        Me.Label4.Dock = CType(resources.GetObject("Label4.Dock"), System.Windows.Forms.DockStyle)
        Me.Label4.Enabled = CType(resources.GetObject("Label4.Enabled"), Boolean)
        Me.Label4.Font = CType(resources.GetObject("Label4.Font"), System.Drawing.Font)
        Me.Label4.Image = CType(resources.GetObject("Label4.Image"), System.Drawing.Image)
        Me.Label4.ImageAlign = CType(resources.GetObject("Label4.ImageAlign"), System.Drawing.ContentAlignment)
        Me.Label4.ImageIndex = CType(resources.GetObject("Label4.ImageIndex"), Integer)
        Me.Label4.ImeMode = CType(resources.GetObject("Label4.ImeMode"), System.Windows.Forms.ImeMode)
        Me.Label4.Location = CType(resources.GetObject("Label4.Location"), System.Drawing.Point)
        Me.Label4.Name = "Label4"
        Me.Label4.RightToLeft = CType(resources.GetObject("Label4.RightToLeft"), System.Windows.Forms.RightToLeft)
        Me.Label4.Size = CType(resources.GetObject("Label4.Size"), System.Drawing.Size)
        Me.Label4.TabIndex = CType(resources.GetObject("Label4.TabIndex"), Integer)
        Me.Label4.Text = resources.GetString("Label4.Text")
        Me.Label4.TextAlign = CType(resources.GetObject("Label4.TextAlign"), System.Drawing.ContentAlignment)
        Me.Label4.Visible = CType(resources.GetObject("Label4.Visible"), Boolean)
        '
        'grdProducts
        '
        Me.grdProducts.AccessibleDescription = resources.GetString("grdProducts.AccessibleDescription")
        Me.grdProducts.AccessibleName = resources.GetString("grdProducts.AccessibleName")
        Me.grdProducts.Anchor = CType(resources.GetObject("grdProducts.Anchor"), System.Windows.Forms.AnchorStyles)
        Me.grdProducts.BackgroundImage = CType(resources.GetObject("grdProducts.BackgroundImage"), System.Drawing.Image)
        Me.grdProducts.CaptionFont = CType(resources.GetObject("grdProducts.CaptionFont"), System.Drawing.Font)
        Me.grdProducts.CaptionText = resources.GetString("grdProducts.CaptionText")
        Me.grdProducts.DataMember = ""
        Me.grdProducts.Dock = CType(resources.GetObject("grdProducts.Dock"), System.Windows.Forms.DockStyle)
        Me.grdProducts.Enabled = CType(resources.GetObject("grdProducts.Enabled"), Boolean)
        Me.grdProducts.Font = CType(resources.GetObject("grdProducts.Font"), System.Drawing.Font)
        Me.grdProducts.HeaderForeColor = System.Drawing.SystemColors.ControlText
        Me.grdProducts.ImeMode = CType(resources.GetObject("grdProducts.ImeMode"), System.Windows.Forms.ImeMode)
        Me.grdProducts.Location = CType(resources.GetObject("grdProducts.Location"), System.Drawing.Point)
        Me.grdProducts.Name = "grdProducts"
        Me.grdProducts.RightToLeft = CType(resources.GetObject("grdProducts.RightToLeft"), System.Windows.Forms.RightToLeft)
        Me.grdProducts.Size = CType(resources.GetObject("grdProducts.Size"), System.Drawing.Size)
        Me.grdProducts.TabIndex = CType(resources.GetObject("grdProducts.TabIndex"), Integer)
        Me.grdProducts.Visible = CType(resources.GetObject("grdProducts.Visible"), Boolean)
        '
        'btnGetProducts
        '
        Me.btnGetProducts.AccessibleDescription = resources.GetString("btnGetProducts.AccessibleDescription")
        Me.btnGetProducts.AccessibleName = resources.GetString("btnGetProducts.AccessibleName")
        Me.btnGetProducts.Anchor = CType(resources.GetObject("btnGetProducts.Anchor"), System.Windows.Forms.AnchorStyles)
        Me.btnGetProducts.BackgroundImage = CType(resources.GetObject("btnGetProducts.BackgroundImage"), System.Drawing.Image)
        Me.btnGetProducts.Dock = CType(resources.GetObject("btnGetProducts.Dock"), System.Windows.Forms.DockStyle)
        Me.btnGetProducts.Enabled = CType(resources.GetObject("btnGetProducts.Enabled"), Boolean)
        Me.btnGetProducts.FlatStyle = CType(resources.GetObject("btnGetProducts.FlatStyle"), System.Windows.Forms.FlatStyle)
        Me.btnGetProducts.Font = CType(resources.GetObject("btnGetProducts.Font"), System.Drawing.Font)
        Me.btnGetProducts.Image = CType(resources.GetObject("btnGetProducts.Image"), System.Drawing.Image)
        Me.btnGetProducts.ImageAlign = CType(resources.GetObject("btnGetProducts.ImageAlign"), System.Drawing.ContentAlignment)
        Me.btnGetProducts.ImageIndex = CType(resources.GetObject("btnGetProducts.ImageIndex"), Integer)
        Me.btnGetProducts.ImeMode = CType(resources.GetObject("btnGetProducts.ImeMode"), System.Windows.Forms.ImeMode)
        Me.btnGetProducts.Location = CType(resources.GetObject("btnGetProducts.Location"), System.Drawing.Point)
        Me.btnGetProducts.Name = "btnGetProducts"
        Me.btnGetProducts.RightToLeft = CType(resources.GetObject("btnGetProducts.RightToLeft"), System.Windows.Forms.RightToLeft)
        Me.btnGetProducts.Size = CType(resources.GetObject("btnGetProducts.Size"), System.Drawing.Size)