<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() { jQuery("#tabs").show(); jQuery("#tabs").tabs(); var dbnetgrid3 = new DbNetGrid("dbnetgrid3"); with (dbnetgrid3) { connectionString = "SamplesDatabase" fromPart = "[Order Details]" setColumnExpressions("OrderID","ProductID","UnitPrice","Quantity"); setColumnProperty("OrderID","foreignKey",true) setColumnProperty("ProductID","editControlType","TextBoxLookup"); setColumnProperty("ProductID","lookup","select productid, productname from products"); } var dbnetgrid2 = new DbNetGrid("dbnetgrid2"); with (dbnetgrid2) { connectionString = "SamplesDatabase" fromPart = "Orders" setColumnExpressions("CustomerID","OrderID","OrderDate","RequiredDate"); setColumnProperty("CustomerID","foreignKey",true) setColumnProperty("OrderID","primaryKey",true) bind("onRowSelected",setOrderDetailsTabTitle) addLinkedControl(dbnetgrid3); } var dbnetgrid1 = new DbNetGrid("dbnetgrid1"); with (dbnetgrid1) { connectionString = "SamplesDatabase" fromPart = "Customers" setColumnExpressions("CustomerID","CompanyName","Address","City"); setColumnProperty("CustomerID","primaryKey",true) pageSize = 10 bind("onRowSelected",setOrderTabTitle) addLinkedControl(dbnetgrid2); initialize() } } function setOrderTabTitle(grid) { jQuery("a[href=#tabs-2]").text( "Orders [" + grid.columnValue("CompanyName") + "]") } function setOrderDetailsTabTitle(grid) { jQuery("a[href=#tabs-3]").text( "Order Lines [" + DbNetLink.Util.dateToString(grid.columnValue("OrderDate")) + "]") } </script>
<table style="width:600px"> <tr> <td> <div id="tabs" style="display:none"> <ul> <li><a href="#tabs-1">Customers</a></li> <li><a href="#tabs-2">Orders</a></li> <li><a href="#tabs-3">Order Lines</a></li> </ul> <div id="tabs-1"><div id="dbnetgrid1"></div></div> <div id="tabs-2"><div id="dbnetgrid2"></div></div> <div id="tabs-3"><div id="dbnetgrid3"></div></div> </div> </td> </tr> </table>