<link rel="stylesheet" type="text/css" href="dbnetsuite.css.ashx" /> <script language="JavaScript" src="dbnetsuite.js.ashx"></script>
<script> jQuery(document).ready( init ) function init() { var dbnetgrid1 = new DbNetGrid("dbnetgrid1"); with (dbnetgrid1) { connectionString = "SamplesDatabase" fromPart = "[Order Details]" setColumnExpressions("ProductID","UnitPrice","Quantity","(UnitPrice * Quantity)"); setColumnProperty("ProductID", "lookup", "select productid, productname from products"); setColumnProperty("UnitPrice","format", "C"); setColumnProperty("(UnitPrice * Quantity)",{label : "Total", format : "C", aggregate : "Sum"}); initialize() } } </script>
<div id="dbnetgrid1"></div>