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 = "Products"

			setColumnExpressions("ProductID","ProductName","SupplierID","CategoryID","UnitPrice","Discontinued");
			setColumnProperty("ProductID","display",false);
			setColumnProperty("SupplierID",{lookup : "select supplierid, companyname from suppliers",editControlType : "TextBoxLookup", inlineEdit : true});
			setColumnProperty("CategoryID",{lookup : "select categoryid, categoryname from categories", inlineEdit : true});
			setColumnProperty("UnitPrice",{format : "C", inlineEdit : true, required : true});
			setColumnProperty("Discontinued",{inlineEdit : true});
			updateRow = false

			bind("onFieldValueChanged", setUnitPrice)
			bind("onPageLoaded", disableDiscontinued)
			bind("onColumnValidate", validateColumn)

			pageSize = 10

			initialize()
		}
	}

	function disableDiscontinued(sender, args)
	{
		var rows = jQuery(args.table).find("tr.data-row");

		for (var i=0; i<(rows.length); i++)
		{
			if(sender.columnValue("discontinued",rows[i]) == true)
				jQuery(rows[i]).find("*").attr("disabled","disabled").unbind();
		}
	}

	function setUnitPrice(sender, args)
	{
		switch(args.columnName.toLowerCase())
		{
			case "supplierid":
				sender.getInputControl("unitprice",args.row).val("0.00")
				break;
		}
	}

    ///////////////////////////////////////////////////////////////
    function validateColumn(sender, args)
    ///////////////////////////////////////////////////////////////
    {
		switch(args.columnName.toLowerCase())
		{
			case "unitprice":
				if ( args.columnValue <= 0)
				{
					args.message = "Unit price must be greater than 0";
					args.cancel = true;
				}
				break;
        }
    }

	</script>

HTML markup

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