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 )
function init()
{
jQuery("#filter").bind("keyup",reviewFilter).focus();
var dbnetcombo1 = new DbNetCombo("dbnetcombo1");
with (dbnetcombo1)
{
connectionString = "AdventureWorks"
sql = "select Customer.CustomerID, CompanyName + ' ,' + City " +
"from customer join CustomerAddress on CustomerAddress.CustomerID = Customer.CustomerID " +
"join Address on Address.AddressID = CustomerAddress.AddressID " +
"where companyname like @companyname " +
"order by CompanyName"
parameters["companyname"] = "___";
initialize()
}
}
var timerId = null;
var filterMinChars = 3;
var filterDelay = 1000;
function reviewFilter(e) {
if (timerId)
window.clearTimeout(timerId);
if ( e.target.value.length >= filterMinChars || e.target.value.length == 0)
timerId = window.setTimeout( applyFilter, filterDelay);
}
function applyFilter() {
with (DbNetLink.components["dbnetcombo1"])
{
if (jQuery("#filter").val() == "")
parameters["companyname"] = "___";
else
parameters["companyname"] = "%" + jQuery("#filter").val() + "%";
load()
}
}
</script>
HTML markup
<h3>Customers</h3>
<input id="filter" style="width:300px"></input>
<p/>
<select size=20 id="dbnetcombo1" style="width:300px"></select>