The grid control is a spreadsheet-like object. The Address Book application uses it to display data returned from queries.
The following HTML code defines the grid control. Copy and paste this code just following the comment tag that refers to it.
<OBJECT CLASSID="clsid:AC05DC80-7DF1-11d0-839E-00A024A94B3A"
CODEBASE="http://<%=Request.ServerVariables("SERVER_NAME")%>/MSADC/Samples/ssdatb32.cab"
ID=GRID1
DATASRC=#SControl
HEIGHT=125
WIDTH=495>
<PARAM NAME="AllowAddNew" VALUE="TRUE">
<PARAM NAME="AllowDelete" VALUE="TRUE">
<PARAM NAME="AllowUpdate" VALUE="TRUE">
<PARAM NAME="BackColor" VALUE="-2147483643">
<PARAM NAME="BackColorOdd" VALUE="-2147483643">
<PARAM NAME="ForeColorEven" VALUE="0">
</OBJECT>
<HR>
The OBJECT tag defines the grid control component to the program. The tag includes parameters that allow you to set the size of the grid, change the data displayed when information is updated or deleted, and dynamically change the number of rows according to the results of a query. The other parameters set the color properties of the grid control.
The following table describes the parameters associated with the OBJECT tag.
| Parameter | Description |
| CLASSID | A unique, 128-bit number that identifies the type of embedded object to the system. This identifier is maintained in the local computer's Windows registry. It is specific to this Sheridan grid control. |
| CODEBASE | Specifies the location of a source file of the object being called, if it is not on the client computer.
In this case, CODEBASE specifies the location of a .cab file containing the Sheridan ActiveX® controls. The program uses Active Server Pages script (the code enclosed by the |
| ID | Defines a document-wide identifier for the embedded object. |
| DATASRC | Identifies the data source that is used to bind the data grid to back-end data (in this case, SControl, which is an RDS.DataControl object). |
| WIDTH and HEIGHT | Identifies the dimensions of the control in pixels. |
For the Address Book application, the grid object uses several additional parameters to enable editing. Without these specifiers, the grid can only present a read-only, static view of the editable data. The following table lists editing parameter settings for the grid control in this sample application.
| Parameter | Value | Description |
| AllowAddNew | TRUE | Allows an existing data display to add new records. |
| AllowDelete | TRUE | Allows an existing data display to remove records. |
| AllowUpdate | TRUE | Allows changes to a cell in the grid. |
The BackColor, BackColorEven, and BackColorOdd parameters set the grid to a white background with black text.