Include the Javascript library file

Client-side script

window.onload = initGrid
//////////////////////////////////////////////////////////////////////////////////////////////
function initGrid()
//////////////////////////////////////////////////////////////////////////////////////////////
{
	var dbnetgrid1 = new DbNetGrid("dbnetgrid1")

with (dbnetgrid1)
	{
		connectionString = "samples"
		fromPart = "[products]"
		selectPart = ["ProductName","QuantityPerUnit","UnitPrice","UnitsInStock","UnitsOnOrder","ReorderLevel","Discontinued"];
		headings = ["Product Name","Quantity Per Unit","Unit Price","Units In Stock","Units On Order","Reorder Level","Discontinued"];

setColumnProperty("Discontinued","transform:DiscontinuedCellTransform");
		
		setEditColumnProperty("Discontinued","insertReadOnly:true");
		setEditColumnProperty("discontinued","initialValue:true");

primaryKeyColumn = "productid"

editRowInitialisation = "initialiseEditRow"
		loadData()
	}
}

//////////////////////////////////////////////////////////////////////////////////////////////
function initialiseEditRow( editControl )
//////////////////////////////////////////////////////////////////////////////////////////////
{
	if (editControl.mode != 'update') // Don't apply to records being added
		return

var discontinued = editControl.inputControl('discontinued').checked
	editControl.inputControl('ProductName').readOnly = discontinued
	editControl.inputControl('QuantityPerUnit').readOnly = discontinued
	editControl.inputControl('UnitsInStock').readOnly = discontinued
	editControl.inputControl('UnitsOnOrder').readOnly = discontinued
	editControl.inputControl('ReorderLevel').readOnly = discontinued
	editControl.inputControl('UnitPrice').readOnly = discontinued
}

//////////////////////////////////////////////////////////////////////////////////////////////
function DiscontinuedCellTransform( cell )
//////////////////////////////////////////////////////////////////////////////////////////////
{
	var checked = ""
	if (cell.innerText == 'Yes' || cell.innerText.toLowerCase() == 'true' )
		checked = "checked"

cell.innerHTML = "<input type=checkbox " + checked + " style='height:14px;margin:0px;' onclick='return false;'></input>"
	cell.style.textAlign = "center"
}