Grid rows are represented with SGRows collection and each row is represented by SGRow object. By manipulating these objects, you can add or remove rows and change row attributes. There are three types of rows: simple rows (sgSimpleRow), group header rows (sgGroupHeader) and group footer rows (sgGroupFooter). Simple row is bound to the data source and it displays data retrieved from the data source. Group header or footer row displays values and calculation results defined in the SGGroup object.

To reference a particular row, you can use row position, row key or row bookmark.

Row position is a current top-to-bottom counted position of a row in a grid. Top-most row has position 0 (zero). Row position can be changed when grid is sorted or when user drags and drops a row in a grid. If a row is hidden, its position is not changed. To access row with its position use row collection's At method.

Row key is a unique number that identifies one row. It is assigned to a row at row creation time and can not be changed. To access row with its key, use Rows(key) syntax.

A bookmark is a variant that uniquely identifies a particular record in a database.

   

The following list explains how to solve some common row tasks.

To add a row	Use the row collection's Add or InsertAt method.
To remove a row	Use the row collection's Remove method to delete one row. Use the Delete method to remove the current row. Set the AllowDelete property to True to allow users to delete the current row with the Del key.
To size a row	Use the row's Height property. Use the AutoSizeRows method to auto size rows. Set the UserResizing property to sgAllowRowResizing or sgAllowRowColResizing to allow users to size a row. In the bound mode, set the AutoResize property to sgAutoResizeRows or sgAutoResizeRowsAndColumns to fit each row with a its contents.
To move a row	Use the row's Position property. Set the UserDragging property to sgAllowRowDrag or sgAllowRowColDrag to allow users to move a row.
To hide a row	Set the row's Hidden property to True. Set the UserHiding property to sgAllowRowHide or sgAllowRowColHide to allow users to hide a row.
To change row appearance	Use the row's Style property. Use the RowStyleConditions collection to add conditional styles to a row.