The SalFormTableWindow type exposes the following members.

Constructors

  NameDescription
Public methodSalFormTableWindow
Constructs a SalFormWindow object.

Methods

  NameDescription
Public methodAnyRows
Determines whether any rows in the specified table window match certain flags.
Public methodBringWindowToTop
Brings a window to the top of all overlapping windows.
(Inherited from SalForm.)
Public methodCenterWindow
Centers a window. If the window is a top-level window, it centers it on the desktop. If the window is a child window, it centers it on top of its parent.
(Inherited from SalForm.)
Public methodClearCursor
Clears a window's cursor.
(Inherited from SalForm.)
Public methodClearSelection
Deselects all rows of a table window.
Public methodColumnAverage
Computes the average of all column values or only specified column values in a table window.
Public methodColumnSum
Computes the sum of all column values or only specified column values in a table window.
Protected methodConvertMenuToContextMenuStrip
Called just before the ContextMenu is about to be shown, making it possible to convert the ContextMenu into a ContextMenuStrip instead.
(Inherited from SalForm.)
Public methodCopyRows
Copies the contents of the specified table window rows to the Clipboard in text format.
Public methodCreateColumn
Creates a table window column of string data type at runtime.
Public methodCreateColumnEx
Creates a table window column using a given data type at runtime. Allowed types are DT_String, DT_Number and DT_DateTime
Protected methodCreateForm
Creates the handle for the form and all the child controls.
(Inherited from SalForm.)
Protected methodCreateTableWindow
Creates an instance of the inner child table window.
(Inherited from SalForm.)
Public methodDefineRowHeader
Defines the appearance and behavior of a table window's row header.
Public methodDefineSplitWindow
Splits a table window horizontally.
Protected methodDefWndProc
Override the default window procedure to be able to create hidden mdi child forms. For some unknown reason the .NET framwork forces MDI children to be visible.
(Inherited from SalForm.)
Public methodDeleteRow
Deletes a row from a table window but not from the database.
Public methodDeleteSelected(SalSqlHandle)
Applies a SQL DELETE statement to all table window rows with the ROW Selected flag.
Public methodDeleteSelected(SalSqlHandle, WhenSqlErrorHandler)
Applies a SQL DELETE statement to all table window rows with the ROW Selected flag.
Public methodDestroyColumns
Destroys all automatic columns created by SalTblCreateColumn or SalTblPopulate at runtime. This function only works on table windows that contain only automatic columns.
Public methodDestroyWindow
Destroys a form window, a top-level table window, or a modeless dialog box created with SalCreateWindow.
(Inherited from SalForm.)
Public methodDisableWindow
Disables keyboard and mouse input to a window. If the window contains text (for example, a push button), the text is grayed. If the window is a data field, it cannot receive the focus.
(Inherited from SalForm.)
Protected methodDispose
(Inherited from SalForm.)
Public methodDoDeletes(SalSqlHandle, SalNumber)
Applies a SQL DELETE statement to all table window rows that have nFlagsOn flags.
Public methodDoDeletes(SalSqlHandle, SalNumber, WhenSqlErrorHandler)
Applies a SQL DELETE statement to all table window rows that have nFlagsOn flags.
Public methodDoInserts(SalSqlHandle, SalBoolean)
Applies a SQL INSERT statement to all the rows in a table window that have the ROW New flag.
Public methodDoInserts(SalSqlHandle, SalBoolean, WhenSqlErrorHandler)
Applies a SQL INSERT statement to all the rows in a table window that have the ROW New flag.
Public methodDoUpdates(SalSqlHandle, SalBoolean)
Applies a SQL UPDATE statement to all table window rows with the Row Edited flag.
Public methodDoUpdates(SalSqlHandle, SalBoolean, WhenSqlErrorHandler)
Applies a SQL UPDATE statement to all table window rows with the Row Edited flag.
Public methodDrawMenuBar
Redraws the menu bar for a given form window or top-level table window.
(Inherited from SalForm.)
Public methodEnableWindow
Enables keyboard and mouse input to a window.
(Inherited from SalForm.)
Public methodEndDialog
Destroys a modal dialog box and returns control to the caller of SalModalDialog.
(Inherited from SalForm.)
Public methodFetchRow
Sends a SAM_FetchRow message to a table window if the row you specify is not currently in the table window cache.
Public methodFindChild
This function finds a child window of a given name in the specified window.
(Inherited from SalForm.)
Public methodFindNextRow
Scans forward in a table looking for a row whose flags match those specified.
Public methodFindPrevRow
Scans backward in a table looking for a row whose flags match those specified.
Public methodFormUnitsToPixels
Computes the number of pixels in the number of form units. Form units are a unit of measurement used by functions which move and position objects. Form units are computed using physical units (pixels) in conjunction with the window's font size.
(Inherited from SalForm.)
Public methodGetClassName
Return the name of a window's class as a string.
(Inherited from SalForm.)
Public methodGetColumnText(SalNumber)
Gets data from a column of a table window's context row.
Public methodGetColumnText(SalNumber, SalString%)
Gets data from a column of a table window's context row.
Public methodGetColumnWindow
Gets the handle of a table window column.
Public methodGetContextRow
Returns a table window's current context row. Before sending a SAM_FetchRow message, automatically sets the context row so that assignments made while processing the message reference the correct row.
Public methodGetControlType
Returns an object's type.
(Inherited from SalForm.)
Public methodGetDefaultButton
Returns the handle of the default push button on a form window or dialog box. The default push button is the one that has the focus by default.
(Inherited from SalForm.)
Public methodGetFirstChild
Returns the handle of the first child window of the specified type. You can use this function to get the handles of MDI child windows.
(Inherited from SalForm.)
Public methodGetFont
Gets a window's font name, size, and enhancements.
(Inherited from SalForm.)
Public methodGetLinesPerRow()()()()
Retrieves the height of a row in lines.
Public methodGetLinesPerRow(SalNumber%)
Retrieves the height of a row in lines.
Public methodGetLocation
Returns a window's current position on the X and Y axes.
(Inherited from SalForm.)
Public methodGetLockedColumns
Retrieves the number of locked table window columns.
Public methodGetName()()()()
Gets the name of an object.
(Inherited from SalForm.)
Public methodGetName(SalString%)
Gets the name of an object.
(Inherited from SalForm.)
Public methodGetNextChild
Returns the handle of the next child window that matches a specified type.
(Inherited from SalForm.)
Public methodGetParent
Returns the handle of an object's parent window.
(Inherited from SalForm.)
Public methodGetProperty(SalString)
Gets the value of a named property.
(Inherited from SalForm.)
Public methodGetProperty(SalString, SalString%)
Gets the value of a named property.
(Inherited from SalForm.)
Public methodGetRowFlags
Queries a row's flags.
Public methodGetSize
Returns a window's size.
(Inherited from SalForm.)
Public methodGetStatusBarText(SalNumber)
Gets the text displayed in the status bar of a top-level or MDI window.
(Inherited from SalForm.)
Public methodGetStatusBarText(SalString%, SalNumber)
Gets the text displayed in the status bar of a top-level or MDI window.
(Inherited from SalForm.)
Public methodGetTableFlags
Tests the state of a table window's flags.
Public methodGetText(SalNumber)
Retrieves the text of a window.
(Inherited from SalForm.)
Public methodGetText(SalString%, SalNumber)
Retrieves the text of a window.
(Inherited from SalForm.)
Public methodGetWindowColor
Gets a window's color.
(Inherited from SalForm.)
Public methodGetWindowState
Returns a window's current state.
(Inherited from SalForm.)
Public methodHideWindow
Hides a window.
(Inherited from SalForm.)
Public methodHitTest
Returns the part of the table window located at a given coordinate.
Public methodInsertRow
Inserts a new blank row into a table window.
Public methodInvalidateWindow
Causes a window to be repainted.
(Inherited from SalForm.)
Public methodIsDerivedFromClass
Determines whether a window is an instance of the specified class.
(Inherited from SalForm.)
Public methodIsEnabled
Determines whether a window is enabled for mouse and keyboard input.
(Inherited from SalForm.)
Public methodIsVisible
Determines whether a window is currently visible.
(Inherited from SalForm.)
Public methodKillCellEdit
Takes a row out of edit mode and selects the row. This causes the row to receive both SAM_Validate and SAM_KillFocus messages.
Public methodKillFocusRow
Public methodKillTimer
Destroys an object's system timer.
(Inherited from SalForm.)
Public methodMoveWindow
Moves a window a given number of form units on the X and Y axes relative to its current position.
(Inherited from SalForm.)
Protected methodOnActivated (Inherited from SalForm.)
Protected methodOnControlAdded (Overrides Control..::..OnControlAdded(ControlEventArgs).)
Protected methodOnControlRemoved (Overrides Control..::..OnControlRemoved(ControlEventArgs).)
Protected methodOnDeactivate (Inherited from SalForm.)
Protected methodOnFontChanged
Resets the scaling factor when the font changes.
(Inherited from SalForm.)
Protected methodOnHandleCreated (Inherited from SalForm.)
Protected methodOnHandleDestroyed (Inherited from SalForm.)
Protected methodOnLayout (Overrides Form..::..OnLayout(LayoutEventArgs).)
Protected methodOnLoad (Overrides Form..::..OnLoad(EventArgs).)
Protected methodOnMdiChildActivate (Inherited from SalForm.)
Protected methodOnMenuComplete (Inherited from SalForm.)
Protected methodOnMouseDown
Attempts to automatically initiate drag mode if the control responds to SAM_DragCanAutoStart.
(Inherited from SalForm.)
Protected methodOnPaintBackground
Fires the internal PaintBackground event. This allows the handler component to take over the background painting of the form. This is primarily used to allow the SalQuickTabs control to paint transparent backgrounds.
(Inherited from SalForm.)
Public methodPasteRows
Pastes the contents of the Clipboard to the specified table window. Assumes the Clipboard data is in text format with cells delimited by tab characters and rows delimited by end-of-line characters. Inserts the new rows into the table window without overwriting existing rows, and converts the data to the data types of the corresponding table window columns.
Public methodPixelsToFormUnits
Computes the number of form units based on the number of pixels. Form units are a unit of measurement used by functions that move and position objects. Form units are computed using physical units (pixels) in conjunction with a window's font sizes.
(Inherited from SalForm.)
Public methodPopulate(SalSqlHandle, SalString)
Compiles, binds, and executes a SQL SELECT statement, then fetches the rows of the result set and populates a table window with them.
Public methodPopulate(SalSqlHandle, SalString, SalNumber)
Compiles, binds, and executes a SQL SELECT statement, then fetches the rows of the result set and populates a table window with them.
Public methodPopulate(SalSqlHandle, SalString, WhenSqlErrorHandler)
Compiles, binds, and executes a SQL SELECT statement, then fetches the rows of the result set and populates a table window with them.
Public methodPopulate(SalSqlHandle, SalString, SalNumber, WhenSqlErrorHandler)
Compiles, binds, and executes a SQL SELECT statement, then fetches the rows of the result set and populates a table window with them.
Public methodPostMessage
Posts the specified message to a window by adding nMsg to hWndReceiver's message queue.
(Inherited from SalForm.)
Protected methodProcessCmdKey
Process command keys.
(Inherited from SalForm.)
Protected methodProcessDialogKey
Processes dialog keys. This override takes care of: - converting Enter to Tab - selecting radio buttons in the same group index on arrows - processing default button, hidden or in child forms - processing accelerators
(Inherited from SalForm.)
Protected methodProcessTabKey
Selects the next control in the tab order.
(Inherited from SalForm.)
Public methodQueryFocusCell
Identifies the cell in a table window with the focus.
Public methodQueryRowHeader
Gets a table window's row header definition.
Public methodQueryScroll
Returns a table window's current scroll position and range. The scroll position is the row number of the row that is currently at the top of the window. You set the table window range with SalTblSetRange and changes it when you insert or delete rows from the table window.
Public methodQuerySplitWindow
Specifies how a table window is split horizontally.
Public methodQueryVisibleRange
Returns the current range of visible rows in a table window.
Public methodResetTable
Clears a table window by discarding all rows from the table window cache and setting the table range to 0, -1.
Protected methodScale
Scales the form and all child controls.
(Inherited from SalForm.)
Protected methodScaleCore
Disables .NET 1.1 scaling.
(Inherited from SalForm.)
Public methodScrollRow(SalNumber, Control)
Scrolls a table window to the specified row and column.
Public methodScrollRow(SalNumber, Control, SalNumber)
Scrolls a table window to the specified row and column.
Protected methodSelect
Selects the next control in the tab order.
(Inherited from SalForm.)
Public methodSendMessage
Sends the specified message to a window. SalSendMsg does not return until the processing for the message is complete.
(Inherited from SalForm.)
Public methodSendMessageToChildren
Sends a message to all child items of a form window, dialog box, table window, or MDI window.
(Inherited from SalForm.)
Public methodSetColumnText
Assigns data to a column of a table window's context row.
Public methodSetContextMenu(Type, SalNumber)
Defines a named popup menu that displays automatically when a window receives SAM_ContextMenu.
(Inherited from SalForm.)
Public methodSetContextMenu(SalString, SalNumber)
Defines a named popup menu that displays automatically when a window receives SAM_ContextMenu.
(Inherited from SalForm.)
Public methodSetContextRow
Sets a table window's context row. Setting the context row does not send a SAM_FetchRow message. If the row is not currently in memory, creates a new row in memory and sets its cell values to null.
Public methodSetCursor(Int32, SalNumber)
Sets a window's cursor.
(Inherited from SalForm.)
Public methodSetCursor(SalResourceCursor, SalNumber)
Sets a window's cursor.
(Inherited from SalForm.)
Public methodSetCursor(SalString, SalNumber)
Sets a window's cursor from a string variable.
(Inherited from SalForm.)
Public methodSetCursorFile
Sets an application-defined cursor for the specified window. Use this function to set the cursor from an image stored in a file.
(Inherited from SalForm.)
Public methodSetFlagsAnyRows
Sets or clears row flags.
Public methodSetFocus
Sets the focus to a specified window.
(Inherited from SalForm.)
Public methodSetFocusCell
Sets the focus to the specified table window cell (row and column). Puts the table window into edit mode and lets the user select a portion of the data in the cell.
Public methodSetFocusRow
Sets a table window's focus frame row.
Public methodSetFont
Sets a window's font, font size, and font enhancements.
(Inherited from SalForm.)
Public methodSetLinesPerRow
Sets the height of a row in lines.
Public methodSetLocation
Moves a window to a new position (x, y) on the X and Y axes.
(Inherited from SalForm.)
Public methodSetLockedColumns
Sets the number of locked table window columns.
Public methodSetProperty
Sets the value of a named property.
(Inherited from SalForm.)
Public methodSetRange
Defines the minimum and maximum rows (range) of a table.
Public methodSetRow
Sets the focus to the first, last, next, or previous row in a table window.
Public methodSetRowFlags
Sets or clears a table window row's flags.
Public methodSetSize
Resizes a window.
(Inherited from SalForm.)
Public methodSetStatusBarText
Displays specified text in the status bar of a top-level or MDI window.
(Inherited from SalForm.)
Public methodSetTableFlags
Sets or clears a table window's flags.
Public methodSetText
Sets the text of a window.
(Inherited from SalForm.)
Public methodSetTimer
Creates a system timer for a given object. When a timer event occurs, sends SAM_Timer messages to the object in specified intervals. Timers are a limited global resource. Your application must check the value returned by SalTimerSet to verify that the timer was created.
(Inherited from SalForm.)
Public methodSetWindowColor
Sets a window's color.
(Inherited from SalForm.)
Protected methodSetVisibleCore
Overrides the default behavior to avoid the re-creation of the underlying window handle when the form is an MDI child.
(Inherited from SalForm.)
Public methodShow
Shows the form.
(Inherited from SalForm.)
Public methodShowAsChild(Control, Rectangle, Boolean)
Shows the form as child control.
(Inherited from SalForm.)
Public methodShowAsChild(Control, RectangleF, Boolean)
Shows the form as child control.
(Inherited from SalForm.)
Public methodShowDialog
Shows the modal dialog.
(Inherited from SalForm.)
Public methodShowStatusBar
Shows or hides the status bar on a top-level or MDI window.
(Inherited from SalForm.)
Public methodShowToolBar
Shows or hides the tool bar on a top-level or MDI window.
(Inherited from SalForm.)
Public methodShowWindow
Makes a window visible.
(Inherited from SalForm.)
Public methodSortRows
Sorts the rows of a table window based on the values in one of the table window's columns.
Public methodTrackPopupMenu(Type, SalNumber, SalNumber, SalNumber)
Creates pop-up menus at runtime.
(Inherited from SalForm.)
Public methodTrackPopupMenu(SalString, SalNumber, SalNumber, SalNumber)
Creates pop-up menus at runtime.
(Inherited from SalForm.)
Public methodUpdateWindow
Forces the update of a window.
(Inherited from SalForm.)
Public methodWinHelp
Starts the Windows help system.
(Inherited from SalForm.)
Protected methodWndProc
Window procedure dispatcher, overloaded to restore the inner table window as the active control.
(Overrides SalForm..::..WndProc(Message%).)
Public methodYield
Processes messages for this control.
(Inherited from SalForm.)

Fields

  NameDescription
Public field_derived
Instance of the derived object that inherits this class as a second base in a multiple inheritance tree.
(Inherited from SalForm.)

Properties

  NameDescription
Public propertyAllowAutoEditing
Enables/Disables AutoEditing mode. When this mode is on, the grid automatically enters edit mode when a cell is selected.
Public propertyAllowRowSizing
Allow row sizing.
Public propertyAllowSorting
Enables/Disables automatic sorting on table columns.
Public propertyAutoScaleBaseDpi
Returns/Sets the DPI used to design this form. This is the base DPI scale and it will be used to scale the form.
(Inherited from SalForm.)
Public propertyColumns
Returns the collection of columns.
Protected propertyCreateParams
Overrides the CreateParams property to ensure that the correct Windows style is used when the form is a child form and the border is the FixedSingle border.
(Inherited from SalForm.)
Public propertyDesignTimeClientRectangle
Gets the designtime client rectrangle
(Inherited from SalForm.)
Public propertyDesignTimeFont Obsolete. (Inherited from SalForm.)
Public propertyDesignTimeSize (Inherited from SalForm.)
Public propertyExtendLastColumn
Enables/Disables the extension of the last column to fill the grid.
Public propertyIcon
Overrides the default Image property.
Public propertyIconName
Icon name. The image is loaded from the embedded resources.
(Inherited from SalForm.)
Public propertyItem
Returns the table column object at the specified position. The position is 1-based.
Public propertyLinesPerRow
Number of lines per row.
Public propertyNamedProperties
Returns the collection of named properties.
(Inherited from SalForm.)
Public propertyReadOnly
Returns/Sets the ReadOnly flag. When the ReadOnly flag is true the entire TableWindow control cannot be edited. However, the Mouse, scrolling and the Keyboard are still active.
Public propertyShowCellLabels
Gets or sets whether the grid should display labels over cells whose contents are partially hidden.
Public propertyShowCursor
Enables/Disables the arrow icon on the current row.
Public propertyShowFocusRow
Enables/Disables the focus frame around the current row.
Public propertyTableWindow
Returns the internal table window control.
Public propertyTrimming
Defines how to trim the content that doesn't fit the width of the cell.
Public propertyUseIFSThemeing
Gets or sets a value indication whether this window and it's child controls should be themed and custom painted or not. Note: Themeing of child controls is not controlled by this class, it simply provides information that child controls are expected to use in determining whether to theme themselves or not.
(Inherited from SalForm.)
Public propertyUseVisualStyles
Enables/Disabled drawing of columns and rows headers using the current visual style theme renderer.

Events

  NameDescription
Public eventMessageActions (Inherited from SalForm.)
Public eventPaintBackground (Inherited from SalForm.)

See Also