Defines the properties for an edititable field whose layout is defined by the user. EditField's are linked to
a DbNetEdit control via the DbNetEditIDDbNetEditID property
Declaration Syntax| C# | Visual Basic |
public class EditField : Control, INamingContainer
Public Class EditField _ Inherits Control _ Implements INamingContainer
Members| All Members | Constructors | Properties | |||
| Icon | Member | Description |
|---|---|---|
 | EditField()()() |
EditField constructor
|
| EditField(DbNetEdit, EditColumn) |
EditField constructor
|
 | AutoIncrement |
Indicates if the Primary key is automatically generated.
|
| ColumnExpression |
The name of the database column to be edited
|
| DbNetEditID |
ID of the DbNetEdit control
|
| EditControlType |
The type of control created to edit the database value. Defaults to Auto which will base the control type on the
database column
|
| ForeignKey |
When linked to a child DbNetEdit control this is the column which is matched against the PrimaryKey column in the parent control
|
| Format |
Standard .Net format masks for numeric and date-time columns
|
| Height |
Height of the control (not applicable to some control types)
|
| InsertReadOnly |
The field is read-only when the edit control is adding a new record
|
| IsBoolean |
The field is read-only when the edit control is adding a new record
|
| Lookup |
Specifies how a selection list is populated. Defined either as an SQL statement or JSON JavaScript array notation
|
| LookupSearchMode |
Specifies if search is applied to the lookup value or text
|
| MaxThumbnailHeight |
Specifies the maximum heigt of an uploaded image thumbnail
|
| PrimaryKey |
Specifies the column that should be used as the primary key. Certain primary key fields are identified automatically.
|
| ReadOnly |
Field is readonly during inserts and updates
|
| Required |
A value is required in this field
|
| Search |
The field can be searched against
|
| Style |
CSS setting for the input control
|
| UpdateReadOnly |
Field will be read-only when in update mode
|
| UploadExtFilter |
Comma seperated list of allowable file extentions that can be uploaded
|
| UploadMaxFileSize |
Maximum size in KB of an uploaded file
|
| UploadOverwrite |
Is the user allowed to upload and overwrite an existing file on the server
|
| UploadRename |
Can the user rename the file as a part of the upload process.
|
| UploadRootFolder |
The name of the folder into which uploaded files will be placed
|
| UploadSubFolder |
The name of the sub-folder into which uploaded files will be placed. The sub-folder name is stored with the file name in the database.
|
| Width |
Width of the control. Not applicable to all control types.
|
Examples
CopyC#<DNL:DbNetEdit
ID="DbNetEdit1"
runat="server"
ConnectionString="SamplesDatabase"
FromPart="Products">
</DNL:DbNetEdit>
<table>
<tr>
<td><p>Discontinued</p></td>
<td><DNL:EditField runat="server" ColumnExpression="Discontinued" DbNetEditID="DbNetEdit1" EditControlType="CheckBox" /></td>
</tr>
<tr>
<td><p>Product ID</p></td>
<td><DNL:EditField runat="server" ColumnExpression="ProductID" DbNetEditID="DbNetEdit1" /></td>
</tr>
<tr>
<td><p>Product Name</p></td>
<td><DNL:EditField runat="server" ColumnExpression="ProductName" DbNetEditID="DbNetEdit1" /></td>
</tr>
<tr>
<td><p>Supplier</p></td>
<td><DNL:EditField runat="server" ColumnExpression="SupplierID" DbNetEditID="DbNetEdit1" Lookup="SELECT SupplierID, CompanyName from Suppliers" /></td>
</tr>
</table>