Bar Chart

OrderIDUnitPriceQty
10348 21.6 40
10365 16.8 24
10367 44.3 76
10375 24.5 25
10380 86.1 74
10390 61.8 169
10394 44.2 20
10400 129.4 86
10405 8 50
10415 33.2 22

bottom next goreload

[1 - 10 : 1624]

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