False by default. If set to True enables sorting on this column by showing sort buttons on both sides of the caption in the header.

Usage:

VBScript	Grid("name").CanSort = True
XML	<Cols Index="name">  <CanSort>True</CanSort> </Cols>
Relevant Chapters	4 and all others.

Specifies the column caption shown in the header. If this property is not specified, the database field name will be used by default.

Usage:

VBScript	Grid("hiredate").Caption = "Hire Date"
XML	<Cols Index="hiredate">  <Caption>Hire Date</Caption> </Cols>
Relevant Chapters	4 and all others.

Specifies a default value for the column. This value will be used to initialize this column's edit control when a new record is being added. If a column is hidden or read-only, the default value will be saved to the database when a new record is added. The default value will also be used when a column is not hidden or read-only, but left blank during editing.

DefaultValue is a Variant, so it can be set to a value of any readable data type including String, Integer, Float, Date, etc. When set with XML, the possible values for the Type attribute are "boolean", "float", "int", "string" and "date".

Usage:

VBScript	Grid("dept_id").DefaultValue = 50
XML	<Cols Index="dept_id">  <DefaultValue Type="int">50</DefaultValue> </Cols>
Relevant Chapters	4, 7

Overrides the default database field name for certain operations such as sorting and inserts. May be useful if your SQL SELECT statement does not explicitly reference a field name, e.g. "select id, a + b from table".

Usage:

VBScript	Grid(3).FieldName = "somename"
XML	<Cols Index="3">  <FieldName>somename</FieldName> </Cols>
Relevant Chapters	N/A

False by default. If set to True makes this column hidden.

You should always hide the identity column of your grid, or at least make it read-only.

Usage:

VBScript	Grid("id").Hidden = True
XML	<Cols Index="id">  <Hidden>True</Hidden> </Cols>
Relevant Chapters	2 and all others.

Returns this column's index.

Usage:

VBScript	Response.Write Grid.Cols("name").Index
XML	N/A
Relevant Chapters	N/A

Specifies the MAXLENGTH attribute for <INPUT TYPE=TEXT> items displayed by a column in the edit mode.

Usage:

VBScript	Grid("state").InputMaxLength = 2
XML	<Cols Index="state">  <InputMaxLength>2</InputMaxLength> </Cols>
Relevant Chapters	N/A

Specifies the SIZE attribute for <INPUT TYPE=TEXT> items displayed by a column in the edit mode.

Usage:

VBScript	Grid("ssn").InputSize = 12
XML	<Cols Index="ssn">  <InputSize>12</InputSize> </Cols>
Relevant Chapters	3 and all others.

Specifies one or more additional attributes for an <INPUT TYPE=TEXT> (or any other edit control) displayed by a column in the edit mode.

Usage:

VBScript	Grid("code").InputUserAttributes = "VALUE=2"
XML	<Cols Index="code">  <InputUserAttributes>VALUE=2 </InputUserAttributes> </Cols>
Relevant Chapters	N/A

False by default. If set to True makes this column read-only which means the column will not switch to the edit mode when the rest of the row does.

Usage:

VBScript	Grid("id").ReadOnly = True
XML	<Cols Index="id">  <ReadOnly>True</ReadOnly> </Cols>
Relevant Chapters	2 and all others.

In the edit mode, displays a "calendar" icon next to a text box. When this icon is clicked, a JavaScript-based pop-up calendar will come up allowing a user to pick a date.

By default, the calendar opens up displaying the current month and year. You can specify a different month and/or year via the arguments Month (0-11 for Jan-Dec) and Year (a 4-digit value), respectively. The default date format returned by the calendar is "MM/DD/YYYY". You may specify a different format via Format, for example, "DD/MM/YY"

For a pop-up calendar to function, you must include the file calendar.js (shipped with the AspGrid component) in your ASP file's header as follows:

<script language="JavaScript" src="calendar.js"></script>

Usage:

VBScript	Grid.Cols("hiredate").AttachCalendar , , "DD/MM/YY"
XML	<Cols Index="hiredate">  <AttachCalendar Format="DD/MM/YY"/> </Cols>
Relevant Chapters	4

Turns a column into a checkbox in the edit mode. All non-zero values are displayed as checked boxes, all zero values as clear boxes. Apply this method to Boolean and numeric fields only.

DisplayChecked and DisplayUnchecked specify what should be displayed for non-zero and zero values, respectively, while in the regular display mode. You can simply specify words such as "Yes" and "No", or HTML tags such as "<IMG SRC=yesimage.gif>" and "<IMG SRC=noimage.gif>".

Usage:

VBScript	Grid.Cols("vested").AttachCheckbox "Yes", "No"
XML	<Cols Index="vested">  <AttachCheckBox Checked="Yes" Unchecked="No"/> </Cols>
Relevant Chapters	4 and all others.

This method is useful for turning a column into a hyperlink or image in the regular display mode. Expression is a string that may contain one or more references to field names. A field name must be surrounded by either two pairs of braces, e.g. {{dept_id}}, or two pairs of square brackets, e.g. [[name]].

A field name in double braces will be replaced by its respective value for this record. A field name in double square brackets will be replaced by its value in a URL-encoded form.

For example, if a table record contains the values id=3 and name="R & D", the statement

Grid("name").AttachExpression _
  "<A HREF=script.asp?name=[[name]]&id={{id}}>{{name}}</A>"

will produce the value

<A HREF=script.asp?name=R+%26+D&id=3>R & D</A>

Note that setting a string above via XML requires that you replace the < symbol with its HTML encoding &lt; or a syntax error would be generated by the XML parser.

Usage:

VBScript	Grid("name").AttachExpression "<A HREF=form.asp?id={{id}}>{{name}}</A>"
XML	<Cols name="vested">  <AttachExpression Expression="&lt;A HREF=form.asp?id={{id}}>{{name}}&lt;/A>"/> </Cols>
Relevant Chapters	7, 10

Turns a column into a <TEXTAREA> in the edit mode. Rows and Cols, if specified, set the ROWS and COLS attributes, respectively.

Usage:

VBScript	Grid.Cols(5).AttachTextarea 20, 5
XML	<Cols Index="5">  <AttachTextarea Rows="20" Cols="5"/> </Cols>
Relevant Chapters	N/A

Specifies date formatting for a column. You must only apply this method to date fields. Format specifies the formatting string for dates in the regular display mode. EditFormat, if specified, affects dates in the edit mode. If it is omitted, a default database date format will be used in the edit mode.

A formatting string contains one or more codes that represent various components of a date/time. The formatting codes are listed below (copied from MSDN):

Code	Description
%a	Abbreviated weekday name
%A	Full weekday name
%b	Abbreviated month name
%B	Full month name
%c	Date and time representation appropriate for locale
%d	Day of month as decimal number (01 - 31)
%H	Hour in 24-hour format (00 - 23)
%I	Hour in 12-hour format (01 - 12)
%j	Day of year as decimal number (001 - 366)
%m	Month as decimal number (01 - 12)
%M	Minute as decimal number (00 - 59)
%p	Current locale’s A.M./P.M. indicator for 12-hour clock
%S	Second as decimal number (00 - 59)
%U	Week of year as decimal number, with Sunday as first day of week (00 - 53)
%w	Weekday as decimal number (0 - 6; Sunday is 0)
%W	Week of year as decimal number, with Monday as first day of week (00 - 53)
%x	Date representation for current locale
%X	Time representation for current locale
%y	Year without century, as decimal number (00 - 99)
%Y	Year with century, as decimal number
%z	Time-zone name or abbreviation; no characters if time zone is unknown
%%	Percent sign

For example, the formatting string "%b %d, %Y" formats the date 05/18/70 into May 18, 1970.

Usage:

VBScript	Grid.Cols("hiredate").FormatDate "%b %d, %Y"
XML	<Cols Index="hiredate">  <FormatDate Format="%b %d, %Y"/> </Cols>
Relevant Chapters	4

Specifies numeric formatting for a column.

Decimal specifies the number of decimal positions for a number.
ThouComma is optional and True by default. If set to False, suppresses comma separators between 000's.
NegativeSign is optional and True by default. If set to False, suppresses the "-" sign for negative numbers and uses the parenthesized (...) form instead.
FloatingPoint is optional and True by default. If set to False, uses the European format (floating commas and "dot" separators), e.g. 1.234.567,89.
Prefix is optional and empty by default. Specifies a string prefix that will be automatically inserted in front of each number in the column.

Usage:

VBScript	Grid("salary).FormatNumeric 2, , , , "$"
XML	<Cols Index="salary">  <FormatNumeric Decimal="2" Prefix="$"/> </Cols>
Relevant Chapters	4