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();
		jQuery("#selectBtn").bind("click",selectCustomer);
	
		var dbnetlist2 = new DbNetList("dbnetlist2");
		
		with (dbnetlist2)
		{
			connectionString = "AdventureWorks"
			sql = "select CompanyName, City, StateProvince, Customer.CustomerID " +
				"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"] = "___";			
			height = "200px"
			width = "400px"
			headerRow = true
			rowSelection = true
			setColumnProperty("companyname","label","Company Name" )
			setColumnProperty("StateProvince","label","State/Province" )
			setColumnProperty("CustomerID","display",false)
			bind("onItemsLoaded",listLoaded)
			
			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["dbnetlist2"])
		{
			if (jQuery("#filter").val() == "")
				parameters["companyname"] = "___";
			else
				parameters["companyname"] = "%" + jQuery("#filter").val() + "%";
			load()
		}	
	}
	
	function selectCustomer(e) {
		alert( "Customer ID:" + DbNetLink.components["dbnetlist2"].columnValue("customerid") + " selected")
	}	
	
	function listLoaded(sender){
		jQuery("#selectBtn")[0].disabled = (sender.dataRows.length == 0)
	}	
	
	</script>

HTML markup

<h3>Customers</h3>
<input id="filter" style="width:300px"></input>
<p/>
<div id="dbnetlist2"></div>
<p/>
<button id="selectBtn" type="button">Select</button>