Example
Source
Run as server control
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.
Employee Maintenance
EmployeeId
Supervisor Name
First Name
Date/Time of Birth
Last Name
Date Hired
Title
Notes
Include the Javascript library file
<script src="<%=ConfigValue( "DbNetEditVirtualDir", false )%>/dbnetedit.js"></script> <script src="<%=ConfigValue( "DbNetSpellVirtualDir", false )%>/dbnetspell.js"></script>
Client-side script
window.onload = initialise var dbnetedit1 ///////////////////////////////////////////////////////////////// function initialise() ///////////////////////////////////////////////////////////////// { dbnetedit1 = new DbNetEdit( "dbnetedit1" ); with (dbnetedit1) { dbNetSpellVirtualDir = '/dbnetspell/' 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"] setFieldProperty("lastname", "required:true") setFieldProperty("firstname", "required:true") setFieldProperty("birthdate", "format:G") setFieldProperty("notes", "spell") setFieldProperty("reportsto", "lookup:select employeeid, lastname + ', ' + firstname from employees order by lastname") setFieldProperty("title", "editLookup:select distinct title, title from employees") setSearchFieldProperty("reportsto", "searchLookup:select employeeid, lastname from employees order by lastname") setSearchFieldProperty("birthdate", "format:G") initialise() } }
HTML
<fieldset> <legend>Employee Maintenance</legend> <table id="dbnetedit1"> <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> </fieldset>