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 dbnetgrid1 = new DbNetGrid("dbnetgrid1");
		with (dbnetgrid1)
		{
			connectionString = "SamplesDatabase"
			fromPart = "Orders join [Order Details] on Orders.OrderID = [Order Details].OrderID"

			setColumnExpressions(
				"[Order Details].ProductID",
				"Orders.OrderDate as FirstOrder",
				"Orders.OrderDate as LastOrder",
				"([Order Details].UnitPrice * [Order Details].Quantity) as TotalValue",
				"([Order Details].UnitPrice * [Order Details].Quantity) as AvgValue"
				)

			groupBy = true

			setColumnProperty("ProductID","label","Product")
			setColumnProperty("ProductID","lookup","select productid, productname from products")


			setColumnProperty("FirstOrder","label","First Order")
			setColumnProperty("FirstOrder","aggregate","min")
			setColumnProperty("FirstOrder","format","MMM yyyy")

			setColumnProperty("LastOrder","label","Last Order")
			setColumnProperty("LastOrder","aggregate","max")
			setColumnProperty("LastOrder","format","MMM yyyy")

			setColumnProperty("TotalValue","label","Total Value")
			setColumnProperty("TotalValue","aggregate","Sum")
			setColumnProperty("TotalValue","format","C")

			setColumnProperty("AvgValue","label","Avg Value")
			setColumnProperty("AvgValue","aggregate","Avg")
			setColumnProperty("AvgValue","format","C")

			initialize()
		}
	}
	</script>

HTML markup

	<div id="dbnetgrid1"></div>