Bar Chart

OrderIDUnitPriceQty
10277 75.8 32
10329 269.2 50
10337 95.9 137
10338 51.9 35
10348 21.6 40
10349 5.9 24
10353 227.6 62
10356 58 62
10357 76.9 54
10358 30 40

bottom next goreload

[1 - 10 : 1814]

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