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()
	{
		var dbnetlist1 = new DbNetList("dbnetlist1");

		with (dbnetlist1)
		{
			connectionString = "SamplesDatabase"
			sql = "select distinct country from customers where country is not null order by country"
			addNestedList( configureCityList )
			initialize()
		}
	}


	function configureCityList(list)
	{
		with (list)
		{
			sql = "select distinct city from customers where country = @country order by city"
			parameters = {"country" : "" };
			addNestedList( configureCustomersList )
		}
	}

	function configureCustomersList(list)
	{
		with (list)
		{
			sql = "select companyname, customerid from customers where city = @city order by companyname"
			parameters = {"city" : "" }
			setColumnProperty("customerid","display",false)
			addNestedList( configureOrdersList )
		}
	}

	function configureOrdersList(list)
	{
		with (list)
		{
			sql = "select orderdate, orderid from orders where customerid = @customerid order by orderdate"
			parameters = {"customerid" : "" }
			setColumnProperty("orderdate","format","D")
			addNestedList( configureOrderDetailsList )
			setColumnProperty("orderid","display",false)
		}
	}

	function configureOrderDetailsList(list)
	{
		with (list)
		{
			sql = "select productname, quantity from [order details] join products on products.productid = [order details].productid where orderid = @orderid order by productname"
			parameters = {"orderid" : "" }
			setColumnProperty("productname","label","Product Name")
			setColumnProperty("quantity","label","Qty")
			headerRow = true;
		}
	}

	</script>

HTML markup

<div id="dbnetlist1"></div>