Include the Javascript library file

Styles

Client-side script

window.onload = init;

var dbnetlist1, dbnetgrid1;

///////////////////////////////////////////////////////////////////////////
function init()
///////////////////////////////////////////////////////////////////////////
{
	dbnetgrid1 = new DbNetGrid( "dbnetgrid1" )
	with (dbnetgrid1)
	{
		connectionString = "suite"
		fromPart = "orders inner join customers on orders.customerid = customers.customerid"

selectPart = ["country", "city", "companyname", "orderid", "employeeid", "orderdate", "requireddate", "shippeddate", "freight"]
		headings = ["Country", "City", "Company",  "Order #", "Taken By", "Date Ordered", "Date Required", "Date Shipped", "Freight Charge"]
		fixedOrderPart = "country, city, companyname"
		
		primaryKeyColumn = "orderid"	
		editRow = false

setColumnProperty("freight", "format:c")

setColumnLookup("employeeid","employeeid","firstname + ' ' + lastname","employees");

fixedFilterPart = " 1=2"
		pageSize = 16

loadData()
	}

dbnetlist1 = new DbNetList( "dbnetlist1" )
	with ( dbnetlist1 )
	{
		connectionString = "suite"

addTier( "select distinct country, country as id  from customers where country is not null order by country " )
		addTier( "select distinct city, city from customers where country = @country order by city")
		addTier( "select distinct companyname, customerid from customers where city = @city order by companyname" )

onRowSelected = "selectedRow"

loadData()
	}
}

///////////////////////////////////////////////////////////////////////////
function selectedRow(list)
///////////////////////////////////////////////////////////////////////////
{
	var fp

var level = list.selectedRow.getAttribute("dbnlLevel")
	switch (level)
	{
		case '0':
			document.getElementById('ordersLegend').innerText = 'Orders For ' + list.rowValue('country')
			fp = "customers.country = '" + list.rowValue("country") + "'"
			break
		case '1':
			document.getElementById('ordersLegend').innerText = 'Orders For ' + list.rowValue('city')
			fp = "customers.city = '" + list.rowValue("city") + "'"
			break
		case '2':
			document.getElementById('ordersLegend').innerText = 'Orders For ' + list.rowValue('companyname')
			fp = "customers.customerid = '" + list.rowValue("customerid") + "'"
			break;
		default:
			fp = " 1=2"
			break;
	}

with (dbnetgrid1)
	{
		pageNumber = 1
		fixedFilterPart = fp
		loadData()
	}
}

Include the Javascript library file

Styles

Client-side script

HTML