frmmain.vb

Tutorial on data access using store procedure for MSSQL

        Me.cboCategoriesAllTypes.Size = CType(resources.GetObject("cboCategoriesAllTypes.Size"), System.Drawing.Size)
        Me.cboCategoriesAllTypes.TabIndex = CType(resources.GetObject("cboCategoriesAllTypes.TabIndex"), Integer)
        Me.cboCategoriesAllTypes.Text = resources.GetString("cboCategoriesAllTypes.Text")
        Me.cboCategoriesAllTypes.Visible = CType(resources.GetObject("cboCategoriesAllTypes.Visible"), Boolean)
        '
        'Label6
        '
        Me.Label6.AccessibleDescription = CType(resources.GetObject("Label6.AccessibleDescription"), String)
        Me.Label6.AccessibleName = CType(resources.GetObject("Label6.AccessibleName"), String)
        Me.Label6.Anchor = CType(resources.GetObject("Label6.Anchor"), System.Windows.Forms.AnchorStyles)
        Me.Label6.AutoSize = CType(resources.GetObject("Label6.AutoSize"), Boolean)
        Me.Label6.Dock = CType(resources.GetObject("Label6.Dock"), System.Windows.Forms.DockStyle)
        Me.Label6.Enabled = CType(resources.GetObject("Label6.Enabled"), Boolean)
        Me.Label6.Font = CType(resources.GetObject("Label6.Font"), System.Drawing.Font)
        Me.Label6.Image = CType(resources.GetObject("Label6.Image"), System.Drawing.Image)
        Me.Label6.ImageAlign = CType(resources.GetObject("Label6.ImageAlign"), System.Drawing.ContentAlignment)
        Me.Label6.ImageIndex = CType(resources.GetObject("Label6.ImageIndex"), Integer)
        Me.Label6.ImeMode = CType(resources.GetObject("Label6.ImeMode"), System.Windows.Forms.ImeMode)
        Me.Label6.Location = CType(resources.GetObject("Label6.Location"), System.Drawing.Point)
        Me.Label6.Name = "Label6"
        Me.Label6.RightToLeft = CType(resources.GetObject("Label6.RightToLeft"), System.Windows.Forms.RightToLeft)
        Me.Label6.Size = CType(resources.GetObject("Label6.Size"), System.Drawing.Size)
        Me.Label6.TabIndex = CType(resources.GetObject("Label6.TabIndex"), Integer)
        Me.Label6.Text = resources.GetString("Label6.Text")
        Me.Label6.TextAlign = CType(resources.GetObject("Label6.TextAlign"), System.Drawing.ContentAlignment)
        Me.Label6.Visible = CType(resources.GetObject("Label6.Visible"), Boolean)
        '
        'pgeMSAccess
        '
        Me.pgeMSAccess.AccessibleDescription = resources.GetString("pgeMSAccess.AccessibleDescription")
        Me.pgeMSAccess.AccessibleName = resources.GetString("pgeMSAccess.AccessibleName")
        Me.pgeMSAccess.Anchor = CType(resources.GetObject("pgeMSAccess.Anchor"), System.Windows.Forms.AnchorStyles)
        Me.pgeMSAccess.AutoScroll = CType(resources.GetObject("pgeMSAccess.AutoScroll"), Boolean)
        Me.pgeMSAccess.AutoScrollMargin = CType(resources.GetObject("pgeMSAccess.AutoScrollMargin"), System.Drawing.Size)
        Me.pgeMSAccess.AutoScrollMinSize = CType(resources.GetObject("pgeMSAccess.AutoScrollMinSize"), System.Drawing.Size)
        Me.pgeMSAccess.BackgroundImage = CType(resources.GetObject("pgeMSAccess.BackgroundImage"), System.Drawing.Image)
        Me.pgeMSAccess.Controls.AddRange(New System.Windows.Forms.Control() {Me.btnCreateReport, Me.txtEndingDate, Me.Label10, Me.Label9, Me.txtBeginningDate, Me.Label8, Me.grdSales, Me.lblNoSales})
        Me.pgeMSAccess.Dock = CType(resources.GetObject("pgeMSAccess.Dock"), System.Windows.Forms.DockStyle)
        Me.pgeMSAccess.Enabled = CType(resources.GetObject("pgeMSAccess.Enabled"), Boolean)
        Me.pgeMSAccess.Font = CType(resources.GetObject("pgeMSAccess.Font"), System.Drawing.Font)
        Me.pgeMSAccess.ImageIndex = CType(resources.GetObject("pgeMSAccess.ImageIndex"), Integer)
        Me.pgeMSAccess.ImeMode = CType(resources.GetObject("pgeMSAccess.ImeMode"), System.Windows.Forms.ImeMode)
        Me.pgeMSAccess.Location = CType(resources.GetObject("pgeMSAccess.Location"), System.Drawing.Point)
        Me.pgeMSAccess.Name = "pgeMSAccess"
        Me.pgeMSAccess.RightToLeft = CType(resources.GetObject("pgeMSAccess.RightToLeft"), System.Windows.Forms.RightToLeft)
        Me.pgeMSAccess.Size = CType(resources.GetObject("pgeMSAccess.Size"), System.Drawing.Size)
        Me.pgeMSAccess.TabIndex = CType(resources.GetObject("pgeMSAccess.TabIndex"), Integer)
        Me.pgeMSAccess.Text = resources.GetString("pgeMSAccess.Text")
        Me.pgeMSAccess.ToolTipText = resources.GetString("pgeMSAccess.ToolTipText")
        Me.pgeMSAccess.Visible = CType(resources.GetObject("pgeMSAccess.Visible"), Boolean)
        '
        'btnCreateReport
        '
        Me.btnCreateReport.AccessibleDescription = resources.GetString("btnCreateReport.AccessibleDescription")
        Me.btnCreateReport.AccessibleName = resources.GetString("btnCreateReport.AccessibleName")
        Me.btnCreateReport.Anchor = CType(resources.GetObject("btnCreateReport.Anchor"), System.Windows.Forms.AnchorStyles)
        Me.btnCreateReport.BackgroundImage = CType(resources.GetObject("btnCreateReport.BackgroundImage"), System.Drawing.Image)
        Me.btnCreateReport.Dock = CType(resources.GetObject("btnCreateReport.Dock"), System.Windows.Forms.DockStyle)
        Me.btnCreateReport.Enabled = CType(resources.GetObject("btnCreateReport.Enabled"), Boolean)
        Me.btnCreateReport.FlatStyle = CType(resources.GetObject("btnCreateReport.FlatStyle"), System.Windows.Forms.FlatStyle)
        Me.btnCreateReport.Font = CType(resources.GetObject("btnCreateReport.Font"), System.Drawing.Font)
        Me.btnCreateReport.Image = CType(resources.GetObject("btnCreateReport.Image"), System.Drawing.Image)
        Me.btnCreateReport.ImageAlign = CType(resources.GetObject("btnCreateReport.ImageAlign"), System.Drawing.ContentAlignment)
        Me.btnCreateReport.ImageIndex = CType(resources.GetObject("btnCreateReport.ImageIndex"), Integer)
        Me.btnCreateReport.ImeMode = CType(resources.GetObject("btnCreateReport.ImeMode"), System.Windows.Forms.ImeMode)
        Me.btnCreateReport.Location = CType(resources.GetObject("btnCreateReport.Location"), System.Drawing.Point)
        Me.btnCreateReport.Name = "btnCreateReport"
        Me.btnCreateReport.RightToLeft = CType(resources.GetObject("btnCreateReport.RightToLeft"), System.Windows.Forms.RightToLeft)
        Me.btnCreateReport.Size = CType(resources.GetObject("btnCreateReport.Size"), System.Drawing.Size)
        Me.btnCreateReport.TabIndex = CType(resources.GetObject("btnCreateReport.TabIndex"), Integer)
        Me.btnCreateReport.Text = resources.GetString("btnCreateReport.Text")
        Me.btnCreateReport.TextAlign = CType(resources.GetObject("btnCreateReport.TextAlign"), System.Drawing.ContentAlignment)
        Me.btnCreateReport.Visible = CType(resources.GetObject("btnCreateReport.Visible"), Boolean)
        '
        'txtEndingDate
        '
        Me.txtEndingDate.AccessibleDescription = resources.GetString("txtEndingDate.AccessibleDescription")
        Me.txtEndingDate.AccessibleName = resources.GetString("txtEndingDate.AccessibleName")
        Me.txtEndingDate.Anchor = CType(resources.GetObject("txtEndingDate.Anchor"), System.Windows.Forms.AnchorStyles)
        Me.txtEndingDate.AutoSize = CType(resources.GetObject("txtEndingDate.AutoSize"), Boolean)
        Me.txtEndingDate.BackgroundImage = CType(resources.GetObject("txtEndingDate.BackgroundImage"), System.Drawing.Image)
        Me.txtEndingDate.Dock = CType(resources.GetObject("txtEndingDate.Dock"), System.Windows.Forms.DockStyle)
        Me.txtEndingDate.Enabled = CType(resources.GetObject("txtEndingDate.Enabled"), Boolean)
        Me.txtEndingDate.Font = CType(resources.GetObject("txtEndingDate.Font"), System.Drawing.Font)
        Me.txtEndingDate.ImeMode = CType(resources.GetObject("txtEndingDate.ImeMode"), System.Windows.Forms.ImeMode)
        Me.txtEndingDate.Location = CType(resources.GetObject("txtEndingDate.Location"), System.Drawing.Point)
        Me.txtEndingDate.MaxLength = CType(resources.GetObject("txtEndingDate.MaxLength"), Integer)
        Me.txtEndingDate.Multiline = CType(resources.GetObject("txtEndingDate.Multiline"), Boolean)
        Me.txtEndingDate.Name = "txtEndingDate"
        Me.txtEndingDate.PasswordChar = CType(resources.GetObject("txtEndingDate.PasswordChar"), Char)
        Me.txtEndingDate.RightToLeft = CType(resources.GetObject("txtEndingDate.RightToLeft"), System.Windows.Forms.RightToLeft)
        Me.txtEndingDate.ScrollBars = CType(resources.GetObject("txtEndingDate.ScrollBars"), System.Windows.Forms.ScrollBars)
        Me.txtEndingDate.Size = CType(resources.GetObject("txtEndingDate.Size"), System.Drawing.Size)
        Me.txtEndingDate.TabIndex = CType(resources.GetObject("txtEndingDate.TabIndex"), Integer)
        Me.txtEndingDate.Text = resources.GetString("txtEndingDate.Text")
        Me.txtEndingDate.TextAlign = CType(resources.GetObject("txtEndingDate.TextAlign"), System.Windows.Forms.HorizontalAlignment)
        Me.txtEndingDate.Visible = CType(resources.GetObject("txtEndingDate.Visible"), Boolean)
        Me.txtEndingDate.WordWrap = CType(resources.GetObject("txtEndingDate.WordWrap"), Boolean)
        '
        'Label10
        '
        Me.Label10.AccessibleDescription = resources.GetString("Label10.AccessibleDescription")
        Me.Label10.AccessibleName = resources.GetString("Label10.AccessibleName")
        Me.Label10.Anchor = CType(resources.GetObject("Label10.Anchor"), System.Windows.Forms.AnchorStyles)
        Me.Label10.AutoSize = CType(resources.GetObject("Label10.AutoSize"), Boolean)
        Me.Label10.Dock = CType(resources.GetObject("Label10.Dock"), System.Windows.Forms.DockStyle)
        Me.Label10.Enabled = CType(resources.GetObject("Label10.Enabled"), Boolean)
        Me.Label10.Font = CType(resources.GetObject("Label10.Font"), System.Drawing.Font)
        Me.Label10.Image = CType(resources.GetObject("Label10.Image"), System.Drawing.Image)
        Me.Label10.ImageAlign = CType(resources.GetObject("Label10.ImageAlign"), System.Drawing.ContentAlignment)
        Me.Label10.ImageIndex = CType(resources.GetObject("Label10.ImageIndex"), Integer)
        Me.Label10.ImeMode = CType(resources.GetObject("Label10.ImeMode"), System.Windows.Forms.ImeMode)
        Me.Label10.Location = CType(resources.GetObject("Label10.Location"), System.Drawing.Point)
        Me.Label10.Name = "Label10"
        Me.Label10.RightToLeft = CType(resources.GetObject("Label10.RightToLeft"), System.Windows.Forms.RightToLeft)
        Me.Label10.Size = CType(resources.GetObject("Label10.Size"), System.Drawing.Size)
        Me.Label10.TabIndex = CType(resources.GetObject("Label10.TabIndex"), Integer)
        Me.Label10.Text = resources.GetString("Label10.Text")
        Me.Label10.TextAlign = CType(resources.GetObject("Label10.TextAlign"), System.Drawing.ContentAlignment)
        Me.Label10.Visible = CType(resources.GetObject("Label10.Visible"), Boolean)
        '
        'Label9
        '
        Me.Label9.AccessibleDescription = resources.GetString("Label9.AccessibleDescription")
        Me.Label9.AccessibleName = resources.GetString("Label9.AccessibleName")
        Me.Label9.Anchor = CType(resources.GetObject("Label9.Anchor"), System.Windows.Forms.AnchorStyles)
        Me.Label9.AutoSize = CType(resources.GetObject("Label9.AutoSize"), Boolean)
        Me.Label9.Dock = CType(resources.GetObject("Label9.Dock"), System.Windows.Forms.DockStyle)
        Me.Label9.Enabled = CType(resources.GetObject("Label9.Enabled"), Boolean)
        Me.Label9.Font = CType(resources.GetObject("Label9.Font"), System.Drawing.Font)
        Me.Label9.Image = CType(resources.GetObject("Label9.Image"), System.Drawing.Image)
        Me.Label9.ImageAlign = CType(resources.GetObject("Label9.ImageAlign"), System.Drawing.ContentAlignment)
        Me.Label9.ImageIndex = CType(resources.GetObject("Label9.ImageIndex"), Integer)
        Me.Label9.ImeMode = CType(resources.GetObject("Label9.ImeMode"), System.Windows.Forms.ImeMode)
        Me.Label9.Location = CType(resources.GetObject("Label9.Location"), System.Drawing.Point)
        Me.Label9.Name = "Label9"
        Me.Label9.RightToLeft = CType(resources.GetObject("Label9.RightToLeft"), System.Windows.Forms.RightToLeft)
        Me.Label9.Size = CType(resources.GetObject("Label9.Size"), System.Drawing.Size)
        Me.Label9.TabIndex = CType(resources.GetObject("Label9.TabIndex"), Integer)
        Me.Label9.Text = resources.GetString("Label9.Text")
        Me.Label9.TextAlign = CType(resources.GetObject("Label9.TextAlign"), System.Drawing.ContentAlignment)
        Me.Label9.Visible = CType(resources.GetObject("Label9.Visible"), Boolean)
        '
        'txtBeginningDate
        '
        Me.txtBeginningDate.AccessibleDescription = resources.GetString("txtBeginningDate.AccessibleDescription")
        Me.txtBeginningDate.AccessibleName = resources.GetString("txtBeginningDate.AccessibleName")
        Me.txtBeginningDate.Anchor = CType(resources.GetObject("txtBeginningDate.Anchor"), System.Windows.Forms.AnchorStyles)
        Me.txtBeginningDate.AutoSize = CType(resources.GetObject("txtBeginningDate.AutoSize"), Boolean)
        Me.txtBeginningDate.BackgroundImage = CType(resources.GetObject("txtBeginningDate.BackgroundImage"), System.Drawing.Image)
        Me.txtBeginningDate.Dock = CType(resources.GetObject("txtBeginningDate.Dock"), System.Windows.Forms.DockStyle)
        Me.txtBeginningDate.Enabled = CType(resources.GetObject("txtBeginningDate.Enabled"), Boolean)
        Me.txtBeginningDate.Font = CType(resources.GetObject("txtBeginningDate.Font"), System.Drawing.Font)
        Me.txtBeginningDate.ImeMode = CType(resources.GetObject("txtBeginningDate.ImeMode"), System.Windows.Forms.ImeMode)
        Me.txtBeginningDate.Location = CType