Example
Source
Run as client-side object
You can use
DbNetSpell
to check the spelling of input fields within a
DbNetEdit
form. Click on the
icon adjacent to the
Notes
field or use the
Spell
button within the text editor dialog.
Customers
EmployeeId
Supervisor Name
First Name
Date/Time of Birth
Last Name
Date Hired
Title
Notes
Register the component libraries
<%@ Register TagPrefix="Edit" Namespace="DbNetLink.Web.UI" Assembly="DbNetLink.DbNetEdit" %>
Server Control
<form id="Form1" name="Form1" method="post" runat="server"> <table> <tr> <td valign=top> <fieldset> <legend>Customers</legend> <Edit:DbNetEdit id="dbnetedit1" Runat="server" ConnectionString = "samples" TableName = "employees" PrimaryKeyName = "employeeid" PrimaryKeyAutoincrement = "true" SearchFields = "employeeid,firstname, lastname, reportsto, birthdate, hiredate" SearchLabels = "Id, First Name, Last Name, Reports To, Date Of Birth, Date Hired" SortFields = "employeeid,firstname, lastname, reportsto, birthdate" SortLabels = "Id, First Name, Last Name, Reports To, Date Of Birth" DbNetSpellVirtualDir = "/dbnetspell/" > <EditFieldProperties> <Edit:FieldProperty ColumnName="lastname" Property="required" Value="true"></Edit:FieldProperty> <Edit:FieldProperty ColumnName="firstname" Property="required" Value="true"></Edit:FieldProperty> <Edit:FieldProperty ColumnName="birthdate" Property="format" Value="G"></Edit:FieldProperty> <Edit:FieldProperty ColumnName="notes" Property="spell" Value=""></Edit:FieldProperty> <Edit:FieldProperty ColumnName="reportsto" Property="lookup" Value="select employeeid, lastname + ', ' + firstname from employees order by lastname"></Edit:FieldProperty> <Edit:FieldProperty ColumnName="title" Property="editLookup" Value="select distinct title, title from employees"></Edit:FieldProperty> </EditFieldProperties> <SearchFieldProperties> <Edit:FieldProperty ColumnName="reportsto" Property="searchLookup" Value="select employeeid, lastname from employees order by lastname"></Edit:FieldProperty> <Edit:FieldProperty ColumnName="birthdate" Property="format" Value="G"></Edit:FieldProperty> </SearchFieldProperties> <FormTemplate> <table> <tr> <td colspan="6"> <table> <tr> <td id="editNavigation"></td> <td colspan="6" id="toolbar"></td> </tr> </table> </td> </tr> <tr> <td>EmployeeId</td> <td><input class="dbnetedit" id="employeeid"></input></td> <td>Supervisor Name</td> <td><select class="dbnetedit" id="reportsto" tabIndex="2"></select></td> </tr> <tr> <td>First Name</td> <td><input class="dbnetedit" id="firstname" TABINDEX="1"></input></td> <td>Date/Time of Birth</td> <td><input class="dbnetedit" id="birthdate" TABINDEX="2"></input></td> </tr> <tr> <td>Last Name</td> <td><input class="dbnetedit" id="lastname" TABINDEX="1"></input></td> <td>Date Hired</td> <td><input class="dbnetedit" id="hiredate" TABINDEX="2"></input></td> </tr> <tr> <td>Title</td> <td><input class="dbnetedit" id="title" TABINDEX="1"></input></td> </tr> <tr> <td colspan="6">Notes</td> </tr> <tr> <td colspan="6"> <TEXTAREA STYLE="width:500px;height:100px" id="notes" class="dbnetedit" TABINDEX="2"></TEXTAREA> </td> </tr> <tr> <td id="navigatorStatus" colspan="6"></td> </tr> <tr> <td colspan="6" id="messageLine"></td> </tr> </table> </FormTemplate> </Edit:DbNetEdit> </fieldset> </td> </tr> </table> </form>