<link href="dbnetsuite.css.ashx" rel="stylesheet" type="text/css" /> <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 = "Customers join Orders on Customers.CustomerID = Orders.CustomerID join [Order Details] on Orders.OrderID = [Order Details].OrderID" setColumnExpressions("Customers.CompanyName","Orders.OrderDate","[Order Details].OrderID","[Order Details].ProductID","[Order Details].UnitPrice","[Order Details].Quantity"); setColumnProperties("OrderID",{"primaryKey" : true, "display" : false, "editDisplay" : false}); setColumnProperties("ProductID",{"primaryKey" : true, "lookup" : "select productid, productname from products"}); setColumnProperty("UnitPrice","format","C"); initialize() } } </script>
<div id="dbnetgrid1"></div>