Bar Chart

OrderIDUnitPriceQty
10430 113.6 195
10436 72.8 99
10438 34.1 50
10440 150.9 208
10441 35.1 50
10443 53.2 18
10444 78.2 63
10445 20.3 21
10446 26.5 50
10447 41.3 77

bottom next goreload

[1 - 10 : 1465]

Bar Chart
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
  Dim Bar As New Tornado.z
  With Bar
    .dbQP = "U=15| D=nwind| S=13| PS=10| M=Gc"
    .dbSQL = "SELECT OrderID, sum(UnitPrice) as UnitPrice, sum(Quantity) as Qty from [Order details] Group by OrderId"
    .dbBarChart = "Label=#0#| DataSet0=#1#| DataSet1=#2#| DataSet2=43,89,21,65,52,157,10,47,76,111"
    .dbTextHolder = "Title=Bar Chart"
    .ASPdbNET()
  End With
End Sub
</script>
Simplified BarChart - Just specify the dbBarChart and override default parameters with dbChartParams. Dataset can be from DB 'Fields" or User. This example has 2 datasets from DB and one from user. Inspect applet HTML code for default values.

Send comments on this topic.
Copyright (c) 1998-2006 ASP-db