Example
Source
Run as server control
If you want to place your edit form on the same page as
DbNetGrid
rather than using the standard edit dialog window you can use
DbNetEdit
to achieve this.
Account
Company
Contact
Phone
Fax
Address
City
Region
Zip
Country
Include the Javascript library file
<script src="<%=ConfigValue( "DbNetGridVirtualDir", false )%>/common/component.js"></script> <script src="<%=ConfigValue( "DbNetGridVirtualDir", false )%>/dbnetgrid_lite.js"></script> <script src="<%=ConfigValue( "DbNetEditVirtualDir", false )%>/dbnetedit_lite.js"></script>
Client-side script
window.onload = initialise var dbnetedit1, dbnetgrid1 ////////////////////////////////////////////////////////////////////////////////////////////// function initialise() ////////////////////////////////////////////////////////////////////////////////////////////// { dbnetgrid1 = new DbNetGrid( "dbnetgrid1" ) with ( dbnetgrid1 ) { connectionString = "suite" fromPart = "customers" view = true primaryKeyColumn = "customerid" pageSize = 20 selectPart = ["CompanyName", "ContactName"] headings = ["Company", "Contact"] config=false help = false print = false view = false columnPicker = false save = false sort = false deleteRow = false copy = false updateRow = false loadData() } dbnetedit1 = new DbNetEdit( "dbnetedit1" ); with (dbnetedit1) { connectionString = "suite" setFieldProperty("country", "lookup:select distinct country, country from customers") registerDbNetGrid(dbnetgrid1) } }
HTML
<table> <tr> <td valign=top> <div id=dbnetgrid1></div> </td> <td style='width:10px'> </td> <td valign=top style="border:1pt solid silver;background-color:whitesmoke"> <div id=dbnetedit1> <table> <tr> <td valign=top> <table> <tr> <td>Account</td> <td><input id=customerid class=dbnetedit></td> </tr> <tr> <td>Company</td> <td><input id=companyname class=dbnetedit></td> </tr> <tr> <td>Contact</td> <td><input id=contactname class=dbnetedit></td> </tr> <tr> <td>Phone</td> <td><input id=phone class=dbnetedit></td> </tr> <tr> <td>Fax</td> <td><input id=fax class=dbnetedit></td> </tr> <tr> <td>Address</td> <td><textarea id=address class=dbnetedit></textarea></td> </tr> <tr> <td>City</td> <td><input id=city class=dbnetedit></td> </tr> <tr> <td>Region</td> <td><input id=region class=dbnetedit></td> </tr> <tr> <td>Zip</td> <td><input id=postalcode class=dbnetedit></td> </tr> <tr> <td>Country</td> <td><select id=country class=dbnetedit></select></td> </tr> </table> </td> </tr> <tr> <td align=right> <table> <tr> <td id=toolbar> </td> <!--<td id=editor> </td>--> </tr> </table> </td> </tr> <tr> <td colspan=2 id=messageLine> </td> </tr> </table> </div> </td> </tr> </table>