Include the client JavaScript & CSS libraries

	<link rel="stylesheet" type="text/css" href="dbnetsuite.css.ashx" />
	<script language="JavaScript" src="dbnetsuite.js.ashx"></script>

Client-side configuration script

	<script>
	jQuery(document).ready( init )

	function init()
	{
		var dbnetgrid1 = new DbNetGrid("dbnetgrid1");
		with (dbnetgrid1)
		{
			connectionString = "SamplesDatabase"
			fromPart = "((Orders inner join [Order Details] on Orders.OrderID = [Order Details].OrderID) inner join Products on Products.ProductId = [Order Details].productid)"

			setColumnExpressions(
				"Products.CategoryID",
				"([Order Details].UnitPrice * [Order Details].Quantity) as TotalValue"
				)

			orderBy = "2"

			setColumnProperty("CategoryID","label","Category")
			setColumnProperty("CategoryID","lookup","select CategoryID, CategoryName from categories")

			setColumnProperty("TotalValue","label","Total Value")
			setColumnProperty("TotalValue","format","C")
			setColumnProperty("TotalValue","aggregate","Sum")
			
			groupBy = true;
			toolbarLocation = "hidden"

			chartConfig.height = "190px";
			chartConfig.width = "500px";
			chartConfig.chartPanel = "chartPanel1";
			chartConfig.autoLoad = true;
		
			chartConfig.series.chartType = "Doughnut";
			chartConfig.series.yValueMembers = "TotalValue";
			chartConfig.series.xValueMember = "CategoryID";
			chartConfig.series.isValueShownAsLabel = true;
			chartConfig.series.borderColor = "black"
			chartConfig.series.name = "Total Value";

			chartConfig.title.font = {family : "verdana", size : 14};
			chartConfig.title.text = "Total Sales By Category";

			chartConfig.area3DStyle.enabled = true;
			chartConfig.legend.enabled = true;
			
			chartConfig.series.customAttributes = {};
			chartConfig.series.customAttributes["PieLabelStyle"] = "Outside";
			chartConfig.series.customAttributes["PieDrawingStyle"] = "SoftEdge";

			initialize()
		}
	}


	</script>

HTML markup

<table>
	<tr>
		<td style="vertical-align:top">
			<div id="dbnetgrid1"></div>
		</td>
		<td style="vertical-align:top">
			<div id="chartPanel1" style="border:1pt solid silver"></div>
		</td>
	</tr>
</table>