Include the Javascript library file

Client-side script

window.onload = initGrid

var dbnetgrid1, dbnetgrid2

//////////////////////////////////////////////////////////////////////////////////////////////
function initGrid()
//////////////////////////////////////////////////////////////////////////////////////////////
{
	dbnetgrid2 = new DbNetGrid("dbnetgrid2")

with (dbnetgrid2)
	{
		connectionString = "samples"
		headings = ["Customer","OrderID","Freight","Product","Unit Price","Quantity","Gross Value", "Discount (%)", "Net Value"]
		selectPart = [
			"orders.customerid",
			"orders.orderid",
			"freight",
			"products.productname",
			"[order details].unitprice",
			"quantity", 
			"([order details].unitprice * quantity) as order_value", 
			"discount", 
			"([order details].unitprice  * (1 - discount)) * quantity as total" 
			]

searchLabels = ["Customer","City","Country","Product","Order Date"]
		searchFields = ["customers.companyname","customers.city","customers.country","products.productname","orders.orderdate"]

outputMode = true
		outputCurrentPageOnly = true

pageSize = 10

fromPart = "((customers " +
			"inner join orders on orders.customerid = customers.customerid) " +
			"inner join [order details] on [order details].orderid = orders.orderid) " +
			"inner join products on [order details].productid = products.productid"
		
		searchFromPart = fromPart

addTotalBreak("country", "Country {}");
		addTotalBreak("city", "City {}");
		addTotalBreak("orders.customerid", "Customer {}");
		addTotalBreak("orders.orderid","Order Id {}");

totalColumns = ["order_value", "total", "avg:discount"]
		totalDuplicatedColumns = ["customerid","orderid","orderdate","shippeddate","requireddate","freight"]

setColumnLookup("customerid","customerid","companyname","customers")

setColumnProperty('freight','format:n')
		setColumnProperty('unitprice','format:c')
		setColumnProperty('discount','format:p')
		setColumnProperty('order_value','format:c')
		setColumnProperty('total','format:c')

loadData()
	}

}

Include the Javascript library file

Client-side script

HTML