Include the client JavaScript & CSS libraries
<link rel="stylesheet" type="text/css" href="dbnetsuite.css.ashx" />
<script language="JavaScript" src="dbnetsuite.js.ashx"></script>
Client-side configuration script
<script>
jQuery(document).ready( init )
var toolbarOptions = ["Search","Quick Search","Insert Row","Delete Row","Navigation", "Browse"];
var buttonStyles = ["Image","Text","ImageAndText"];
var table = jQuery("#toolbarOptions");
for (var i=0; i<toolbarOptions.length; i++)
{
var row = table[0].insertRow(-1);
var cell = row.insertCell(-1);
cell.innerHTML = toolbarOptions[i].replace(" "," ");
if ( toolbarOptions[i] == "Copy")
cell.innerHTML += " (IE Only)";
cell.style.paddingLeft = "10px";
cell = row.insertCell(-1);
var cb = jQuery(document.createElement("INPUT"));
cb.attr("type","checkbox");
cb.attr("id",toolbarOptions[i].replace(/ /g,"") + "Cb");
cb.appendTo(jQuery(cell));
}
table.find("input").attr("checked","checked");
table.find("input").bind("click",init);
for (var i=0; i<buttonStyles.length; i++)
{
var option = document.createElement("OPTION")
option.value = buttonStyles[i]
option.text = buttonStyles[i]
jQuery("#buttonStyles")[0].options.add(option);
}
jQuery("#buttonStyles").bind("change",init);
function init()
{
var dbnetedit1 = new DbNetEdit("dbnetedit1");
dbnetedit1.connectionString = "SamplesDatabase"
dbnetedit1.setColumnExpressions("ProductID","ProductName","UnitPrice","Discontinued")
for (var i=0; i<toolbarOptions.length; i++)
{
var option = toolbarOptions[i].replace(/ /g,"");
var id = option.substr(0,1).toLowerCase() + option.substr(1);
dbnetedit1[id] = document.getElementById(option + "Cb").checked
}
dbnetedit1.setColumnProperty("productname","browse",document.getElementById("BrowseCb").checked)
dbnetedit1.toolbarButtonStyle = jQuery("#buttonStyles").val();
dbnetedit1.fromPart = "Products"
dbnetedit1.initialize()
}
</script>
HTML markup
<table>
<tr>
<td style="vertical-align:top">
<fieldset style="background-color:whitesmoke">
<legend>Toolbar Options</legend>
<table id="toolbarOptions"></table>
</fieldset>
<fieldset style="background-color:whitesmoke">
<legend>Button Style</legend>
<select id="buttonStyles"></select>
</fieldset>
</td>
<td style="vertical-align:top">
<div id="dbnetedit1"></div>
</td>
</tr>
</table>