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("CompanyName","Address","postalcode","city","region", "country");
			setColumnLabels("CompanyName","Address","Zip","City", "State","Country");

			fixedFilterSql = "country = 'USA'"

			bind("onFieldValueChanged", getCityAndState);

			initialize()
		}
	}

	function getCityAndState(sender, args)
	{
		switch(args.editField.getAttribute("columnName"))
		{
			case "postalcode":
				var data = sender.executeSingletonQuery("select * from zip where zip = @zipcode", {zipcode : args.editField.value});
				if (data)
				{
					sender.getInputControl("city").val(data.city)
					sender.getInputControl("region").val(data.state)
					sender.getInputControl("country").val("USA")
				}
				break;
		}

	}


	</script>

HTML markup

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