DataGrid

Left

Horizontal position in device-independent points, relative to the parent container.

Range: -100000 to 100000.

Top

Vertical position in device-independent points, relative to the parent container.

Range: -100000 to 100000.

Width

Control width in device-independent points.

Range: 0 to 100000.

Designer starting value: 420.

Height

Control height in device-independent points.

Range: 0 to 100000.

Designer starting value: 220.

MinWidth

Minimum control width in device-independent points; 0 lets the parent layout choose.

Range: 0 to 100000.

MinHeight

Minimum control height in device-independent points; 0 lets the parent layout choose.

Range: 0 to 100000.

MaxWidth

Maximum control width in device-independent points.

Range: 0 to 100000.

MaxHeight

Maximum control height in device-independent points.

Range: 0 to 100000.

TabIndex

Keyboard navigation order within the parent container; lower values come first.

Range: 0 to 100000.

ZIndex

Stacking order among sibling controls; larger values appear in front. Equal values preserve document order.

Range: -100000 to 100000.

Anchor

Edges kept at their authored distance when the parent resizes. Use a comma-separated combination of Left, Top, Right and Bottom; Dock overrides the effective anchor without deleting it.

Dock

Automatic placement within the parent: None, Left, Top, Right, Bottom or Fill. Dock overrides effective Anchor layout without deleting the stored anchors.

Margin

External spacing as one non-negative DIP value or Left,Top,Right,Bottom.

Visible

Whether the control is shown in the running application.

Enabled

Whether the control accepts user interaction in the running application.

HitTestVisible

Whether the running control participates in pointer hit testing. The control remains selectable in the Designer.

AllowDrop

Whether this running control accepts application drag-and-drop operations; Designer movement is separate.

DragMode

VB control drag: 0 Manual (code starts a drag with the Drag method) or 1 Automatic (a left-button press starts a drag, and the control raises no Click, MouseDown or MouseUp for that press).

Range: 0 to 1.

DragIcon

Case-insensitive name of a declared project image resource shown under the pointer while this control is dragged; empty shows a grey outline of the control.

Font

Cell text font as Family|Size or Family|Size|Regular/Bold|Normal/Italic, size 6–96 DIP. Empty uses the theme font.

ForeColor

Cell text color as #RRGGBB. Empty uses the Form or theme foreground.

BackColor

Grid row and surface fill as #RRGGBB. Empty uses the theme fill.

AccessibleName

Name announced by assistive technology. Empty uses the stable control Name.

Cursor

Pointer shown over the control: Default, Arrow, Hand, IBeam, Cross, Wait, Help, SizeAll, SizeNS, SizeWE, SizeNWSE, SizeNESW or NotAllowed.

Opacity

Visual opacity from 0 (transparent) to 1 (opaque).

Range: 0 to 1.

DesignLocked

Prevents movement and resizing in the Designer without changing runtime interaction.

AccessibleDescription

Additional help text announced by assistive technology.

AccessibleRole

Accessibility role override. Auto preserves the native semantic role; explicit values use the corresponding platform automation role.

AutomationId

Stable automation identifier; empty uses the component Name.

TabStop

Whether Tab navigation can move focus to this DataGrid.

ToolTipText

Help text shown when the pointer rests over the running control; empty disables the tooltip.

Tag

Application-defined text associated with this control; McBasic™ does not interpret it.

RowHeight

Height of each data row in device-independent points (18–200).

Range: 18 to 200.

KeyColumn

Optional unique BindingSource column used for SelectedKey and row identity. The key column is hidden in the grid; empty shows all columns.

Columns

Visible BindingSource columns in display order, separated by commas. Write name|Header to show a header caption, for example status|Status,due_date|Due date; the grid still binds, edits and saves through the column name. Empty generates all columns; KeyColumn stays hidden.

FilterColumn

Column searched by the local filter. Empty searches visible columns. Only rows already loaded in the BindingSource are searched.

FilterText

Case-insensitive text contained in loaded rows; empty disables local filtering. This does not filter or page the SQLite provider.

Loading

Shows the loading state while BASIC is fetching a BindingSource. Clear when the asynchronous operation finishes.

LoadingText

Message shown while Loading is true, unless ErrorText is set.

EmptyText

Message shown when the bound result has zero rows and no loading or error state is active.

ErrorText

Nonempty error message shown over the grid until BASIC clears it. Errors take priority over loading and empty states.

IsReadOnly

When false, cell text is validated against the existing BindingSource value kind and kept in its in-memory edit buffer.

CanUserSortColumns

Allows local column sorting in the standard DataGrid.

CanUserResizeColumns

Allows local column resizing in the standard DataGrid.

HeadersVisible

Shows column headers for the bound result.

AlternatingRowBackColor

Background of every second row as #RRGGBB; empty paints all rows alike.

GridLines

Lines between cells: None, Horizontal (between rows), Vertical (between columns) or Both.

FrozenColumns

Number of leftmost columns that stay in place when the grid scrolls sideways.

Range: 0 to 1000.

ShowRowNumbers

Shows 1-based row numbers in a header column. HeadersVisible still controls the column headers.

Index

Position of this control in its control array, 0 to 32767. Several controls share one name only when every one of them has an Index. Absent from the layout, and -1 in code, when the control is not in an array.

Designer values: 0 to 32767. Clear the dedicated Index row for a non-array control; BASIC then reads -1.

SelectionChanged

Occurs after the effective selection changes.

Private Sub control_SelectionChanged()

No parameters.

CellClick

Occurs once for a pressed data cell; indexes are zero-based source-row and visible-column indexes.

Private Sub control_CellClick(ByVal RowIndex As Integer, ByVal ColumnIndex As Integer)

CellDoubleClick

Occurs for a double-clicked data cell; indexes are zero-based source-row and visible-column indexes.

Private Sub control_CellDoubleClick(ByVal RowIndex As Integer, ByVal ColumnIndex As Integer)

CellBeginEdit

Occurs before cell editing starts; set Cancel to True to prevent editing.

Private Sub control_CellBeginEdit(ByVal RowIndex As Integer, ByVal ColumnIndex As Integer, ByRef Cancel As Boolean)

CellEndEdit

Occurs after cell editing finishes, whether committed or cancelled.

Private Sub control_CellEndEdit(ByVal RowIndex As Integer, ByVal ColumnIndex As Integer)

CellValueChanged

Occurs after a committed data cell value changes; indexes are zero-based.

Private Sub control_CellValueChanged(ByVal RowIndex As Integer, ByVal ColumnIndex As Integer)

CurrentCellChanged

Occurs when keyboard navigation or pointer input changes the current cell.

Private Sub control_CurrentCellChanged()

No parameters.

RowEnter

Occurs when the current cell enters a different zero-based source row.

Private Sub control_RowEnter(ByVal RowIndex As Integer)

RowLeave

Occurs when the current cell leaves a zero-based source row.

Private Sub control_RowLeave(ByVal RowIndex As Integer)

ColumnHeaderClick

Occurs for a completed column-header click, even when user sorting is disabled; ColumnIndex is zero-based.

Private Sub control_ColumnHeaderClick(ByVal ColumnIndex As Integer)

Sorting

Occurs before local user sorting; set Cancel to True to keep the current row order.

Private Sub control_Sorting(ByVal ColumnIndex As Integer, ByRef Cancel As Boolean)

Sorted

Occurs after an accepted local user sort has updated the grid view.

Private Sub control_Sorted(ByVal ColumnIndex As Integer)

DataError

Occurs when cell conversion or binding rejects a value; set Handled to True to suppress the standard error presentation.

Private Sub control_DataError(ByVal RowIndex As Integer, ByVal ColumnIndex As Integer, ByVal Message As String, ByRef Handled As Boolean)

DragEnter

Occurs when runtime drag data enters this control; set Effect to Copy, Move, Link or None.

Private Sub control_DragEnter(ByVal Data As DragData, ByRef Effect As DragEffect, ByVal X As Double, ByVal Y As Double)

DragOver

Occurs while runtime drag data moves over this control; Effect may be updated for the current position.

Private Sub control_DragOver(ByVal Data As DragData, ByRef Effect As DragEffect, ByVal X As Double, ByVal Y As Double)

DragOver

Occurs while a control dragged inside the app (DragMode or the Drag method) moves over this control: State is 0 when it enters, 2 while it moves over and 1 when it leaves; Source is the dragged control and X, Y are local DIP coordinates.

Private Sub control_DragOver(ByVal Source As Control, ByVal X As Single, ByVal Y As Single, ByVal State As Integer)

DragLeave

Occurs when runtime drag data leaves this control without a drop.

Private Sub control_DragLeave()

No parameters.

Drop

Occurs when runtime drag data is dropped on this control with a stable McBasic™ effect and local DIP coordinates.

Private Sub control_Drop(ByVal Data As DragData, ByVal Effect As DragEffect, ByVal X As Double, ByVal Y As Double)

DragDrop

Occurs when a control dragged inside the app (DragMode or the Drag method) is released over this control; Source is the dragged control and X, Y are local DIP coordinates.

Private Sub control_DragDrop(ByVal Source As Control, ByVal X As Single, ByVal Y As Single)

MouseDown

Occurs when a pointing-device button is pressed over this control; Button is stable McBasic™ identity and X/Y are control-local DIP coordinates.

Private Sub control_MouseDown(ByVal Button As MouseButton, ByVal Shift As KeyModifiers, ByVal X As Double, ByVal Y As Double)

MouseUp

Occurs when a pointing-device button is released for this control; Button is stable McBasic™ identity and X/Y are control-local DIP coordinates.

Private Sub control_MouseUp(ByVal Button As MouseButton, ByVal Shift As KeyModifiers, ByVal X As Double, ByVal Y As Double)

MouseMove

Occurs when the pointer moves over the logical McBasic™ control; Button contains the currently held buttons and X/Y are local DIP coordinates.

Private Sub control_MouseMove(ByVal Button As MouseButtons, ByVal Shift As KeyModifiers, ByVal X As Double, ByVal Y As Double)

MouseEnter

Occurs once when the pointer enters the effective bounds of the logical McBasic™ control.

Private Sub control_MouseEnter()

No parameters.

MouseLeave

Occurs once when the pointer leaves the effective bounds of the logical McBasic™ control.

Private Sub control_MouseLeave()

No parameters.

MouseWheel

Occurs for normalized pointer-wheel input; Delta is portable, and X/Y are local DIP coordinates.

Private Sub control_MouseWheel(ByVal Delta As Double, ByVal Shift As KeyModifiers, ByVal X As Double, ByVal Y As Double)

GotFocus

Occurs once when the DataGrid receives effective keyboard focus.

Private Sub control_GotFocus()

No parameters.

LostFocus

Occurs once when the DataGrid loses effective keyboard focus.

Private Sub control_LostFocus()

No parameters.

KeyDown

Occurs when a physical key is pressed while this control owns effective keyboard focus; setting Handled suppresses normal processing.

Private Sub control_KeyDown(ByVal KeyCode As KeyCode, ByVal Shift As KeyModifiers, ByRef Handled As Boolean)

KeyPress

Occurs for committed Unicode text input; set Handled to suppress the control default.

Private Sub control_KeyPress(ByVal Character As String, ByRef Handled As Boolean)

KeyUp

Occurs when a physical key is released while this control owns effective keyboard focus; setting Handled suppresses normal processing.

Private Sub control_KeyUp(ByVal KeyCode As KeyCode, ByVal Shift As KeyModifiers, ByRef Handled As Boolean)

SetFocus

Sub SetFocus()

Call on your instance: grdProducts.SetFocus.