Register the component libraries

<%@ Register TagPrefix="DNL" Assembly="DbNetLink.DbNetSuiteVS" Namespace="DbNetLink.DbNetSuiteVS" %>

Server Control

    <DNL:DbNetGrid 
        ID="DbNetGrid1" 
        runat="server" 
        ConnectionString="SamplesDatabaseVistaDB" 
	    GroupBy="true"
	    FromPart="Orders join [Order Details] on Orders.OrderID = [Order Details].OrderID join Products on [Order Details].ProductID = Products.ProductID">
        <Columns>
            <DNL:GridColumn ColumnExpression="Products.ProductID"  Label="Product" Lookup="select productid, productname from products"/>
            <DNL:GridColumn ColumnExpression="Orders.OrderDate" Label="Last Order" Aggregate="Max" Format="MMM yyyy" />
            <DNL:GridColumn ColumnExpression="([Order Details].UnitPrice * [Order Details].Quantity)" Label="Total Value" Aggregate="Sum" Format="C" />
        </Columns>
    </DNL:DbNetGrid>