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","Title","TitleOfCourtesy","BirthDate","HireDate","Address","City","Region","PostalCode","Country","HomePhone")

			bind('onInitialized', initForm);
			bind('onInsertInitialize', setDefaultValues);
			bind('onToolbarConfigured', setCopyButtonState);

			initialize()
		}
	}

	function initForm(control)	{
		var btn = jQuery(control.addToolbarButton(3));
		btn.html( jQuery(control.toolbarElement("insertRow")).html() ).attr("id","copyEmployeeBtn");
		btn.find(".tool-button-text").html("&nbsp;Copy").css('width','55px').css('text-align','right');
		btn.click( copySelectedRecord );
	}
	
	function setCopyButtonState(sender, args) {
		var disabled = (sender.totalRows == 0);
		jQuery("#copyEmployeeBtn").attr("disabled",disabled ? "disabled" : ""); 
	}	
	

	var copyAdd = false
	function copySelectedRecord(control)
	{
		copyAdd = true;
		DbNetLink.components["dbnetgrid1"].toolbarElement("insertRow").click();
	}

	function setDefaultValues(control)
	{
		if (!copyAdd)
			return;

		var grid = DbNetLink.components["dbnetgrid1"];
		var employeeID = grid.columnValue("employeeid");
		
		var data = grid.executeSingletonQuery("select * from employees where employeeid = @employeeid",{employeeid : employeeID});

		for (key in data)
		{
			var inputControl = control.getInputControl(key);
			if (!inputControl)
				continue;

			switch(key.toLowerCase())
			{
				case "employeeid":
				case "photo":
				case "notes":
				case "birthdate":
					break;
				case "hiredate":
					control.setInputControlValue(key, DbNetLink.Util.dateToString(data[key]));
					break;
				default:
					control.setInputControlValue(key, data[key]);
					break;
			}
		}
		
		copyAdd = false;
		return 
	}


	</script>

HTML markup

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