|
|||||
|
|||||
<%@ Register TagPrefix="DNL" Assembly="DbNetLink.DbNetSuiteVS" Namespace="DbNetLink.DbNetSuiteVS" %>
<table>
<tr>
<td style="vertical-align: top">
<fieldset>
<legend>Customers</legend>
<DNL:DbNetGrid
runat="server"
id="CustomersGrid"
ConnectionString="SamplesDatabase"
FromPart="Customers" >
<Columns>
<DNL:GridColumn ColumnExpression="CompanyName" />
<DNL:GridColumn ColumnExpression="Address" />
<DNL:GridColumn ColumnExpression="City" />
</Columns>
</DNL:DbNetGrid>
</fieldset>
</td>
<td style="vertical-align: top">
<fieldset>
<legend>Orders</legend>
<DNL:DbNetGrid
runat="server"
id="OrdersGrid"
ConnectionString="SamplesDatabase"
FromPart="Orders"
ParentControlID="CustomersGrid"
PageSize=10 >
<Columns>
<DNL:GridColumn ColumnExpression="CustomerID" Display="false" ForeignKey="true" />
<DNL:GridColumn ColumnExpression="OrderID" />
<DNL:GridColumn ColumnExpression="OrderDate" />
<DNL:GridColumn ColumnExpression="RequiredDate" />
<DNL:GridColumn ColumnExpression="ShippedDate" />
<DNL:GridColumn ColumnExpression="Freight" />
</Columns>
</DNL:DbNetGrid>
</fieldset>
<fieldset>
<legend>Order Details</legend>
<DNL:DbNetGrid
runat="server"
id="OrderDetailsGrid"
ConnectionString="SamplesDatabase"
FromPart="[Order Details]"
ParentControlID="OrdersGrid"
PageSize=10 >
<Columns>
<DNL:GridColumn ColumnExpression="OrderID" Display="false" ForeignKey="true" />
<DNL:GridColumn ColumnExpression="ProductID" Label="Product" Lookup="select productid, productname from products"/>
<DNL:GridColumn ColumnExpression="UnitPrice" />
<DNL:GridColumn ColumnExpression="Quantity" />
<DNL:GridColumn ColumnExpression="Discount" Format="p" />
</Columns>
</DNL:DbNetGrid>
</fieldset>
</td>
</tr>
</table>