Primary Key of the table

Important Note:

1. You should never change this field unless you are absolutely sure that this field is unique. Otherwise a particular record cannot be located and unexpected results may occur.
   
2. From v2.0, composite key is supported, and primary key is uneditable in the edit page.

Page number of the field.

From v3.0+, multi-page Add/Edit is supported. By default all the fields are in page 1 and multi-page is disabled. If you set any page to larger than 1, multi-page feature will be enabled automatically.

Include this field when performing quick search.
Note: Only text fields and numeric fields are supported in Quick Search. By default only text fields are enabled.

Use this field in Extended Quick Search (ASP.NET Maker 3+)

Extended Quick Search is enhancement of Quick Search. It is sort of a combination of Quick Search and Advanced Search. If a field is checked for Ext. Search, a form element for the field will be shown in the Quick(Basic) Search form and the user input criteria for this field will be included when performing Quick(Basic) Search.

Extended Quick Search will use the same search operators specified under the "Advanced Search Page" section (see below).

Truncate the field value at specified max. length and append "..." to the end.

Note: This setting only applied to memo fields in list page and must be larger than 0 to take effect.

- None (no prefix, relative path of url)
- http:// (prefix http:// added, absolute path of url)
- mailto: (prefix mailto: added, email link)
- ftp:// (prefix ftp:// added, ftp link)
- file:// (prefix file:// added, file link)
- news:// (prefix news:// added, newsgroup link)

<input type="text"> tag

Display the field as a textbox.

Size - size of the textbox

MaxLength - maximum input length of the textbox

Validation - see section below

Use Lookup Table - enable auto suggest feature by Ajax. With a lookup table, when the user type in the textbox, a dynamic dropdown list populated with data from the lookup table matching the user input will appear for user to select. If the data already exists, the user can easily select without typing the full text. If not, the user can still input as usual. To enable this feature, check this option and enter the lookup table info in the [Lookup Table] panel next to the [Edit Tag] panel. (See section below)

<input type="password"> tag

Display the field as a masked textbox.

Size - size of the textbox

MaxLength - maximum input length of the textbox

Validation - see section below

<input type="radio"> tag

Display the field as an option of a radio button list. You can enter the options manually in the [User Value] panel next to the [Edit Tag] panel.

Use lookup table - use an existing lookup table instead of user input value/label pairs for the radio buttons. To enable this feature, check this option and enter the lookup table info in the [Lookup Table] panel next to the [Edit Tag] panel. (See section below)

Repeat columns - specifies the no. of radio buttons per row

Validation - see section below

<input type="checkbox"> tag

Display the field as one or more option(s) of a checkbox list. You can enter the options manually in the [User Value] panel next to the [Edit Tag] panel.

Use lookup table - use an existing lookup table instead of user input value/label pairs for the checkboxes. To enable this feature, check this option and enter the lookup table info in the [Lookup Table] panel next to the [Edit Tag] panel. (See section below)

Repeat columns - specifies the no. of checkboxes per row

Validation - see section below

Note: The submitted values of the multi-selected checkboxes is a comma-separated string. Therefore you must use a string field for checkbox list.

<select> tag

Display the field as a combobox (dropdown list) or a listbox. You can enter the options manually in the [User Value] panel next to the [Edit Tag] panel.

Size - no. of options to show. If more that 1, the selection list is shown as a listbox, otherwise it is shown as a combobox.

Multiple: Check to enable multiple selection (for listbox only)

Note: The submitted values of the multi-selected listbox is a comma-separated string. Therefore you must use a string field for checkbox list.

Use lookup table - use an existing lookup table instead of user input value/label pairs for the checkboxes. To enable this feature, check this option and enter the lookup table info in the [Lookup Table] panel next to the [Edit Tag] panel. (See section below)

Validation - see section below

<textarea> tag

Display the field as a textarea.

Cols - no. of columns of the textarea.

Rows - no. of rows of the textarea.

Use DHTML Editor - replace the textarea with a DHTML editor for editing the data as HTML.

Note: The DHTML Editor(s) requires newer version of browsers such as IE6+, NS7+ or FF1+. It is not developed by the author of ASP.NET Maker and no technical support will be provided. (See Third-party Tools.)

Validation - see section below

<input type="file"> tag

Display the field as a file upload control. For BLOB fields or string fields only.

Size - size of the input tag (NOT file size)

If the field is of BLOB (binary) data type, file is uploaded to the database. You can also store the information of the uploaded file in the following fields:

File type field - Recommended. Useful when you want to response to user browser the exact content type of the data.

File name field - Optional. Useful if you want to use the original filename.

Note: Do not specify file name field if you want IE to open the file automatically. (IE may fail to open non-image files retrieved from database properly.) Use file name field if you want IE to popup a File Download dialog for user to save the file with the filename specified in the file name field.

File size field - Optional. Stores the uploaded file size.

Image width field - Optional. For use with images only. Stores the width of the uploaded image.

Image height field - Optional. For use with images only. Stores the height of the uploaded image.

If the field of string type, file is uploaded to a subfolder relative to the application root.

Upload folder - the folder where the uploaded file will reside. If you do not enter a specific folder, all the uploaded files will be put in the global upload folder specified in the ASP.NET tab (see ASP.NET Setup).

Notes:

1. Make sure that the Web server user have read/write access to the folder. You can right-click the folder in Windows Explorer and add read/write access for IUSR_<MachineName> on the Security tab.
   
   
2. The path is relative to application root. Use slashes "/" as path delimiter, no leading slash. e.g. If the application root of your website is C:\Inetpub\wwwroot\demo and you enter "uploads/folder1" in this textbox, the folder for the uploaded files will be C:\Inetpub\wwwroot\demo\uploads\folder1. If you are not sure which folder is application root, please read Creating Virtual Directories in IIS.
   

Validation - see section below

<input type="hidden"> tag

Hide the field with a hidden form element.

Note: This is different from de-selecting the field in the [Edit] column. If a field is de-selected, no code will be generated for the field in the Edit page and the field will not be updated. With a hidden form element the field is not seen but it may still get updated.

Custom value - by default the 'value' attribute contains the field value, custom value is used to update the field with an other value, for example, Date(), when a record is updated using the edit page.

Notes:

1. Custom value is used in Edit page only. It cannot be used with Read-only fields, User ID fields and Detail fields(Foreign key fields)
   
   
2. In Add page, if a default value is specified (see section below), hidden form element will also be used but the 'value' attribute will contain the default value. If default value is not specified, the field will be displayed as a normal textbox.

Optional. For used with the Dynamic Selection List feature. Available for <select> tag only. Specify the parent combobox of this combobox. When the parent combobox changes, the available options in this combobox will be changed accordingly.

Note: Dynamic Selection List does not support multiple selection.

Optional. For used with the Dynamic Selection List feature. Available for <select> tag only. If this <select> tag is setup as the Second Combobox (see below), the options in this <select> tag will be changed with the selected option of the first combobox. It is done by filtering the linked table records by this field. Only records with a Filter Field value matching the selected value of the first combobox will be shown.

Note: Dynamic Selection List does not support multiple selection.

Optional. If enabled, the user will be allowed to add an option to the selection list.

Notes:

1. Review your lookup table design before using this option. The option works best if you there is only one display field and the link field (primary key) is an autoincrement field. In that case the user only need to fill in a textbox and the option is added. But if the link field (primary key) is not an auto-increment field, the user will need to enter the link field value which the user may not know.
   
   
2. The user will be asked to enter the link field and the display field(s) only. If the lookup table has other NOT NULL fields other than the link field and display field(s), the new option cannot be added. However, you can define default values for these fields in the database (not in ASP.NET Maker).
   
   
3. Currently this feature is supported in Add/Edit page only, it is not available in Inline-Edit.
   
   
4. This feature is implemented using Ajax, IE6+/NS7+/FF1+ is required.

Supported data type are:
Integer, Float, Range, Date(yyyy/mm/dd), Date(mm/dd/yyyy), Date(dd/mm/yyyy), Time(hh:mm:ss), Email, Credit card, GUID, US phone numner, US zip code, US social security number

Note: Other than "/", the date separator of the validation format can also be "-" or ".", depending on the default date format setting in ASP.NET Settings page.

If Validate is one of the date formats, check this option to use a visual date picker instead of manual input.

Note: The popup calendar is not developed by the author of ASP.NET Maker and no technical support will be provided. (See Third-party Tools.)

Specify whether to check duplicated values for the field.

If the field is an unique indexed field, ASP.NET Maker will generate server side codes to check duplicate values automatically even this option is not selected. This option is useful when you want to check a non unique indexed fields for duplicated values in the Add page.

Notes: The validation is done on server side in Add page only.

Search operator #2 for the field. Used in Advanced Search or Extended Quick Search.

Notes:

1. This second search operators will be useful when you may have 2 criteria for the field when searching. You can also select AND/OR to relate the 2 criteria.
2. ASP.NET Maker (3+) supports "BETWEEN" search operator. If you want to use it, select "BETWEEN" in the first search operator. When "BETWEEN" is used, the 2 search criteria will be used up and the second search operator will be ignored.