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

			setColumnExpressions("[Product Name]","[Supplier ID]","[Unit Price]","[Product ID]");

            setColumnProperty("Product Name", "required", true);
            setColumnProperty("Unit Price", { required : true, edit : true, format : "c" });
            setColumnProperty("Supplier ID", {required : true, lookup : "select [Supplier ID], [Company Name] + ' (' + Country + ')' from Suppliers"});
            setColumnProperty("Product ID", {display : false, edit : false, primaryKey : true });

			bind("onRecordValidate", validateInsert)
			
			initialize()
		}
	}

	///////////////////////////////////////////////////////////////
	function validateInsert(sender, args)
	///////////////////////////////////////////////////////////////
	{
		if ( sender.mode == "update")
			return;

		var params = {};
		params["supplierID"] = args.parameters["supplier id"];

		var data = sender.executeSingletonQuery("select country from suppliers where [supplier id] = @supplierid", params);
		if (data["country"] == "France" )
		{
			args.message = "We currently are not accepting new products from French suppliers.";
			args.cancel = true;
		}

		args.parameters["discontinued"] = 0;

	}

	</script>

HTML markup

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