Include the Javascript library file

Client-side script

window.onload = init
var selectedTab, dbnetgrid1

//////////////////////////////////////////////////////////////////////////////////////////////
function init()
//////////////////////////////////////////////////////////////////////////////////////////////
{
	createTabs()

dbnetgrid1 = new DbNetGrid( "dbnetgrid1" )

with (dbnetgrid1)
	{	
		connectionString = "samples"
		fromPart = "customers"
		orderColumn = 'companyname'
		pageSize  =3
		selectCustomers()
	}
}

//////////////////////////////////////////////////////////////////////////////////////////////
function createTabs()
//////////////////////////////////////////////////////////////////////////////////////////////
{
	var tabs = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
	
	var table = document.getElementById("tabs")
	var row = table.insertRow(-1)
	var cell

for ( var i = 0; i < tabs.length; i++ )
	{
		cell = row.insertCell(-1)
		cell.innerHTML = tabs.substr(i,1)
		if (i == 0)
			cell.className = 'selectedTab'
		else
			cell.className = 'tab'
		cell.onclick = dbNetLink.assignHandler("selectCustomers")
		cell = row.insertCell(-1)
		cell.innerHTML = "&nbsp;"
		cell.className = "tabSpacer"
	}

cell = row.insertCell(-1)
	cell.className = "tabFill"
	cell.innerHTML = '&nbsp;&nbsp;&nbsp;&nbsp;<input size=10 id=searchToken type=text></input><button id=findBtn>Find</button>'
	document.getElementById("findBtn").onclick = find

selectedTab = row.cells[0]
}

//////////////////////////////////////////////////////////////////////////////////////////////
function selectCustomers(event)
//////////////////////////////////////////////////////////////////////////////////////////////
{
	selectedTab.className = 'tab'

if (event)
		selectedTab = event.srcElement

selectedTab.className = 'selectedTab'

with (dbnetgrid1)
	{
		filterPart = "companyname like '" + selectedTab.innerText + "%'"
		pageNumber = 1
		loadData()
	}
}

//////////////////////////////////////////////////////////////////////////////////////////////
function find()
//////////////////////////////////////////////////////////////////////////////////////////////
{
	var searchText = document.getElementById("searchToken").value
	var searchColumns = ['companyname','contactname','address','city', 'phone']

with (dbnetgrid1)
	{
		filterPart = ''
		for (var i=0;i<searchColumns.length;i++)
		{
			if (filterPart != '')
				filterPart += ' or '
			filterPart +=  searchColumns[i] + " like '%" + searchText + "%'"
		}
		loadData()
	}
}