Register the component libraries

Server Control

<form id="Form1" name="Form1" method="post" runat="server">
	<table>
		<tr>
			<td>
				<DNL:DbNetGrid 
					id="dbnetgrid1" 
					runat="server" 
					ConnectionString = "samples"
					FromPart = "[order details]"

SelectPart = "productid, count(*) as mycount, avg(unitprice) as unitprice, Sum(quantity) as quantity, Sum(unitprice*quantity) as total_value, Avg(discount) as disc"
					Headings = "Product Name, Count, Avg. Unit Price, Total Quantity, Total Value, Avg. Discount"
					
					OrderColumn = '2'
					OrderSequence = 'desc'

Chart = true
					GroupBy = "productid"
					Having = "count(*) > 5"
					>
					<GridColumnProperties>
						<DNL:ColumnProperty ColumnName="quantity" Property="format" Value="#,###,##0"></DNL:ColumnProperty>
						<DNL:ColumnProperty ColumnName="total_value" Property="format" Value="N"></DNL:ColumnProperty>
						<DNL:ColumnProperty ColumnName="unitprice" Property="format" Value="N"></DNL:ColumnProperty>
						<DNL:ColumnProperty ColumnName="disc" Property="format" Value="p"></DNL:ColumnProperty>
					</GridColumnProperties>
					<GridColumnLookups>
						<DNL:GridColumnLookup ColumnName="ProductID" ForeignKeyColumn="ProductID" ForeignDescriptionColumn="ProductName" ForeignTable="products"></DNL:GridColumnLookup>
					</GridColumnLookups>
				</DNL:DbNetGrid>
			</td>
		</tr>
	</table>

</form>