code:

---

public winclass CSheridanDataGrid : CompoundControl
{
	// DO NOT CHANGE THIS TAG!!
	tag "[OLESSDBGrid]";

	// ------------------------------------------
	// NATIVE PROPERTIES
	// ------------------------------------------

	// Returns or sets the name of the ActiveRowStyleSet in the StyleSets collection. The ActiveRowStyleSet determines the style of the active row...
	property STRING sActiveRowStyleSet alias "$ActiveRowStyleSet"

	// Determines if new records are allowed to be added to the data grid by the user...
	property BOOLEAN xbAllowAddNew alias "$AllowAddNew"

	// Determines if columns can be moved by the user, and if so, the scope of the move...
	property INT iAllowColumnMoving alias "$AllowColumnMoving"

	// Determines if columns can be shrunk to their minimum width by the user clicking the right mouse button on the header...
	property BOOLEAN bAllowColumnShrinking alias "$AllowColumnShrinking"

	// Determines if columns in the grid can be resized by the user or are fixed in width...
	property BOOLEAN bAllowColumnSizing alias "$AllowColumnSizing"

	// Determines if the position of two columns can be swapped by the user, and if so, the scope of the swap...
	property INT iAllowColumnSwapping alias "$AllowColumnSwapping"

	// Determines if rows in the grid can be deleted by the user...
	property BOOLEAN xbAllowDelete alias "$AllowDelete"

	// Determines if drag and drop of cell data can be used...
	property BOOLEAN bAllowDragDrop alias "$AllowDragDrop"

	// Determines if groups can be moved by the user...
	property BOOLEAN bAllowGroupMoving alias "$AllowGroupMoving"

	// Determines if groups can be shrunk to their minimum width by the user clicking the right mouse button on the header...
	property BOOLEAN bAllowGroupShrinking alias "$AllowGroupShrinking"

	// Determines if groups in the grid can be resized by the user or are fixed-in width...
	property BOOLEAN bAllowGroupSizing alias "$AllowGroupSizing"

	// Determines if the position of two groups can be swapped by the user...
	property BOOLEAN bAllowGroupSwapping alias "$AllowGroupSwapping"

	// Determines if row heights in the grid can be resized by the user...
	property BOOLEAN xbAllowRowSizing alias "$AllowRowSizing"

	// Determines if grid data can be modified by the user...
	property BOOLEAN xbAllowUpdate alias "$AllowUpdate"

	// For SSDBOptSet, determines the background color for all buttons within the control...
	property UNSIGNED INT xiBackColor alias "$BackColor"

	// Determines the row’s background color for even-numbered rows...
	property UNSIGNED INT iBackColorEven alias "$BackColorEven"

	// Determines the row’s background color for odd-numbered rows...
	property UNSIGNED INT iBackColorOdd alias "$BackColorOdd"

	// Determines whether balloon help will be displayed...
	property BOOLEAN bBalloonHelp alias "$BalloonHelp"

	// Determines the colors used to draw respective parts of the control...
	property UNSIGNED INT iBevelColorFace alias "$BevelColorFace"

	// Determines the colors used to draw respective parts of the control...
	property UNSIGNED INT iBevelColorFrame alias "$BevelColorFrame"

	// Determines the colors used to draw respective parts of the control...
	property UNSIGNED INT iBevelColorHighlight alias "$BevelColorHighlight"

	// Determines the color scheme for the parts of the control...
	property INT iBevelColorScheme alias "$BevelColorScheme"

	// Determines the colors used to draw respective parts of the control...
	property UNSIGNED INT iBevelColorShadow alias "$BevelColorShadow"

	// STANDARD PROPERTY
	property ANYTYPE aBookmark alias "$Bookmark"

	// Sets or returns the border style of the control...
	property INT xiBorderStyle alias "$BorderStyle"

	// HOST ENV
	property STRING xsCaption alias "$Caption"

	// For the SSDBData and SSDBOptSet controls, determines how the caption will be aligned on each button. For all others, determines how the caption will be aligned on the object/control.
	property INT iCaptionAlignment alias "$CaptionAlignment"

	// Determines how the grid responds to the arrow keys being used when first entering the cell...
	property INT iCellNavigation alias "$CellNavigation"

	// Determines whether check boxes on the grid should be displayed with 3D appearance...
	property BOOLEAN bCheckBox3D alias "$CheckBox3D"

	// Sets or returns the current column...
	property SHORT xiCol alias "$Col"

	// Sets or returns the number of columns in the control...
	property SHORT iCols alias "$Cols"

	// Determines whether column headers will be displayed...
	property BOOLEAN xbColumnHeaders alias "$ColumnHeaders"

    // The columns collection represents a group of column objects that comprise a grid...
	property PINTERFACE Columns alias "$Columns"

	// Sets or returns the combo box’s dropdown state...
	property BOOLEAN bComboDroppedDown alias "$ComboDroppedDown"

	// 
	property BOOLEAN xbDataChanged alias "$DataChanged"

	// Sets/Returns the mode used by control for data access...
	property INT xiDataMode alias "$DataMode"
	
	//
	property PINTERFACE DataSource alias "$DataSource"
	
	
	property FLOAT xrDefColWidth alias "$DefColWidth"
	property INT iDividerStyle alias "$DividerStyle"
	property INT iDividerType alias "$DividerType"
	property BOOLEAN bDroppedDown alias "$DroppedDown"
	property BOOLEAN xbEnabled alias "$Enabled"
	property STRING sFieldDelimiter alias "$FieldDelimiter"
	property STRING sFieldSeparator alias "$FieldSeparator"

	// Sets or returns the bookmark for the first visible row...
	property ANYTYPE aFirstRow alias "$FirstRow"

	property PINTERFACE Font alias "$Font"
	
	
	property INT iFont3D alias "$Font3D"
	property UNSIGNED INT xiForeColor alias "$ForeColor"
	property UNSIGNED INT iForeColorEven alias "$ForeColorEven"
	property UNSIGNED INT iForeColorOdd alias "$ForeColorOdd"
	property BOOLEAN bGroupHeaders alias "$GroupHeaders"
	property SHORT iGroupHeadLines alias "$GroupHeadLines"
	
	
	property PINTERFACE Groups alias "$Groups"
	
	// Sets or returns the current group...
	property SHORT iGrp alias "$Grp"

	property PINTERFACE HeadFont alias "$HeadFont"
	
	
	property INT iHeadFont3D alias "$HeadFont3D"
	property SHORT iHeadLines alias "$HeadLines"
	property STRING sHeadStyleSet alias "$HeadStyleSet"
	property INT xihWnd alias "$hWnd"
	property INT iHwndEdit alias "$HwndEdit"
	property SHORT xiLeftCol alias "$LeftCol"
	property SHORT iLeftGrp alias "$LeftGrp"
	
	// Sets or returns the number of levels in a multi-level grid...
	property SHORT iLevelCount alias "$LevelCount"

	property INT iMaxSelectedRows alias "$MaxSelectedRows"
	property BOOLEAN bMultiLine alias "$MultiLine"
	
	
	property PINTERFACE PageFooterFont alias "$PageFooterFont"
	property PINTERFACE PageHeaderFont alias "$PageHeaderFont"
	property PINTERFACE PictureButton alias "$PictureButton"
	property PINTERFACE PictureComboButton alias "$PictureComboButton"
	property PINTERFACE PictureRecordSelectors alias "$PictureRecordSelectors"
	
	property BOOLEAN xbRecordSelectors alias "$RecordSelectors"
	property BOOLEAN bRedraw alias "$Redraw"
	property FLOAT rResizeHeight alias "$ResizeHeight"
	property FLOAT rResizeWidth alias "$ResizeWidth"

	// Sets or returns the current display row...
	property SHORT xiRow alias "$Row"

	property BOOLEAN bRowChanged alias "$RowChanged"
	property FLOAT xrRowHeight alias "$RowHeight"
	property INT iRowNavigation alias "$RowNavigation"

	// Sets or returns the number of rows in the grid...
	property INT iRows alias "$Rows"

	property INT iRowSelectionStyle alias "$RowSelectionStyle"
	property INT xiScrollBars alias "$ScrollBars"
	
	property PINTERFACE SelBookmarks alias "$SelBookmarks"
	
	property BOOLEAN bSelectByCell alias "$SelectByCell"
	property INT iSelectTypeCol alias "$SelectTypeCol"
	property INT iSelectTypeRow alias "$SelectTypeRow"
	property SHORT iSplitterPos alias "$SplitterPos"
	property BOOLEAN bSplitterVisible alias "$SplitterVisible"
	property STRING sStyleSet alias "$StyleSet"
	property PINTERFACE StyleSets alias "$StyleSets"
	property INT iTabNavigation alias "$TabNavigation"
	property ANYTYPE aTagVariant alias "$TagVariant"
	property BOOLEAN bUseDefaults alias "$UseDefaults"
	property BOOLEAN bUseExactRowCount alias "$UseExactRowCount"
	
	property PINTERFACE VBContainer alias "$VBContainer"
	
	property FLOAT xrVBHeight alias "$VBHeight"
	property INT xiVBhWnd alias "$VBhWnd"
	property FLOAT xrVBLeft alias "$VBLeft"
	property STRING xsVBName alias "$VBName"
	property PINTERFACE VBParent alias "$VBParent"
	property SHORT xiVBTabIndex alias "$VBTabIndex"
	property BOOLEAN xbVBTabStop alias "$VBTabStop"
	property STRING xsVBTag alias "$VBTag"
	property FLOAT xrVBTop alias "$VBTop"
	property BOOLEAN xbVBVisible alias "$VBVisible"
	property FLOAT xrVBWidth alias "$VBWidth"

	// Returns the number of visible columns in the grid...
	property SHORT xiVisibleCols alias "$VisibleCols"

	// Returns the number of visible groups in the grid...
	property SHORT iVisibleGrps alias "$VisibleGrps"

	// Returns the number of visible rows in the grid...
	property SHORT xiVisibleRows alias "$VisibleRows"

	// ------------------------------------------
	// NATIVE METHODS
	// ------------------------------------------

	obj ANYTYPE x_GetBookmark (INT RowNum) alias "_GetBookmark";
	obj VOID xAboutBox () alias "AboutBox";
	
	// Returns the active cell object...
	obj PINTERFACE ActiveCell ();

	// Adds a string to an AddItem grid...
	obj VOID AddItem (STRING Item, ANYTYPE Index);

	// Returns the AddItem bookmark for a given absolute row number...
	obj ANYTYPE AddItemBookmark (INT RowIndex);

	// Returns the AddItem row number for a given bookmark...
	obj INT AddItemRowIndex (ANYTYPE Bookmark);

	// HOST ENVIRONMENT
	obj VOID AddNew ();

	// HOST ENVIRONMENT
	obj VOID CancelUpdate ();
	
	// Returns the index of the column under an x-coordinate...
	obj SHORT xColContaining (FLOAT X, ANYTYPE Y) alias "ColContaining";

	// Returns the index of the column relative to the collection...
	obj SHORT ColPosition (SHORT ColPos);
	
	// Deletes all selected rows...
	obj STRING DeleteSelected ();
	
	// Fires the Click event...
	obj VOID DoClick ();
	
	// Exports the contents of the grid to a file...
	obj VOID Export (INT Type, INT Flags, STRING ExportToFile, ANYTYPE HTMLTemplate, ANYTYPE OutputFileField);
	
	// Returns the group number located at the specified x-coordinate...
	obj SHORT GrpContaining (FLOAT X);
	
	// Returns the index of the group relative to the collection...
	obj SHORT GrpPosition (SHORT GrpPos);
	
	// Returns whether the current row is the add row at the bottom of the grid...
	obj BOOLEAN IsAddRow ();
	
	// Returns whether the current text in the edit portion of the combo or cell of the grid is in the dropdown list...
	obj BOOLEAN IsItemInList ();
	
	// Loads a previously saved layout, adding to or replacing the current grid layout...
	obj VOID LoadLayout (STRING FileName);

	// Moves to the first record in the grid...
	obj VOID MoveFirst ();

	// Moves to the last record in the grid...
	obj VOID MoveLast ();

	// Moves to the next record in the grid...
	obj VOID MoveNext ();

	// Moves to the previous record in the grid...
	obj VOID MovePrevious ();

	// Moves a specified number of records in the grid...
	obj VOID MoveRecords (INT Records);

	// Prints the data from the grid using the current property settings of the ssPrintInfo object...
	obj VOID PrintData (INT Flags, BOOLEAN ShowSetupDialog, BOOLEAN ShowPrintDialog, ANYTYPE Reserved);

	// (BOUND) Rebinds the grid to the database. (UNBOUND) Refreshes the unbound grid by setting rowcount to 0 and rereading data from the top.
	obj VOID xReBind () alias "ReBind";

	// HOST ENVIRONMENT
	obj VOID xRefresh () alias "Refresh";

	// Removes all rows from an AddItem grid...
	obj VOID RemoveAll ();

	// Removes a string at the specified row from an AddItem grid...
	obj VOID RemoveItem (INT Index);

	// Destroys the associated layout for a control...
	obj VOID Reset ();

	// Returns a bookmark of a row in the grid’s display area...
	obj ANYTYPE xRowBookmark (INT RowNum) alias "RowBookmark";

	// Returns the index of the row under a y-coordinate...
	obj SHORT xRowContaining (FLOAT Y) alias "RowContaining";

	// Returns the y-coordinate of the top of a row...
	obj FLOAT xRowTop (SHORT RowNum) alias "RowTop";

	// Saves the indicated portion of the control's layout to the specified file...
	obj VOID SaveLayout (STRING FileName, INT Flags);

	// Causes the grid to be scrolled...
	obj VOID xScroll (SHORT Cols, INT Rows) alias "Scroll";

	// Updates any modified information in the grid. This method is applicable to all data modes...
	obj VOID Update ();

	// Returns the current area of the control to which the cursor is pointing.  Returns values for nothing, button areas, and caption area...
	obj INT WhereIs (FLOAT X, FLOAT Y);
}

---

Post Extras