<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 dbnetgrid2 = new DbNetGrid("dbnetgrid2"); with (dbnetgrid2) { connectionString = "SamplesDatabaseAccess" procedureName="[Sales By Category]" procedureParameters = { CategoryName : "" } setColumnProperty("ProductSales","format","C"); setColumnProperty("CategoryID","display",false); setColumnProperty("CategoryName","display",false); navigation = false rowInfo = false } var dbnetgrid1 = new DbNetGrid("dbnetgrid1"); with (dbnetgrid1) { connectionString = "SamplesDatabaseAccess" fromPart = "Categories" setColumnExpressions("CategoryName"); bind("onRowSelected",loadSalesByCategory); navigation = false rowInfo = false initialize() } } ///////////////////////////////////////////////// function loadSalesByCategory(grid) ///////////////////////////////////////////////// { var categoryName = grid.columnValue("categoryName") with (DbNetLink.components["dbnetgrid2"]) { procedureParameters = { CategoryName : categoryName } initialize() } } </script>
<table> <tr> <td style="vertical-align:top"> <fieldset> <legend>Categories</legend> <div id="dbnetgrid1"></div> </fieldset> </td> <td style="vertical-align:top"> <fieldset> <legend>Sales Summary</legend> <div id="dbnetgrid2"></div> </fieldset> </td> </tr> </table>