<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 = "Orders" setColumnExpressions("OrderID","CustomerID","OrderDate","Freight") setColumnProperty(["OrderID","OrderDate","Freight"],"search",false) setColumnProperty("CustomerID",{label : "Customer", lookupSearchMode : "SearchText", lookup : "select CustomerID, CompanyName from Customers" }) searchDialog.closeOnApply = true initialize() } var dbnetgrid2 = new DbNetGrid("dbnetgrid2"); with (dbnetgrid2) { connectionString = "SamplesDatabase" fromPart = "Orders" setColumnExpressions("OrderID","CustomerID","OrderDate","Freight") setColumnProperty(["OrderID","OrderDate","Freight"],"search",false) setColumnProperty("CustomerID",{label : "Customer", lookupSearchMode : "SearchValue", lookup : "select CustomerID, CompanyName from Customers" }) searchDialog.closeOnApply = true initialize() } } </script>
<table> <tr> <td style="vertical-align:top"> <fieldset> <legend>Search Text</legend> <div id="dbnetgrid1"></div> </fieldset> </td> <td style="vertical-align:top"> <fieldset> <legend>Search Values</legend> <div id="dbnetgrid2"></div> </fieldset> </td> </tr> </table>