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 = "Customers"
			setColumnExpressions("CustomerID","CompanyName","Address + ', ' + City as addr","Address","City","Phone + '/' + Fax as phone_fax","Phone","Fax");
			setColumnLabels("CustomerID","CompanyName","Address","Address","City","Phone/Fax","Phone","Fax");

			setColumnProperty("companyname","required",true);
			setColumnProperty("addr","edit",false);
			setColumnProperty("address","display",false);
			setColumnProperty("city","display",false);
			setColumnProperty("phone_fax","edit",false);
			setColumnProperty("phone","display",false);
			setColumnProperty("fax","display",false);

			bind("onBeforeRecordDeleted", checkOrders)
			initialize()
		}
	}

	function checkOrders(grid, args)
	{
		var params = {"customerid" : grid.selectedRows()[0].id }
		var data = grid.executeSingletonQuery("select count(*) as ctr from orders where customerid = ?", params  );
		
		if (data.ctr > 0)
		{
			args.message = "A customer with orders cannot be deleted";
			args.cancel = true;
		}
	}

	</script>

HTML markup

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