Example
Source
Run as client-side object
Instances of DbNetGrid can be linked together to create powerful drill-down capabilities.
Customers
Orders
Order Lines
Register the component libraries
<%@ Register TagPrefix="DNL" Namespace="DbNetLink.Web.UI" Assembly="DbNetLink.DbNetGrid" %>
Server Control
<form id="Form1" name="Form1" method="post" runat="server"> <table> <tr> <td colspan="2"> <fieldset> <legend>Customers</legend> <DNL:DbNetGrid id="dbnetgrid1" runat="server" ConnectionString = "samples" Headings = "Customer Code,Customer Name,Address,City,Region,Phone,Fax" SelectPart = "customerid,companyname,address,city,region,phone,[fax]" FromPart = "customers" PrimaryKeyColumn = "customerid" PageSize = "10" VirtualDir = ".."> <DetailGrids> <DNL:DetailGrid GridID="dbnetgrid2" ForeignKeyColumn="customerid"></DNL:DetailGrid> </DetailGrids> </DNL:DbNetGrid> </fieldset> </td> </tr> <tr> <td> <fieldset><legend>Orders</legend> <DNL:DbNetGrid id="dbnetgrid2" runat="server" ConnectionString = "samples" Headings = "Order ID,Order Date,Shipped Date,Required Date,Freight,Customer ID" SelectPart = "orderid,orderdate,shippeddate,requireddate,freight,customerid" FromPart = "orders" PrimaryKeyColumn = "orderid" PageSize = 5 Help = "false" RowInfo = "false" PageInfo = "false" > <DetailGrids> <DNL:DetailGrid GridID="dbnetgrid3" ForeignKeyColumn="orderid"></DNL:DetailGrid> </DetailGrids> </DNL:DbNetGrid> </fieldset> </td> <td valign=top> <fieldset><legend>Order Lines</legend> <DNL:DbNetGrid id="dbnetgrid3" runat="server" ConnectionString = "samples" Headings = "Product,Unit Price,Quantity,Discount (%)" SelectPart = "productname,[order details].unitprice,quantity,(discount * 100) as discount" FromPart = "[order details] inner join products on [order details].productid = products.productid" PageSize = 5 Office = "false" Help = "false" RowInfo = "false" PageInfo = "false" > </DNL:DbNetGrid> </fieldset> </td> </tr> </table> </form>