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 = "Employees"
			setColumnExpressions("EmployeeID","LastName","FirstName","BirthDate","HireDate","Address","City","Region","PostalCode","Country","HomePhone","Extension","Photo","Notes","ReportsTo");
			setColumnProperty("Photo", "uploadExtFilter", "jpg,gif,png");
			setColumnProperty("Photo", "display", false);
			setColumnProperty("Notes", "display", false);
			setColumnProperty("ReportsTo","lookup","select employeeid, lastname + ',' + firstname from employees order by lastname,firstname");

			editDialog.closeOnApply = true;
			
			setColumnProperty("FirstName", "placeHolder", "Forename");
			setColumnProperty("LastName", "placeHolder", "Surname");
			setColumnProperty("Address", "placeHolder", "Address lines 1 and 2");

			bind("onColumnValidate", validateColumn)
			bind("onRecordValidate", validateRow)
			
			initialize()
		}
	}

    ///////////////////////////////////////////////////////////////
    function validateColumn(sender, args)
    ///////////////////////////////////////////////////////////////
    {
		switch (args.columnName.toLowerCase())
		{
			case "birthdate":
				if (args.columnValue) // Birth date is not null
				{
					if (( new Date().getFullYear() - args.columnValue.getFullYear()) < 17) // Not a proper test !
					{
						args.message = "Person is not old enough";
						args.cancel = true;
					}
				}
				break;

			case "hiredate":
				if (args.columnValue) // Hire date is not null
					if (args.columnValue.valueOf() > new Date().valueOf())
					{
						args.message = "Hire date cannot be in the future";
						args.cancel = true;
					}
				break;
        }
        
        return true;
    }

    ///////////////////////////////////////////////////////////////
    function validateRow(sender, args)
    ///////////////////////////////////////////////////////////////
    {
        if (sender.mode == "insert") // Ignore records being inserted
            return;
        
        if (args.parameters["reportsto"]) // If ReportsTo has been modified 
            if ( args.parameters["reportsto"] != "" ) // and ReportsTo is not null
				if ( args.parameters["reportsto"] == args.currentRecord["employeeid"] ) // If ReportsTo same as Employee
				{
					args.message = "An employee cannot report to him/her self";
					args.columnToHighlight = "reportsto"; // Specify the name of the column to highlight
					args.cancel = true;
				}

        return;
    }



	</script>

HTML markup

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